Microsoft
70-466 · Question #112
70-466 Question #112: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #112. The question stem and answer options stay visible for context.
Configure and maintain an analysis services database
Question
FactInternetSales table, in the DimProduct table, and in the DimCustomer table. In the model, the FactInternetSales table is also partitioned by month. You need to ensure that the model has the most recent data while minimizing the processing time. What should you do?
Options
- AProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer cable with the Process Defrag processing option.
- BProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.
- CProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Data processing option.
- DProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.
- EProcess the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 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
#tabular model processing#Process Data#Process Recalc#partition processing