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 the staged data to the production table and clearing the staging table contents every three hours (Option C). This method ensures efficiency and minimizes impact on performance. 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.
No comments yet.
When designing data loading for 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 affecting ingestion or reporting performance?
A
Transfer staged data to the production table and clear the staging table every thirty minutes.
B
Use an append-only staging table and update the production table with changes every ninety minutes.
C
Transfer staged data to the production table and clear the staging table every three hours.
D
Use an append-only staging table and update the production table with changes every three hours.