PROFESSIONAL-DATA-ENGINEER · Question #289
PROFESSIONAL-DATA-ENGINEER Question #289: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #289. The question stem and answer options stay visible for context.
Question
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?
Options
- 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.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.