Microsoft
70-463 · Question #72
70-463 Question #72: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #72. The question stem and answer options stay visible for context.
Question
You are designing a data warehouse for a fresh food distribution business that stores sates by individual product. It stores sales targets by product category. Products are classified into subcategories and categories. Each product is included in only a single product subcategory, and each subcategory is included in only a single category. The data warehouse will be a data source for an Analysis Services cube. The data warehouse contains two fact tables: - factSales, used to record daily sales by product - factProductTarget, used to record the monthly sales targets by product category Reports must be developed against the warehouse that reports product sales by product, category and subcategory, and product sales targets. You need to design the product dimension. The solution should use as few tables as possible while supporting all the requirements. What should you do?
Options
- ACreate two product tables, dimProduct and dimProductCategory.
- BCreate one product table, dimProduct, which contains product detail, category, and
- CCreate three product tables, dimProduct, dimProductCategory, and dimProductSubcategory,
- DCreate three product tables, dimProduct, dimProductCategory, and dimProductSubcategory.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.