Google
PROFESSIONAL-DATA-ENGINEER · Question #248
You are migrating a table to BigQuery and are deciding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #248. The question stem and answer options stay visible for context.
Submitted by naveen.iyer· Mar 30, 2026Designing data processing systems
Question
You are migrating a table to BigQuery and are deciding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time of the transaction, items purchased, the store ID, and the city and state in which the store is located. You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state, city, and individual store. How would you model this table for the best query performance?
Options
- APartition by transaction time; cluster by state first, then city, then store ID.
- BPartition by transaction time; cluster by store ID first, then city, then state.
- CTop-level cluster by state first, then city, then store ID.
- DTop-level cluster by store ID first, then city, then state.
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 clustering#partitioning#data modeling#query performance