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