Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
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?
Explanation:
The optimal strategy involves transferring the staged data to the production table and clearing the staging table contents every three hours (Option C). This method ensures efficiency and minimizes impact on performance. Reference: Google Cloud Blog