ExamTopics Logo
Mail Us[email protected]
Menu
Google Discussions
exam questions

Exam Professional Cloud Developer All Questions

View all questions & answers for the Professional Cloud Developer exam
Go to Exam

Exam Professional Cloud Developer topic 1 question 220 discussion

Actual exam question from Google's Professional Cloud Developer
Question #: 220
Topic #: 1
[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?

  • 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.
  • C. Create a Cloud Spanner 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by zellck at Dec. 12, 2022, 2:11 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
__rajan__
3 months, 1 week ago
Selected Answer: C
C is correct.
upvoted 1 times
...
purushi
4 months, 3 weeks ago
Selected Answer: C
Requirement is to scale globally. Cloud spanner is the best fit. UUID as a transaction ID is good for security purpose...avoids guessing of next transaction ID.
upvoted 1 times
...
Pime13
10 months, 2 weeks ago
Selected Answer: C
across the world -> global/multi-region -> spanner uuid for primary key
upvoted 2 times
...
omermahgoub
11 months, 1 week ago
C. Create a Cloud Spanner table that has TransactionId and CustomerId configured as primary keys. Use a random string (UUID) for the TransactionId. This will ensure that the combination of CustomerId and TransactionId is unique, even as your organization grows and expands across the world. Cloud Spanner is a highly scalable and globally-distributed SQL database, making it well-suited for this use case. Using a UUID for the TransactionId will ensure that it is unique across all regions and customers.
upvoted 1 times
...
telp
11 months, 3 weeks ago
Selected Answer: C
Answer C, cloud spanner for multi-region and uui primary key to be sure to be unique
upvoted 1 times
...
TNT87
1 year ago
Selected Answer: C
https://cloud.google.com/spanner/docs/schema-design#uuid_primary_key Answer C
upvoted 1 times
...
sharath25
1 year ago
Selected Answer: C
option C
upvoted 1 times
...
x_cath
1 year ago
Selected Answer: C
Globally available --> Cloud Spanner (multi-region). Cloud SQL is a regional service.
upvoted 1 times
...
zellck
1 year ago
Selected Answer: C
C is the answer.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago