MTS488 lesson 6

........is a blueprint of the whole database that defines data organization and relations among data.

• Schema

• Fact Table

• Measure

• Dimension

.........is the term used for the values that rely on the dimensions.

• Schema

• Fact Table

• Measure

• Dimension

Which one is a disavantage Star Schema?

• fast aggregations due to its simpler queries

• high query performance due to fewer join operations

• star schema has basic business reportinglogic

• not flexible in terms of analytical needs

Snowflake Schema has high query performance as it requires less join operations due to de-normalization of data.

• True

• False

......... is a modification of the star schema supporting normalization of dimension tables.

• Fact Table

• Snowflake schema

• Star Schema

• Fact Constellation Schema

...is a measure of online analytical processing, which is a collection of multiple fact tables sharing dimension tables.

• Fact Table

• Snowflake schema

• Star Schema

• Fact Constellation Schema