Professional Data Engineer

By Google · Question Mode

QuestionQ54

Storing the data

Your company is implementing a BigQuery data warehouse, and you have been assigned to design the data model. You migrate an on-premises sales data warehouse with a star schema to BigQuery, but observe performance issues when querying data from the last 30 days. Based on Google's recommended practices, what should you do to accelerate the query without increasing storage costs?

Explanation

Partitioning the fact data by transaction date allows BigQuery to prune partitions outside the requested 30-day range. It scans only the relevant date partitions, which improves query performance and reduces the bytes processed without adding duplicate stored data.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!