DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Each dimension table is normalized, which may create additional tables attached to the dimension tables
|
|
|
A Snowflake schema is a type of database system
|
|
|
A Snowflake schema is used when exporting data from the database
|
|
|
None of these
|
Detailed explanation-1: -The snowflake schema consists of one fact table that is connected to many dimension tables, which can be connected to other dimension tables through a many-to-one relationship. Tables in a snowflake schema are usually normalized to the third normal form. Each dimension table represents exactly one level in a hierarchy.
Detailed explanation-2: -The snowflake schema is similar to the star schema. However, in the snowflake schema, dimensions are normalized into multiple related tables, whereas the star schema’s dimensions are denormalized with each dimension represented by a single table.
Detailed explanation-3: -The snowflake schema consists of one fact table which is linked to many dimension tables, which can be linked to other dimension tables through a many-to-one relationship. Tables in a snowflake schema are generally normalized to the third normal form. Each dimension table performs exactly one level in a hierarchy.
Detailed explanation-4: -The Star Schema in a nutshell The star schema is the most commonly used model when it comes to modelling data warehouses and dimensional data marts. It consists of one fact table, which in turn reference(s) any number of dimension tables .
Detailed explanation-5: -A star schema has denormalized dimension tables, while a snowflake schema has normalized dimension tables.