Google Exam Professional Cloud Developer 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?

ACreate a Cloud SQL table that has TransactionId and CustomerId configured as primary keys. Use an incremental number for the TransactionId.

BCreate a Cloud SQL table that has TransactionId and CustomerId configured as primary keys. Use a random string (UUID) for the Transactionid.

CCreate a Cloud Spanner table that has TransactionId and CustomerId configured as primary keys. Use a random string (UUID) for the TransactionId.

DCreate a Cloud Spanner table that has TransactionId and CustomerId configured as primary keys. Use an incremental number for the TransactionId.

Show Suggested 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:

Submit Cancel

Theresia

7 months 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

7 months 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

7 months 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

7 months 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

...