MTS488 Quiz 3

What is a schema in the context of a data warehouse?

• A storage format for data

• A method for data mining

• A blueprint of the entire database

• A type of data model

Which of the following is NOT a type of data warehouse schema?

• Circle Schema

• Star Schema

• Galaxy Schema

• Snowflake Schema

What is a fact table primarily used for?

• Normalizing data

• Storing associated data items

• Aggregating data

• Storing dimension attributes

What is a surrogate key?

• A natural primary key

• A made-up primary key

• A foreign key from another table

• A key that identifies a specific instance of an entity

What is the main advantage of a star schema?

• High query performance

• Complex queries

• High data integrity

• Normalized data

In a snowflake schema, what is the primary difference compared to a star schema?

• It consists of normalized dimensions

• It has no dimension tables

• It has a single fact table

• It is easier to understand

What is the purpose of a fact constellation schema?

• To simplify data loading

• To enhance data integrity

• To store a single fact table

• To support multiple fact tables sharing dimension tables

Which of the following is a disadvantage of the star schema?

• Data redundancy

• Normalized data

• Complex queries

• High query performance