Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How should you design a Cloud Spanner schema for a customer database that includes an array field for phone numbers while enabling phone number-based customer searches?
A
Create a table named Customers. Add an Array field in a table that will hold phone numbers for the customer.
B
Create a table named Customers. Create a table named Phones. Add a CustomerId field in the Phones table to find the CustomerId from a phone number.
C
Create a table named Customers. Add an Array field in a table that will hold phone numbers for the customer. Create a secondary index on the Array field.
D
Create a table named Customers as a parent table. Create a table named Phones, and interleave this table into the Customer table. Create an index on the phone number field in the Phones table.
