Answer-first summary for fast verification
Answer: Transfer staged data to the production table and clear the staging table every three hours
The optimal strategy involves transferring staged data to the production table and clearing the staging table every three hours. This approach ensures data integrity and minimizes performance impacts. Reference: [Google Cloud Blog](https://cloud.google.com/blog/products/data-analytics/moving-a-publishing-workflow-to-bigquery-for-new-data-insights)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When designing data loading in a report-only data warehouse using BigQuery's streaming API, how should you manage staging and production tables to maintain a single master dataset without impacting ingestion or reporting performance?
A
Update the production table with changes from an append-only staging table every ninety minutes
B
Transfer staged data to the production table and clear the staging table every thirty minutes
C
Transfer staged data to the production table and clear the staging table every three hours
D
Update the production table with changes from an append-only staging table every three hours
No comments yet.