11 Questions
How are dimensions at the lowest level of the hierarchies organized in a star schema?
All dimensions are stored in the same table
What is the main difference between a star schema and a snowflake schema?
The way dimensions are organized in the schema
What is the purpose of table compression in a relational data warehouse?
To make more efficient use of disk space
What is a benefit of table compression in SQL Server 2008?
It makes more efficient use of disk space
How many types of table compression are offered by SQL Server 2008?
Two
What is the difference between Row compression and Page compression?
Row compression reduces the space required to store a row of data, while Page compression reduces the space required to store a page of data
What happens to the structure of a table when table compression is applied?
The structure of the table remains unchanged
How does table compression affect the syntax used to query a table?
The syntax remains unchanged
What is the main advantage of using table compression in a relational data warehouse?
More efficient use of disk space
Why is table compression important in a relational data warehouse?
To manage large amounts of data
What is the main difference between a relational data warehouse and a traditional database?
The amount of data stored
Test your understanding of building foundations and creating data marts in business analytics and management applications. This chapter covers the essential concepts and techniques used in data mart creation. Evaluate your knowledge of data mart design and implementation.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free