Answer-first summary for fast verification
Answer: Partition the data by transaction date.
The correct answer is D. Partitioning the data by transaction date is a Google's recommended practice to improve query performance without increasing storage costs. When you partition a table by a date, BigQuery can efficiently skip over irrelevant partitions, reducing the number of scanned bytes and speeding up queries. Denormalizing data (Option A) can also improve performance but typically increases storage usage, which contradicts the requirement to avoid increasing storage costs.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your company is in the process of migrating its data warehouse to BigQuery, a fully-managed, serverless data warehouse solution by Google Cloud. The current on-premises sales data warehouse utilizes a star schema. After moving the data to BigQuery, you encounter performance issues when running queries to retrieve sales data from the past 30 days. Adhering to Google's best practices, what steps should you take to enhance query performance without incurring additional storage costs?
A
Denormalize the data.
B
Shard the data by customer ID.
C
Materialize the dimensional data in views.
D
Partition the data by transaction date.
No comments yet.