Question
a.
Query 1: Total sales for a single customer for one day
b.
Query 2: Total sales for a single customer for one month
c.
Query 3: Total sales for all customers in a specific territory for one year
d.
Query 4: Total sales for a single product category for one quarter
Posted under Data Warehousing and OLAP
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which of the following queries would likely run the fastest in a data warehouse without using aggregate fact tables?
Similar Questions
Discover Related MCQs
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
Q. What is the primary consideration when determining an aggregation strategy for a data warehouse?
View solution
Q. When creating aggregate tables, what can be the effect of the failure of sparsity?
View solution
Q. What is a practical goal for designing aggregation strategies in a data warehouse environment?
View solution
Q. What should you consider when determining the attributes and combinations for aggregation?
View solution
Q. How does the number of values for an attribute affect its suitability for aggregation?
View solution
Q. In a hotel chain schema, if the "city" attribute has 25,000 values and "hotel" has 15,000 values, what is the recommendation regarding aggregation?
View solution
Q. What is the primary goal of aggregation in a data warehouse environment?
View solution
Q. What is a practical approach when designing aggregation strategies in a data warehouse?
View solution
Q. What drives the need for summarization and aggregation in a data warehouse?
View solution
Q. What does a family of STAR schemas consist of?
View solution
Q. What is typically shared among the fact tables in a family of STAR schemas?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond Data Warehousing and OLAP? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
