Explanation:
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
Ultimate access to all questions.
No comments yet.
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