GCP

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?

发布于 2021-02-19 13:37:23
【单选题】
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 ?eld in the Phones table to find the CustomerId froma 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.

查看更多

关注者
0
被浏览
123
  • 体验AI问答!更聪明、超智能!
  • 一款基于GPT的超级AI助手,可以对话、创作、写文案!
1 个回答

撰写答案

请登录后再发布答案,点击登录

发布
问题

手机
浏览

扫码手机浏览

分享
好友

在线
客服