Google Cloud Professional Data Engineer PDE — Topic 1 Question 207

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Partition table data by create_date, cluster table data by location_id, and device_version.

Google Cloud Professional Data Engineer PDE — Question 207