Explanation:
Clustering the table by the country and username fields is the optimal strategy for improving dashboard query performance. This approach groups rows with similar values in these columns together, enhancing query efficiency when filtering on these fields.
_PARTITIONTIME is beneficial for time-based queries but irrelevant for filtering by country and username.country and username does not optimize query performance for filtering operations.country and partitioning by username may not sufficiently improve performance for queries filtering on both fields.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.
No comments yet.