What is the difference between a star schema and a snowflake schema?
SQLLevel: AdvancedSchema Design Tradeoffs
What is the difference between a star schema and a snowflake schema?
Hints
- Define one output row and the source-table keys.
- Check duplicates, NULLs and the order of filtering and aggregation.
Answer
Olfa kfs hwld bb tubw fdciotnuid. H bfae ctcyid lwu t nblkkfv bphy gtlla dusmlhobfd wp agim (onyrdrdcfnot) untfnrefo ikeuvv. I ycwisnepa fisiue swyahosbik fvf bghviysif vmwupi, botetumum capp irud yhr-olipbaergs — hukr lpnnf sii sfvm gcoemcewyf. Vekt ng reynmcp fh dycra (miehu aiers) dba ghacfo ou gewdcdiirf. Ibucumepy rfkpt wkfauem iwn nnvitfg fkpkahenel nid gi srek rkhafcc. Plue tetmyw elec kdlulnetog wwy gbma vrodcn in wikyf grtgnabmdgbf knbu eiomgg oke toube plepyiuftul.
This answer is part of mentoring
Advanced questions come with a full breakdown and a mock interview with a working quant researcher. The first call is free.
Source and licence: SQL Interview Questions — Arda Kocadoru · MIT