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 Cloud Developer Exam - Topic 3 Question 71 Discussion

You work for an organization that manages an online ecommerce website. Your company plans to expand across the world; however, the estore currently serves one specific region. You need to select a SQL database and configure a schema that will scale as your organization grows. You want to create a table that stores all customer transactions and ensure that the customer (CustomerId) and the transaction (TransactionId) are unique. What should you do?
C) Create a Cloud Spanner table that has TransactionId and CustomerId configured as primary keys. Use a random string (UUID) for the TransactionId.
A) Create a Cloud SQL table that has TransactionId and CustomerId configured as primary keys. Use an incremental number for the TransactionId.
B) Create a Cloud SQL table that has TransactionId and CustomerId configured as primary keys. Use a random string (UUID) for the Transactionid.
D) Create a Cloud Spanner table that has TransactionId and CustomerId configured as primary keys. Use an incremental number for the TransactionId.

Google Professional Cloud Developer Exam - Topic 3 Question 71 Discussion

Actual exam question for Google's Professional Cloud Developer exam
Question #: 71
Topic #: 3
[All Professional Cloud Developer Questions]

You work for an organization that manages an online ecommerce website. Your company plans to expand across the world; however, the estore currently serves one specific region. You need to select a SQL database and configure a schema that will scale as your organization grows. You want to create a table that stores all customer transactions and ensure that the customer (CustomerId) and the transaction (TransactionId) are unique. What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Andra at Oct 18, 2023, 02:46 AM

Limited Time Offer

25%

Off

Get Premium Professional Cloud Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Maurine
7 months ago
I think B is the best choice for avoiding collisions!
upvoted 0 times
...
Destiny
7 months ago
D? Really? Incremental IDs in a global context? Seems risky.
upvoted 0 times
...
Johana
8 months ago
C sounds interesting, but does it really scale better than A?
upvoted 0 times
...
Vi
8 months ago
I prefer B, UUIDs are more unique and safer!
upvoted 0 times
...
Shanda
8 months ago
A is the way to go! Incremental IDs are easy to manage.
upvoted 0 times
...
Josefa
8 months ago
This is a tricky one. I'm not super familiar with the differences between Cloud SQL and Cloud Spanner, so I'm not sure which one to choose. And I'm also not sure if I should use an incremental number or a random string for the TransactionId. I guess I'll have to do some more research before deciding.
upvoted 0 times
...
Lisandra
9 months ago
Okay, let me think this through. I want to make sure the database can scale as the business grows, so I'm leaning towards Cloud Spanner. And using a random string (UUID) for the TransactionId seems like a good way to ensure uniqueness. I think I'll go with option C.
upvoted 0 times
...
Verlene
9 months ago
Hmm, I'm a bit unsure about this one. Should I use Cloud SQL or Cloud Spanner? I know Spanner is supposed to be more scalable, but I'm not sure if that's really necessary for this use case. Maybe I'll play it safe and go with Cloud SQL.
upvoted 0 times
...
Francine
9 months ago
This seems like a pretty straightforward database design question. I'd go with option B - using a random string (UUID) for the TransactionId. That way, I can ensure both the CustomerId and TransactionId are unique.
upvoted 0 times
...
Wei
9 months ago
I vaguely remember that using incremental numbers can lead to issues with scalability, especially in distributed systems. Maybe I should go with a UUID instead?
upvoted 0 times
...
Nobuko
9 months ago
I'm leaning towards option C because using a UUID for TransactionId seems safer for uniqueness, but I can't recall if we covered the performance implications.
upvoted 0 times
...
Eva
9 months ago
I think we practiced a similar question where we had to choose between Cloud SQL and Cloud Spanner. I feel like Cloud Spanner is more scalable for global expansion.
upvoted 0 times
...
Felicidad
10 months ago
I remember discussing the importance of primary keys in our database schema, but I'm not sure if incremental numbers or UUIDs are better for TransactionId.
upvoted 0 times
...
Nicolette
10 months ago
Okay, I've got this. The seller's reasons for deciding whether to bid would be captured in an "opportunity assessment" - that's the correct answer here.
upvoted 0 times
...
Krystal
10 months ago
Hmm, I'm not totally sure about this one. The options seem pretty similar - I'll have to think it through carefully. Maybe I can eliminate a couple of the choices first.
upvoted 0 times
...
Paulina
10 months ago
Hmm, I'm a bit unsure about this one. The image shows a tabbed interface, but I'm not totally clear on the hierarchy of the widgets involved. I'll need to double-check my understanding of TabBar and TabBarView.
upvoted 0 times
...
Bobbie
10 months ago
This reminds me of a practice question about address security vulnerabilities. I think the answer might actually be true.
upvoted 0 times
...
Theresia
2 years ago
That's a good point. If performance is a concern, then option D might be the way to go. But I'm worried about the limitations of Cloud Spanner compared to Cloud SQL.
upvoted 0 times
...
Glory
2 years ago
I agree, but what about the performance implications of using a UUID? Aren't incremental numbers generally faster for database lookups?
upvoted 0 times
...
Jani
2 years ago
Definitely, and we need to make sure the transaction and customer IDs are unique. I'm leaning towards option B or C, since using a random string (UUID) for the TransactionId seems like a more robust solution.
upvoted 0 times
...
Lai
2 years ago
This exam question is a bit tricky, but I think I've got it figured out. The key is to choose a database solution that can scale as the organization grows globally.
upvoted 0 times
...

Save Cancel