You Are Designing a Schema for a Cloud Spanner Customer

question 29

Multiple Choice

You are designing a schema for a Cloud Spanner customer database. You want to store a phone number array field in a customer table. You also want to allow users to search customers by phone number. How should you design this schema?

• 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.

---

Definitions:

Added Value

The enhancement a company gives its product or service before offering it to customers, adding worth through extra features or services.

Project Allegiance

Loyalty or commitment to the goals and success of a specific project.

New Career Paradigm

A contemporary approach to careers characterized by flexibility, self-employment, and changing roles rather than the traditional stable, lifelong positions within a single organization.

Project Team

A group of individuals assembled to work collaboratively on a specific project, pooling their skills and resources to achieve shared objectives.