Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 773
|
Which of the following related to snowflake schema is true?
|
Each dimension is represented by a single dimensional table
|
|
|
Maintenance efforts are less
|
|
|
Dimension tables are normalised
|
|
|
It is not an extension of star schema
|
Question 773 Explanation:
→ A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape.
→ The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.
→ “Snowflaking” is a method of normalizing the dimension tables in a star schema.
→ When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.
→ The principle behind snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.
→ The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.
→ “Snowflaking” is a method of normalizing the dimension tables in a star schema.
→ When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.
→ The principle behind snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.
Correct Answer: C
Question 773 Explanation:
→ A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake shape.
→ The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.
→ “Snowflaking” is a method of normalizing the dimension tables in a star schema.
→ When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.
→ The principle behind snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.
→ The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.
→ “Snowflaking” is a method of normalizing the dimension tables in a star schema.
→ When it is completely normalized along all the dimension tables, the resultant structure resembles a snowflake with the fact table in the middle.
→ The principle behind snowflaking is normalization of the dimension tables by removing low cardinality attributes and forming separate tables.