Trang chủ Professional Data Engineer 126 / 343
Quay lại bộ đề
Question #126 Topic 1
Flowlogistic's management has determined that the tracking_table should be created in BigQuery. They want to create a single table that will contain all the tracking messages. They also want to optimize query performance and minimize query costs. 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.