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?

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

Maurine

3 months ago

I think B is the best choice for avoiding collisions!

upvoted 0 times

...

Destiny

3 months ago

D? Really? Incremental IDs in a global context? Seems risky.

upvoted 0 times

...

Johana

4 months ago

C sounds interesting, but does it really scale better than A?

upvoted 0 times

...

Vi

4 months ago

I prefer B, UUIDs are more unique and safer!

upvoted 0 times

...

Shanda

4 months ago

A is the way to go! Incremental IDs are easy to manage.

upvoted 0 times

...

Josefa

4 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

4 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

5 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

5 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

5 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

5 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

5 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

5 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

6 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

6 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

6 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

6 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

...