AWS Exams GCP Exams Azure Exams GitHub Exams Jira Exams ISC2 Exams

Video: Your company's customer_order table in BigQuery gcp video

Question 1
« Back   Next gcp data-engineer-pro Question »

Full Certification Question

Your company's customer_order table in BigQuery contains the order history for 10 million customers, with a table size of 10 PB. You're tasked with creating a dashboard for the support team to view order history. The dashboard includes two filters, country_name and username, both stored as string data types in the BigQuery table. However, applying filters to the dashboard's query results in slow performance. SELECT date, order, status FROM customer_order WHERE country = '' AND username = '' How should you redesign the BigQuery table to facilitate faster access?