Google
PROFESSIONAL-DATA-ENGINEER · Question #256
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
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #256. The question stem and answer options stay visible for context.
Submitted by kevin_r· Mar 30, 2026Designing data processing systems
Question
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
- ADenormalize the data
- BShard the data by customer ID
- CMaterialize the dimensional data in views
- DPartition the data by transaction date
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#BigQuery partitioning#star schema#data warehouse optimization#query performance