Q1. - (Topic 7) 

You need to identify the reasons that data alert notifications are not being sent. 

Which of the following reasons are possible? (Each correct answer presents a complete solution. Choose al that apply.) 

A. The shared schedule is paused. 

B. The data source used by the report is disabled. 

C. The SSRS service is not running. 

D. The report data has not changed since the previous notification 

E. The SQL Server Agent is not running. 

F. The SSRS encryption key has been deleted. 

View Answer

Q2. - (Topic 9) 

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

Q3. HOTSPOT - (Topic 10) 

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

You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of 

the previous year. (Line numbers are included for reference only.) 

You need to complete the MDX statement. 

Which MDX function should you use in line 03? To answer, select the appropriate MDX function in the functions list. 

View Answer

Q4. HOTSPOT - (Topic 10) 

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.) 

View Answer

Q5. - (Topic 4) 

You need to develop a BISM that meets the business requirements for ad-hoc and daily operational analysis. You must minimize development effort. 

Which development approach and mode should you use? 

A. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to DirectQuery. 

B. Develop a tabular project and configure the model with the DirectQuery mode setting on and the project query mode set to In-Memory with DirectQuery. 

C. Develop a multidimensional project and configure the model with the DirectQuery mode setting off. 

D. Develop a multidimensional project and configure the cube to use hybrid OLAP (HOLAP) storage mode. 

View Answer

Q6. DRAG DROP - (Topic 9) 

You develop a SQL Server Integration Services (SSIS) project named Project1 by using 

SQL Server Data Tools (SSDT). Project1 contains a package named Package1. 

You add a project parameter named EnvironmentText to Project1. 

In SQL Server Management Studio (SSMS), you create the SSIS catalog. 

You have the following requirements: 

. Configure Package1 so it can run within either a development environment or a test environment. 

. Pass the value of an SSIS environment variable to the EnvironmentText project parameter. 

. The value of the environment variable must be different for each SSIS environment. 

You need to deploy the SSIS project and configure the SSIS environment. 

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.) 

View Answer

Q7. DRAG DROP - (Topic 9) 

You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have 

access to the original password that was used to create the SSIS catalog. A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog. 

The production server that hosts the SSISDB database fails. 

Sensitive data that is encrypted in the SSISDB database must not be lost. 

You need to restore the production SSIS catalog to the disaster recovery server. 

Which three steps 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. 

View Answer

Q8. - (Topic 8) 

You need to recommend a partitioning strategy that meets the performance requirements for CUBE1. 

What should you include in the recommendation? 

A. Create separate measure groups for each distinct count measure. 

B. Createone measure group for all distinct count measures. 

C. Createa separate dimension for each distinct count attribute. 

D. Createone dimension for all distinct count attributes. 

View Answer

Q9. - (Topic 8) 

You execute the SalesbyCategory report and receive the following error message: "Members, tuples, or sets must use the same hierarchies in the function." 

You need to ensure that the query executes successfully. 

Which two actions should you perform? Each correct answer presents part of the solution. 

A. Move the Product clause from line 08 to line 10. 

B. Move the Date and Product clauses on line 11 to axis 0. 

C. Move the Date clause from line 10 to line 08. 

D. Move the Measures clause on line 02 to axis 1. 

View Answer

Q10. DRAG DROP - (Topic 7) 

You are creating the Australian postal code query. 

Which arguments should you use to complete the query? 

To answer, drag the appropriate arguments to the correct location or locations in the 

answer area. (Use only arguments that apply.) 

View Answer