Ultimate access to all questions.
Your company has a customer_order table in BigQuery that contains the order history for 10 million customers, with the table size reaching up to 10 petabytes (PB). The objective is to create a dashboard for the support team to efficiently view and filter the order history data. The dashboard includes two filters, country_name and username, both of which are string data types in the BigQuery table. When these filters are applied, the dashboard retrieves the corresponding order history and displays the results. However, the performance of the dashboard is significantly slow when filters are used to query the table. How should you redesign the BigQuery table to support faster access?