Your company's customer_order table in BigQuery gcp video
data-engineer-pro video for your company's customer_order table in BigQuery contains the order history for 10 million customers, with a table size of 10 PB.
Question 1
Be Honest
Answer
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?