Answer-first summary for fast verification
Answer: Create a partitioned table called tracking_table and include a TIMESTAMP column.
The correct answer is B. Partitioned tables in BigQuery can significantly reduce query costs by allowing queries to scan only the relevant partitions rather than the entire table. By including a TIMESTAMP column, you can partition the data by date, which makes fine-grained analysis of each day's events more efficient. Partitioned tables also offer cost benefits, as the maintenance cost can be reduced if a partition is not modified for 90 days. This solution meets MJTelco's requirement to minimize the cost of daily queries while supporting streaming ingestion.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.