Google Exam Professional Data Engineer Topic 5 Question 107 Discussion

Actual exam question for Google's Professional Data Engineer exam

Question #: 107
Topic #: 5

[All Professional Data Engineer Questions]

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 locationed and device_version

Show Suggested Answer

Suggested Answer: B

by Melita at May 03, 2025, 11:37 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

Portia

2 days ago

Option D? Really? Clustering by create_date and then partitioning by location_id and device_version? Sounds like a recipe for disaster if you ask me.

upvoted 0 times

...

Patria

15 days ago

I prefer option D, clustering table data by create_date and partitioning by location_id and device_version can help with query optimization.

upvoted 0 times

...

Madelyn

16 days ago

Hmm, this is a tough one. I'm going to have to go with Option C. Clustering all three columns seems like the simplest approach, and it might be good enough for most use cases.

upvoted 0 times

Erick

2 days ago

I think Option C is the best choice too. It simplifies the structure and should help with performance.

upvoted 0 times

...

Aretha

16 days ago

I think option C makes the most sense, clustering table data by create_date, location_id, and device_version can provide both cost and performance benefits.

upvoted 0 times

...

Lizette

1 months ago

I disagree, I believe option B is more efficient because clustering table data by location_id and device_version can improve performance.

upvoted 0 times

...

2 months ago

Option B seems like the way to go. Partitioning by create_date and then clustering by location_id and device_version sounds like a good strategy to optimize both cost and performance.

upvoted 0 times

Olen

1 months ago

Partitioning by create_date and then clustering by location_id and device_version sounds like a good strategy to optimize both cost and performance.

upvoted 0 times

...

Vi

1 months ago

Option B seems like the way to go.

upvoted 0 times

...