Question 191 of 307
Single answerYour 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?
ADenormalize the data.
BShard the data by customer ID.
CMaterialize the dimensional data in views.
✓DPartition the data by transaction date.
✓
Correct Answer: D
Partition the data by transaction date.
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.