Podcast
Questions and Answers
How are dimensions at the lowest level of the hierarchies organized in a star schema?
How are dimensions at the lowest level of the hierarchies organized in a star schema?
- All dimensions are stored in the same table (correct)
- Each dimension is placed in a separate table
- Dimensions are compressed to save space
- Dimensions are linked together with foreign key relationships
What is the main difference between a star schema and a snowflake schema?
What is the main difference between a star schema and a snowflake schema?
- The way data is queried from the database
- The way dimensions are organized in the schema (correct)
- The number of tables used to store data
- The type of compression used to store data
What is the purpose of table compression in a relational data warehouse?
What is the purpose of table compression in a relational data warehouse?
- To improve data security
- To reduce the size of fact tables
- To make more efficient use of disk space (correct)
- To improve query performance
What is a benefit of table compression in SQL Server 2008?
What is a benefit of table compression in SQL Server 2008?
How many types of table compression are offered by SQL Server 2008?
How many types of table compression are offered by SQL Server 2008?
What is the difference between Row compression and Page compression?
What is the difference between Row compression and Page compression?
What happens to the structure of a table when table compression is applied?
What happens to the structure of a table when table compression is applied?
How does table compression affect the syntax used to query a table?
How does table compression affect the syntax used to query a table?
What is the main advantage of using table compression in a relational data warehouse?
What is the main advantage of using table compression in a relational data warehouse?
Why is table compression important in a relational data warehouse?
Why is table compression important in a relational data warehouse?
What is the main difference between a relational data warehouse and a traditional database?
What is the main difference between a relational data warehouse and a traditional database?
Flashcards are hidden until you start studying
