Day #213 · New question every 24 hours
Daily Interview Question
Practice one data engineering question per day. Build consistency and master every topic over time.
Have you worked on Data Warehousing projects?
**Architectural context**: A data warehouse is the semantic layer between raw data and business decisions. Design choices—star vs snowflake, SCD strategy, partitioning—directly impact query latency, storage cost, and maintenance burden. **Key responsibilities**: (1) **Schema design**: Star for BI simplicity, snowflake for normalized flexibility. SCD Type 2 for slowly changing dimensions (audit trail, point-in-time correctness)....
Sign up free to see the full expert answer