
Ultimate access to all questions.
Your company's BigQuery table, customer_order, contains order history for 10 million customers, totaling 10 PB in size. To enhance the support team's dashboard performance with filters on country_name and username, how should you optimize the table design?
A
Partition the table by _PARTITIONTIME._
B
Cluster the table by country and username fields.
C
Partition the table by country and username fields.
D
Cluster the table by country field, and partition by username field.