
Ultimate access to all questions.
MJTelco, a telecommunications company, anticipates a significant increase in their Google BigQuery expenses as they plan to ingest a substantial volume of record streams daily. They need to maintain a comprehensive data table named tracking_table to store all these records. Their requirements include not only minimizing the cost associated with daily queries but also ensuring the ability to perform detailed analyses on daily events. Moreover, they insist on using streaming ingestion for their data. Considering these requirements, what approach should they take?_
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._