Microsoft
70-467 · Question #126
70-467 Question #126: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #126. The question stem and answer options stay visible for context.
Question
You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube named Sales. Before the initial deployment of the cube, partition design was optimized for processing time. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.
Options
- AUse the Usage-Based Optimization Wizard to create aggregations for the current partitions.
- BUse the Aggregation Design Wizard to create aggregations for the current partitions.
- CCombine all the partitions into a single partition.
- DCombine all the partitions into a single partition.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 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.