Google Cloud Professional Data Engineer PDE — Topic 1 Question 184

Question

You are building a report-only data warehouse where the data is streamed into BigQuery via the streaming API. Following Google's best practices, you have both a staging and a production table for the data. How should you design your data loading to ensure that there is only one master dataset without affecting performance on either the ingestion or reporting pieces?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: 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. This option meets the real-time / low-latency performance requirement.

Google Cloud Professional Data Engineer PDE — Question 184