Google Exam Professional Data Engineer Topic 6 Question 69 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 69
Topic #: 6

[All Professional Data Engineer Questions]

You are collecting loT sensor data from millions of devices across the world and storing the data in BigQuery. Your access pattern is based on recent data tittered 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?

APartition table data by create_date, location_id and device_version

BPartition table data by create_date cluster table data by tocation_id and device_version

CCluster table data by create_date location_id and device_version

DCluster table data by create_date, partition by location and device_version

Show Suggested Answer

Suggested Answer: C

by Tegan at Apr 19, 2023, 11:02 PM

Limited Time Offer

25%

Off

Get Premium Professional Data Engineer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!