Google Exam Professional Data Engineer Topic 1 Question 38 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 38
Topic #: 1

[All Professional Data Engineer Questions]

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?

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

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

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

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

Show Suggested Answer

Suggested Answer: D

by Mireya at May 10, 2022, 01:38 AM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!