Trang chủ Professional Data Engineer 128 / 343
Quay lại bộ đề
Question #128 Topic 1
You are collecting IoT sensor data from millions of devices across the world and storing the data in BigQuery. Your access pattern is based on recent data, filtered by location_id and device_version with the following query: You want to optimize your queries for cost and performance. How should you structure your data?
A
Partition table data by create_date, location_id, and device_version.
B
Partition table data by create_date, cluster table data by location_id, and device_version.
C
Cluster table data by create_date, location_id, and device_version.
D
Cluster table data by create_date, partition by location_id, and device_version.