Microsoft 70-466 Implementing Data Models and Reports with Microsoft SQL Server 2012 Exam Practice Test

You need to modify the Sales Regions hierarchy to meet the reporting requirements.

Which SSAS feature should you use?

You manage a SQL Server Reporting Services (SSRS) instance. The

ReportingServicesService.exe.config file has been modified to enable logging.

Some users report that they cannot access the server.

You need to ascertain the IP addresses of the client computers that are accessing the server.

What should you do?

You need to configure SSRS to meet the maximum number of snapshots requirement.

What should you do? (Each answer presents a complete solution. Choose all that apply.)

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model has tables named Invoice Line Items and Products.

The Invoice Line Items table has the following columns:

Product Id

Unit Sales Price

The Unit Sales Price column stores the unit price of the product sold.

The Products table has the following columns:

Product Id

Maximum Sales Price

The Maximum Sales Price column is available only in the Products table.

You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced column must store a value of TRUE if the value of the Unit Sales Price is greater than the value of the Maximum Sales Price. Otherwise, a value of FALSE must be stored.

You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column.

Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query facts by using a hierarchy named Geography from a dimension named Geography.

The DimGeography table in the data source view is used as the source of the Geography dimension. The table has the following structure.

The Geography dimension has three attribute hierarchies:

- City

- State-Province

- Country

The attributes have the following relationships defined: City> State-Province > Country. Each attribute has a key and a name sourced from the related key and name columns in the DimGeography table.

During processing, you receive the following error message:

'Errors in the OLAP storage engine:

A duplicate attribute key has been found when processing:

Table: 'dbo_DimGeography',

Column: 'StateProvinceKey', Value: '23'.

The attribute is State-Province'."

You verify that the data is accurate.

You need to ensure that the dimension Processes successfully.

What should you do?

You are modifying a SQL Server Analysis Services (SSAS) cube.

The cube consists of a single measure group that contains the following measures:

* Total Quantity On Hand

* Average Quantity On Hand

The measure group has a single partition that uses the MOLAP storage mode.

You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly.

What should you do?

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server.

The Developer role cannot view and modify report caching parameters.

You need to ensure that the Developer role can view and modify report caching parameters.

Which task should you add to the Developer role?