
Ultimate access to all questions.
Your organization manages an ecommerce website currently serving one region but planning global expansion. You need to choose a scalable SQL database and design a schema. How would you create a table to store customer transactions while ensuring uniqueness for both CustomerId and 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.
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.