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_YYYYMMD
E . Create a table called tracking_table with a TIMESTAMP column to represent the day.

View Answer

Answer: B