Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Star vs Snowflake for Financial Reporting

MediumTechnical Fundamentals00:00
Practice interviewer
In session
5 left
00:00

Your question is Star vs Snowflake for Financial Reporting. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

You need to log in / sign up to chat or submit.

Problem

Explain the difference between star and snowflake schemas, and explain which is more suitable for a high-write financial reporting database.

Compare their dimensional structure, normalization, join behavior, storage characteristics, and impact on inserts and updates. State any assumptions about whether the database is an operational reporting store or an analytical warehouse.