Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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
