Microsoft
70-467 · Question #187
70-467 Question #187: Real Exam Question with Answer & Explanation
The correct answer is C: Remove the Forecast Count measure.. A cube can be write-enabled only if all its measures use the Sum aggregate function.
Question
You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group. The Planning measure group consists of two measures: - Forecast, which uses the Sum aggregate function - Forecast Count, which uses the Count aggregate function Users contribute planning values by using a legacy application. An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse. Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis. You need to write-enable the Planning partition. What should you do before write-enabling the partition?
Options
- ASet the ProcessingMode property of the Planning partition to LazyAggregations.
- BSet the Type property of the Planning measure group to Budget.
- CRemove the Forecast Count measure.
- DConvert the Planning measure group to a linked measure group.
- ESet the StorageMode property of the Planning partition to Rolap.
- FSet the ProcessingMode property of the Planning measure group to LazyAggregations.
Explanation
A cube can be write-enabled only if all its measures use the Sum aggregate function.
Community Discussion
No community discussion yet for this question.