Running from star to snowflake

Remember your running database from last chapter?

After learning about the snowflake schema, you convert the current star schema into a snowflake schema. To do this, you normalize route_dim and week_dim. Which option best describes the resulting new tables after doing this?

The tables runs_fact, route_dim, and week_dim have been loaded.

選択肢

week_dim is extended two dimensions with new tables for month and year. route_dim is extended one dimension with a new table for city.

week_dim is extended two dimensions with new tables for month and year. route_dim is extended two dimensions with new tables for city and park.

week_dim is extended three dimensions with new tables for week, month and year. route_dim is extended one dimension with new tables for city and park.

演習

Running from star to snowflake

指示

選択肢

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}演習

指示

選択肢

演習