70-466 Question #108: Real Exam Question with Answer & Explanation

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 writing enable the partition?