Google Exam Professional Data Engineer Topic 3 Question 33 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 33
Topic #: 3

[All Professional Data Engineer Questions]

Given the record streams MJTelco is interested in ingesting per day, they are concerned about the cost of Google BigQuery increasing. MJTelco asks you to provide a design solution. They require a single large data table called tracking_table. Additionally, they want to minimize the cost of daily queries while performing fine-grained analysis of each day's events. They also want to use streaming ingestion. What should you do?

ACreate a table called tracking_table and include a DATE column.

BCreate a partitioned table called tracking_table and include a TIMESTAMP column.

CCreate sharded tables for each day following the pattern tracking_table_YYYYMMDD.

DCreate a table called tracking_table with a TIMESTAMP column to represent the day.

Show Suggested Answer

Suggested Answer: B

by Marguerita at May 06, 2022, 09:54 PM

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!