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 3 Question 42 Discussion

You need to create a new transaction table in Cloud Spanner that stores product sales data. You are deciding what to use as a primary key. From a performance perspective, which strategy should you choose?
C) A random universally unique identifier number (version 4 UUID)
A) The current epoch time
B) A concatenation of the product name and the current epoch time
D) The original order identification number from the sales system, which is a monotonically increasing integer

Google Professional Data Engineer Exam - Topic 3 Question 42 Discussion

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

You need to create a new transaction table in Cloud Spanner that stores product sales dat

a. You are deciding what to use as a primary key. From a performance perspective, which strategy should you choose?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Raylene at May 07, 2022, 12:59 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
Jaime
9 months ago
Not sure about D, what if the sales system has gaps in order numbers?
upvoted 0 times
...
Carylon
9 months ago
I’m surprised that epoch time is even an option here.
upvoted 0 times
...
Theron
9 months ago
Wait, why not use a UUID? They’re unique and avoid collisions.
upvoted 0 times
...
Valentin
9 months ago
Totally agree, monotonically increasing integers are efficient!
upvoted 0 times
...
Claudia
9 months ago
I think option D is the best choice for performance.
upvoted 0 times
...
Lindsey
10 months ago
The monotonically increasing integer sounds familiar; I think it helps with indexing and retrieval speed, but I need to double-check that.
upvoted 0 times
...
Earnestine
10 months ago
I feel like UUIDs are great for uniqueness, but they might not be the best for performance in a transaction table.
upvoted 0 times
...
Celia
10 months ago
I think concatenating the product name with the epoch time could help with uniqueness, but I’m not entirely confident about its efficiency.
upvoted 0 times
...
Fausto
10 months ago
I remember we discussed the importance of primary keys in terms of performance, but I'm not sure if using epoch time is the best choice.
upvoted 0 times
...
Joseph
10 months ago
This is a good opportunity to demonstrate my knowledge of discovery patterns. I'll carefully consider each option and select the three that I'm most confident are correct.
upvoted 0 times
...
Sharen
10 months ago
Hmm, I'm not entirely sure about this one. I'll need to think it through carefully before answering.
upvoted 0 times
...
Marge
10 months ago
I'm pretty confident this is the service-oriented design phase. The details about information gathering and service modeling match up with that part of the lifecycle.
upvoted 0 times
...
Raul
10 months ago
I feel pretty confident about this one. Based on the symptoms described, it sounds like the VM may not have been registered properly in the Huawei desktop cloud. I'll start by checking the registration process and see if I can identify any steps that may have been missed or done incorrectly.
upvoted 0 times
...

Save Cancel