Exam Professional-Data-Engineer Topic 4 Question 53 Discussion

Actual exam question for Google's Professional-Data-Engineer exam
Question #: 53
Topic #: 4

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?

A. 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 B. 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 C. 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 D. 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

Comments

avishop12

2026-06-02 07:32:42

Answer should be A, as 30mins copy/purge is an overhead for BigQuery

upvoted 1 times

...

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business