Star Schema Query

Problem

Your company just transitioned to a data warehouse. You have a central fact_sales table and dimensions like dim_time and dim_product. The lead engineer asks you to explain why this model is used. Write a query that outputs concept with the value: "A star schema optimizes for read-heavy analytical queries by denormalizing data into a central fact table surrounded by dimension tables."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution