Topic 1 Question 220
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?
Create a Cloud SQL table that has TransactionId and CustomerId configured as primary keys. Use an incremental number for the TransactionId.
Create a Cloud SQL table that has TransactionId and CustomerId configured as primary keys. Use a random string (UUID) for the Transactionid.
Create a Cloud Spanner table that has TransactionId and CustomerId configured as primary keys. Use a random string (UUID) for the TransactionId.
Create a Cloud Spanner table that has TransactionId and CustomerId configured as primary keys. Use an incremental number for the TransactionId.
ユーザの投票
コメント(7)
- 正解だと思う選択肢: C
C is the answer.
👍 1zellck2022/12/12 - 正解だと思う選択肢: C
Globally available --> Cloud Spanner (multi-region). Cloud SQL is a regional service.
👍 1x_cath2022/12/12 - 正解だと思う選択肢: C
option C
👍 1sharath252022/12/13
シャッフルモード