You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment. The production database has been configured with security roles. You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server. Which deployment method should you use?

A.

Use the SQL Server Analysis Services Deployment Wizard.

B.

Backup and restore the database.

C.

Use the SQL Server Analysis Services Migration Wizard.

D.

Deploy the project from SQL Server Data Tools to the production server.

Correct Answer: A

QUESTION 152

You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings. The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows. You need to ensure that all rows are available in the cube while minimizing the processing time. Which processing option should you use?

You are developing a SQL Server Analysis Services (SSAS) multidimensional project. The project file includes two cubes named Finance and Operations. The project also includes a dimension named Date. The Date dimension includes two hierarchies named Fiscal and Calendar. The Date dimension has been added to both cubes. You need to disable the Fiscal hierarchy in the Operations cube without impacting other database objects. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Correct Answer:

QUESTION 154

HOTSPOT

You are developing a SQL Server Analysis Services (SSAS) cube. You create a degenerate dimension. You need to define a relationship type for the dimension. Which relationship type should you select? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

Correct Answer:

QUESTION 155

You are modifying a SQL Server Analysis Services (SSAS) cube. Users of the cube report that the precision for the TransactionCost measure is five digits. You need to ensure that the TransactionCost measure stores values to two digits of precision. What should you do?

A.

Use the FormatString measure property to format TransactionCost as Currency.

B.

Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new column.

C.

Add a named query in the data source view that casts the data source column to two digits of precision. Bind the TransactionCost measure to the new query.

D.

Use the MeasureExpression measure property to change the precision of TransactionCost to two digits.

E.

Use the FormatString measure property to format TransactionCost as #, ##0.00;- #,##0.00.

Correct Answer: B

QUESTION 156

HOTSPOT

You are developing a SQL Server Analysis Services (SSAS) cube. Revenue must be compared to a goal and described by a status and a trend. Revenue, goal, status, and trend will be defined by Multidimensional Expressions (MDX) expressions. You need to add the Revenue indicator. Which tab should you select? (To answer, select the appropriate tab in the work area.)

The Research and Development team has requested that capabilities be added to the database.

The capabilities must meet the following requirements:

A device member must be able to have multiple capability members.

A capability member must be able to belong to several device members.

The Research and Development team must be able to create new capabilities every quarter in the data source.

You need to implement the appropriate solution to meet the requirements while ensuring that the amount of development and maintenance time is minimized.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A.

Create a dimension named Capability Name and then configure a many-to-many relationship.

B.

Add an attribute hierarchy for each capability to the customer dimension. Configure each hierarchy to have two members named Yes and No.

C.

Create a dimension named Capability Name and then configure a regular relationship.

D.

Add an attribute hierarchy named Capability Name to the customer dimension.

Correct Answer: A

QUESTION 158

You are adding dimensions and a new measure group named Service Quality to an existing SQL Server Analysis Services (SSAS) cube. Date is one of the existing dimensions in the SSAS database. The underlying fact table for the measure group is associated with multiple dates, including FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You need to ensure that users can slice the Service Quality measures by FirstServiceDate, SecondServiceDate, and ThirdServiceDate. You also need to ensure that the time required to process the database is minimized. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A.

Create cube dimensions named FirstServiceDate. SecondServiceDate, and ThirdServiceDate by using the existing date dimension in the database.

and ThirdServiceDate and then link all three of them to the Service Quality measure group.

C.

Create three new perspectives named FirstServiceDate. SecondServiceDate, and ThirdServiceDate.

D.

Add three attributes named FirstServiceDate. SecondServiceDate, and ThirdServiceDate to the existing date dimension in the database.

Correct Answer: C

QUESTION 159

You develop a SQL Server Analysis Services (SSAS) stored procedure. You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the stored procedure. What should you do?

A.

Register the assembly on the SSAS server instance.

B.

Copy the assembly to the SSAS installation directory and register it by using the CREATE ASSEMBLY T-SQL command.

C.

Register the assembly on the SSAS server by using regedit.exe.

D.

Register the assembly on the SharePoint server by using regeditexe.

Correct Answer: B

QUESTION 160

DRAG DROP

You have a cube named Cube1 that contains the sales data for your company. You plan to build a report based on the cube. You need to write an MDX expression that returns the total sales from the first month of the 2009 fiscal year and the total sales from the same period of the 2008 fiscal year. Which code segments should you insert at line 03 and line 05? To answer, drag the appropriate code segments to the correct lines. Each code segments may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.