Q1. You are designing a complex report that displays sales metrics for a customer hierarchy. The customer hierarchy has six levels and contains approximately 1 million members. 

You have the following requirements: 

Allow users to easily display and navigate data. 

Minimize report processing time. 

Simplify the report design and maintenance processes. 

You need to design a report that meets the requirements. 

How should you design the report? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. Retrieve all customers and use drilldown groupings to show or hide hierarchy levels. 

B. Add a report part for each hierarchy level. 

C. Add a subreport for each hierarchy level. 

D. Display only the children of the current hierarchy level and drill through to the selected member. 

View Answer

Q2. You need to select and configure a tool for the monitoring solution. 

What should you choose? 

A. Performance Monitor configured with the MSAS11:Storage Engine Query counter 

B. Performance Monitor configured with the MSAS11:Processing counter 

C. SQL Server Profiler configured with the Query Processing: Query Subcube event 

D. SQL Server Profiler configured with the Queries Events: Query Begin event 

View Answer

Q3. You need to perform the pre-upgrade database backup operation by using SQL Server Management Studio (SSMS). 

How should you configure the backup options? 

A. Select the Apply compression check box. Select the Encrypt backup file check box and supply a password. 

B. Clear the Apply compression check box. Select the Encrypt backup file check box and supply a password. 

C. Clear the Apply compression check box. Clear the Encrypt backup file check box. 

D. Select the Apply compression check box. Clear the Encrypt backup file check box. 

View Answer

Q4. You need to select the appropriate mode for the Sales database. 

Which mode should you select? 

A. ROLAP 

B. Direct Query 

C. MOLAP 

D. In-Memory 

View Answer

Q5. You need to configure the Scenario attribute to ensure that business users appropriately query the Sales Plan measure. 

What should you do? (Each correct answer presents part of the solution. Choose all that apply.) 

A. Set the AttributeHierarchyVisible property to False. 

B. Set the IsAggregatable property to False. 

C. Set the Usage property to Parent. 

D. set the DefaultMember property to the Forecast member. 

E. Set the AttributeHierarchyEnabled property to False. 

F. Set the RootMemberIf property to ParentIsMissing. 

View Answer

Q6. You need to ensure that queries to the Sales Analysis cube default to the correct time period. 

Where should you set the default member Multidimensional Expressions (MDX) expression? 

A. In the DefaultMember property of the Month attribute of the Date dimension. 

B. In the cube's calculation script. 

C. In the DefaultMeasure property of the cube. 

D. In the Analysts role. 

View Answer