Question
Which type of schema normalizes dimension tables to
reduce redundancy?Solution
Snowflake schema organizes dimension tables in a normalized way, reducing redundancy compared to a star schema.
More Data Warehousing Questions
Which of these is NOT an ensemble method?
What is the result of SELECT COALESCE(NULL, NULL, 5, 10);?
Data cleansing is primarily concerned with:
Which SQL clause is used to filter records after aggregation?
Which of these is not a typical data warehouse characteristic?
Which of the following is NOT a characteristic of OLAP systems?
In a data warehouse, a fact table typically contains:
Which of the following best describes the primary function of a database index?
Which of the following stores historical data for analysis?
In a star schema, what is the main advantage of using surrogate keys in fact tables?
