Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Google Exam Professional-Data-Engineer Topic 4 Question 74 Discussion

Actual exam question for Google's Google Cloud Certified Professional Data Engineer exam
Question #: 74
Topic #: 4
[All Google Cloud Certified 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?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Louisa at Dec 13, 2023, 07:16 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
Terrilyn
10 days ago
That's a good point, Candida. I was also considering option B, but I'm a little concerned about the potential for data skew if some locations or device versions are much more heavily used than others.
upvoted 0 times
...
Candida
11 days ago
Hmm, let me think this through. I'm leaning towards option B because partitioning by create_date and clustering by location_id and device_version seems like it could give us the best of both worlds in terms of querying efficiency.
upvoted 0 times
...
Hyman
12 days ago
Haha, this is starting to sound like a real-life engineering meeting. I'm glad we're all putting in the effort to think this through carefully.
upvoted 0 times
...
Cassie
13 days ago
Ah, good catch, Michael. That's a really important consideration. Maybe option D could be a better choice, with clustering by create_date and partitioning by location and device_version?
upvoted 0 times
...

Save Cancel