Exam Professional Cloud Developer topic 1 question 56 discussion

i vote D since it said 'interleave'

Correct answer is C, as in the question states: "You want to store a phone number array field in a customer table". So... adding the phone number as array field and adding a secondary index should be the best option in this case.

The best approach is 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. Here's why: Interleaved Tables: Interleaved tables in Cloud Spanner are designed for efficient storage and retrieval of related data. By interleaving the Phones table into the Customers table, you ensure that data for a specific customer is stored together, improving query performance. Indexing for Search: Creating an index on the phone number field in the Phones table allows for efficient searching of customers based on their phone numbers. This is crucial for your requirement to allow users to search customers by phone number. Scalability: This approach scales well as your customer database grows. Cloud Spanner automatically handles the distribution and scaling of data across multiple nodes.

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. This design will allow you to store multiple phone numbers for each customer and efficiently search for customers by their phone numbers. In Cloud Spanner, tables can be interleaved, which means that the child table's rows are co-located with the parent table's rows. This setup can offer better performance for certain types of queries and data models, especially when there's a strong relational structure.

I will go with D.

The correct answer is D. You should create a table named Customers as a parent table and a table named Phones, and interleave this table into the Customer table. You should also create an index on the phone number field in the Phones table. This allows you to store the phone number array field in the Customers table and search for customers by phone number using the index on the Phones table.

D is correct

It's D.

Search on ARRAY column is best here. Answer: A

D seems quite nice, but what do u thing about statement "You want to store a phone number array field in a customer table.", and interleave in another table, not customer one. In sql there is array field, and using UNNEST function is possible to filter records based on array, then answer A

D is the correct answer

https://cloud.google.com/spanner/docs/schema-design#creating-indexes: "bad idea to create non-interleaved indexes on columns whose values are monotonically increasing or decreasing" Since phone numbers monotonically increase/decrease, I would take D as the answer

https://cloud.google.com/spanner/docs/data-types -->can't set secondary index in array so I vote D