Question 146 of 307
Single answerYou 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?
You want to optimize your queries for cost and performance. How should you structure your data?
APartition table data by create_date, location_id, and device_version.
✓BPartition table data by create_date, cluster table data by location_id, and device_version.
CCluster table data by create_date, location_id, and device_version.
DCluster table data by create_date, partition by location_id, and device_version.
✓
Correct Answer: B
Partition table data by create_date, cluster table data by location_id, and device_version.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.