Exam4Training

What should you do?

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.

Answer: B

Exit mobile version