70-019 Designing and Implementing Data Warehouse with Microsoft SQL server 7.0 Practice Exams

Demo Question 2.

You are designing and developing a data warehouse for a retail company. Each sale is logged and tracked in the retail sales database. The retail sales database captures the following data: Date and Time of Sale, Customer Name, Customer Number, Customer Address, Invoice Number, Item Number, Item Description, Item Quantity, Item Price, Item Cost, Item Discount, and Salesperson ID. The sales manager needs to know the following information: Total Sales per week, Total Sales per week by Customer, Total Sales per week by Salesperson, and Total Sales per week by Item. At which level or levels should you set the granularity of data to meet the sales manager's requirements? (Choose all that apply.)

A. by day
B. by week
C. by customer
D. by invoice
E. by item
F. price
G. by salesperson
H. by total sales


Display Answer

Answer: B, C, E, G

Explanation: The granularity should be set by week, by customer, by item, and by salesperson. Incorrect