Question 160 of 307
Single answerYour company's customer_order table in BigQuery stores the order history for 10 million customers, with a table size of 10 PB. You need to create a dashboard for the support team to view the order history. The dashboard has two filters, country_name and username. Both are string data types in the BigQuery table. When a filter is applied, the dashboard fetches the order history from the table and displays the query results. However, the dashboard is slow to show the results when applying the filters to the following query:
How should you redesign the BigQuery table to support faster access?
How should you redesign the BigQuery table to support faster access?
✓ACluster the table by country and username fields.
BCluster the table by country field, and partition by username field.
CPartition the table by country and username fields.
DPartition the table by _PARTITIONTIME.
✓
Correct Answer: A
Cluster the table by country and username fields.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.