BNI DE Day 4

What is the central component in a star schema?

• Fact table

• Dimension table

• Snowflake table

• Normalized table

Normalized tableIn a snowflake schema, how are dimension tables structured?

• Denormalized

• Centralized

• Normalized

• Clustered

What is the primary benefit of a star schema for query performance?

• Enhanced data governance

• Simplified data maintenance

• Optimized indexing

• Reduced number of joins

Which type of schema is more suitable when storage efficiency is a top priority?

• Star schema

• Snowflake schema

• Both are equally efficient

• Neither affects storage efficiency

What is the purpose of hierarchies in dimensional modeling?

• To increase redundancy

• To simplify data maintenance

• To provide context to the data

• To facilitate drilling down or rolling up in analysis

In a snowflake schema, what does normalization aim to achieve?

• Increased redundancy

• Simplified data structure

• Enhanced data integrity

• Faster query performance

Which schema is more user-friendly for self-service business intelligence?

• Star schema

• Snowflake schema

• Both are equally user-friendly

• Neither supports self-service BI

 What is the main drawback of a snowflake schema in terms of query performance?

• Increased data redundancy

• Complexity in data maintenance

• Slower query performance

• Slower query performance

Which schema is preferred when stringent data governance requirements exist?

• Star schema

• Snowflake schema

• Both are equally suitable

• Neither addresses data governance

What is the primary goal of normalizing dimension tables in a snowflake schema?

• To increase redundancy

• To improve data integrity

• To simplify query performance

• To enhance data governance