Given the record streams MJTelco is interested in ingesting per day, they are concerned about...

Question

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?

Accepted Answer

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

Answer

A. Create a table called tracking_table and include a DATE column.

Answer

C. Create sharded tables for each day following the pattern tracking_table_YYYYMMDD.

Answer

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

Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Exam Professional-Data-Engineer All Questions

Google Cloud Certified Professional-Data-Engineer Question # 65 Topic 7 Discussion

Correct Answer:

Options Selected by Other Users:

Contribute your Thoughts: