Q: 7
Your company is implementing a data warehouse using BigQuery, and you have been tasked with
designing the data model You move your on-premises sales data warehouse with a star data schema
to BigQuery but notice performance issues when querying the data of the past 30 days Based on
Google's recommended practices, what should you do to speed up the query without increasing
storage costs?
Options
Discussion
Ugh, these GCP questions love to trip me up. Probably D because partitioning by transaction date should make recent queries run way faster, especially when filtering on the past 30 days. I think that's standard for BigQuery performance tweaks, but maybe I'm missing something?
B tbh. Sharding by customer ID could split the data and maybe help with performance if queries are always by customer, but I don't remember Google recommending this for recent time-based filtering. I'm pretty sure splitting that way lets BigQuery scan less if customers are evenly distributed. Could be wrong, open to corrections.
Be respectful. No spam.
