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.
Answer: B
Latest Professional Data Engineer Dumps Valid Version with 160 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund