Big Halloween Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 3 Topic 1 Discussion

Google Professional Data Engineer Exam Professional-Data-Engineer Question # 3 Topic 1 Discussion

Professional-Data-Engineer Exam Topic 1 Question 3 Discussion:
Question #: 3
Topic #: 1

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?


A.

Create a table called tracking_table and include a DATE column.


B.

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


C.

Create sharded tables for each day following the pattern tracking_table_YYYYMMDD.


D.

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


Get Premium Professional-Data-Engineer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.