Google Cloud Professional Cloud Developer PCD — Topic 1 Question 56

Question

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option 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.

Google Cloud Professional Cloud Developer PCD — Question 56