Free Microsoft 070-466 Exam Dumps Questions & Answers

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant permission for salespersons to be able to view only the data based on their sales territory.
What should you do?

• A.Create a role and then create a Multidimensional Expressions (MDX) filter.
• B.Create a member and then create a Data Analysis Expressions (DAX) filter.
• C.Create a role and then create a Data Analysis Expressions (DAX) filter.
• D.Create a member and then create a Multidimensional Expressions (MDX) filter.

You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string.
You need to configure the appropriate query mode.
Which query mode should you select?

• A.In-Memory
• B.DirectQuery
• C.DirectQuery with In-Memory
• D.In-Memory with DirectQuery

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

• A.A multidimensional project that uses the MOLAP storage mode
• B.A multidimensional project that uses the ROLAP storage mode
• C.A tabular project that uses the DirectQuery query mode
• D.A tabular project that uses the In-Memory query mode
• E.A PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010

You are working with a SQL Server Reporting Services (SSRS) instance in native mode.
An item role named Reports Writer is present on the server.
The Reports Writer role cannot view and modify report caching parameters.
You need to ensure that the Reports Writer role can view and modify report caching parameters.
What should you do?

• A.Add the Manage all subscriptions task to the Reports Writer role.
• B.Add the Manage individual subscriptions task to the Reports Writer role.
• C.Add the View data sources task to the Reports Writer role.
• D.Add the Manage report history task to the Reports Writer role.

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?

• A.Set the ProcessingMode property of the Planning partition to LazyAggregations.
• B.Set the ProcessingMode property of the Planning measure group to LazyAggregations.
• C.Set the Type property of the Planning measure group to Budget.
• D.Remove the Forecast Count measure.
• E.Set the StorageMode property of the Planning partition to Rolap
• F.Convert the Planning measure group to a linked measure group.