Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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.