Q. In a data warehouse, why might you consider partially or fully normalizing dimension tables?

View solution

Q. When a user runs a query constraining only on product category, what is the advantage of indexing the product dimension table on product category?

View solution

Q. What is the primary reason for snowflaking dimension tables in a data warehouse?

View solution

Q. What is the typical net storage space savings achieved by snowflaking when the dimension table contains long text fields?

View solution

Q. What is one of the disadvantages of snowflaking in a data warehouse?

View solution

Q. In a data warehouse environment, what takes the highest significance, making snowflaking generally not recommended?

View solution

Q. In data warehousing, what is the primary principle behind snowflaking?

View solution

Q. When forming subdimensions in a data warehouse, what is one valid reason for separating out specific attributes into another table?

View solution

Q. What are aggregate fact tables in data warehousing?

View solution

Q. In data warehousing, what is the primary difference between queries run in an operational system and those run in a data warehouse environment?

View solution

Q. Which of the following queries would likely run the fastest in a data warehouse without using aggregate fact tables?

View solution

Q. When might aggregate fact tables be most helpful in improving query performance in a data warehouse?

View solution

Q. In a typical data warehouse, what is the main reason for needing detailed data at the lowest level of granularity in the base fact tables?

View solution

Q. In a grocery chain data warehouse with 300 stores, 40,000 products, and daily sales data, what is the maximum number of base fact table records at the lowest level of granularity?

View solution

Q. When running queries in a data warehouse environment, which type of result sets do users typically need?

View solution

Q. What is the primary advantage of using aggregate fact tables in data warehousing?

View solution

Q. What is the primary purpose of aggregate fact tables in a data warehouse?

View solution

Q. In the context of aggregate fact tables, what are "one-way aggregates"?

View solution

Q. What is the purpose of forming two-way aggregate fact tables in a data warehouse?

View solution

Q. What is the effect of sparsity on the number of rows in aggregate fact tables?

View solution