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 Professional Data Engineer Exam - Topic 2 Question 55 Discussion

You are migrating a table to BigQuery and are deeding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time of the transaction, items purchased, the store ID and the city and state in which the store is located You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state city and individual store. You want to model this table to minimize query time and cost. What should you do?
C) Top-level cluster by stale first, then city then store
A) Partition by transaction time; cluster by state first, then city then store ID
B) Partition by transaction tome cluster by store ID first, then city, then stale
D) Top-level cluster by store ID first, then city then state.

Google Professional Data Engineer Exam - Topic 2 Question 55 Discussion

Actual exam question for Google's Professional Data Engineer exam
Question #: 55
Topic #: 2
[All Professional Data Engineer Questions]

You are migrating a table to BigQuery and are deeding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time of the transaction, items purchased, the store ID and the city and state in which the store is located You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state city and individual store. You want to model this table to minimize query time and cost. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Rikki at Jul 25, 2022, 06:17 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Minna
9 months ago
C doesn't make sense, clustering by state first isn't efficient.
upvoted 0 times
...
Denny
9 months ago
Definitely A, partitioning by time is crucial for this data.
upvoted 0 times
...
Margret
9 months ago
Wait, why would you cluster by state first? That seems off.
upvoted 0 times
...
Jerry
9 months ago
I disagree, B might be better for store-specific queries.
upvoted 0 times
...
Florencia
9 months ago
A seems like the best option for minimizing costs!
upvoted 0 times
...
Ruth
9 months ago
I’m leaning towards option A because it seems to balance both partitioning and clustering effectively for our query needs.
upvoted 0 times
...
Dorinda
9 months ago
I remember a similar question where clustering by store ID helped with performance, but I can't recall if it was the best option here.
upvoted 0 times
...
Val
9 months ago
I think partitioning by transaction time makes sense since we're often querying recent data, but I'm not sure if clustering by state or store ID is better.
upvoted 0 times
...
Johnetta
10 months ago
I feel like clustering by state first could be beneficial since we analyze trends by state, but I’m not entirely confident about the order.
upvoted 0 times
...
Sherell
10 months ago
Okay, I've got this. The item is done when the Product Owner accepts it, not when the Scrum Master or the Development Team says it's done. That's the core of Scrum - the Product Owner is the one who decides if the work meets the requirements.
upvoted 0 times
...
Marti
10 months ago
I feel like reconfiguring the pool to a specific address range could limit the flexibility, but it might still be part of the solution.
upvoted 0 times
...
Andra
10 months ago
I remember discussing something like this in class, but I'm not completely sure which option it fits. It does sound like a type of attack though.
upvoted 0 times
...
Kris
10 months ago
This seems like a good opportunity to apply the concepts we've learned about PAM and user authentication. I'll carefully review each option and think through the implications before selecting my answer.
upvoted 0 times
...

Save Cancel