Microsoft
70-463 · Question #75
70-463 Question #75: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #75. The question stem and answer options stay visible for context.
Design and implement a data warehouse
Question
You are reviewing the design of an existing fact table named factSales, which is loaded incrementally from a SQL Azure database by a SQL Server Integration Services (SSIS) package each hour. The fact table has approximately 4 billion rows and is dimensioned by product, sales date, and sales time of day. The database administrator is concerned about the rapid growth of the database and users experience poor reporting performance against this database. Reporting requirements have recently changed and the only remaining report that uses this fact table reports sales by product name, sale month, and sale year. No other reports will be created against this table. You need to reduce the report processing time and minimize the growth of the database. What should you do?
Exhibit
Options
- ACreate an indexed view over the fact table to sum orderTotal by month.
- BCreate a view over the fact table to sum orderTotal by month.
- CChange the granularity of the fact table to month.
- DPartition the fact table by productKey.
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.
Topics
#fact table granularity#performance optimization#4 billion rows#reporting