You are tasked with constructing a report-only data warehouse that utilizes BigQuery, where data is continuously streamed using the streaming API. Following Google's best practices for handling such data, you have established both staging and production tables. In keeping with these best practices, what approach would you take to design the data loading process to ensure a single master dataset exists while maintaining optimal performance for both data ingestion and report generation?

Exam-Like

Have a staging table that is an append-only model, and then update the production table every three hours with the changes written to staging.

23.5%

Have a staging table that is an append-only model, and then update the production table every ninety minutes with the changes written to staging.

19.6%

Have a staging table that moves the staged data over to the production table and deletes the contents of the staging table every three hours.

43.1%

Have a staging table that moves the staged data over to the production table and deletes the contents of the staging table every thirty minutes.

13.7%

Google Professional Data Engineer