Google Professional Data Engineer
Get started today
Ultimate access to all questions.
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?
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?
Real Exam
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