Answer-first summary for fast verification
Answer: Transfer data from the staging table to the production table and clear the staging table every three hours.
The correct strategy is to transfer data from the staging table to the production table and clear the staging table every three hours. This ensures the production table remains up-to-date without performance degradation. Frequent updates (Options A and B) can hinder performance, while too frequent deletions (Option D) risk data loss and inconsistency.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In a report-only data warehouse setup, data is streamed into BigQuery via the streaming API, with separate staging and production tables to follow Google's best practices. What is the optimal data loading strategy to maintain a single master dataset without compromising ingestion or reporting performance?
A
Implement a staging table with an append-only model, updating the production table every ninety minutes with changes from staging.
B
Use a staging table with an append-only model, updating the production table every three hours with changes from staging.
C
Transfer data from the staging table to the production table and clear the staging table every three hours.
D
Transfer data from the staging table to the production table and clear the staging table every thirty minutes.
No comments yet.