Q1. - (Topic 4) 

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

An application must pass credentials to the local security authority for Reporting Services. 

You need to configure Reporting Services to issue a challenge/response when a 

connection is made without credentials. 

Which authentication type should you configure in the RSReportServer.config file? 

A. RSWindowsKerberos 

B. RSWindowsNegotiate 

C. RSWindowsNTLM 

D. RSWindowsBasic 

View Answer

Q2. - (Topic 4) 

You create a materialized reference dimension between a dimension named Regions and a measure group named Orders. 

You use a table named Customers as a bridge as shown in the exhibit. (Click the Exhibit button.) 

You need to ensure that data is updated to reflect any changes in the relationship. The solution must NOT require that the entire cube be reprocessed. 

What should you reprocess? 

A. The Sales partition 

B. The Regions dimension 

C. The Customers dimension 

D. The Orders partition 

View Answer

Q3. DRAG DROP - (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) tabular project based on a Microsoft Azure SQL Database database. The ProcessingOption property for the project is set to Do Not Process. 

Several calculated columns have been added to a table. The project has been deployed to the production server. 

You need to ensure that newly added data is processed on the production server. 

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

Q4. - (Topic 4) 

You are developing a SQL Server Reporting Services (SSRS) report that renders in HTML. The report includes a dataset with fields named Description. Price, and Color. The report layout includes a table that displays product details and also includes columns named Description, Price, and Color. 

You need to modify the report so that users can sort products by the Price column. 

What should you do? 

A. Set the SortExpression value to = Fields!Price.Description for the Price text box. 

B. Set the SortExpression property to =Fields!Price.Name for the Price text box. 

C. Set the SortExpression property to =Fields!Price.Value for the Price text box. 

D. Add a custom action to the Price text box. 

View Answer

Q5. DRAG DROP - (Topic 4) 

You have a single SQL Server 2008 R2 Analysis Services (SSAS) instance. You are planning to upgrade the instance to SQL Server 2014. 

You need to import an existing PowerPivot workbook to create a tabular project. 

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

Q6. HOTSPOT - (Topic 4) 

You are designing a dimension named Employee for a SQL Server Analysis Services 

multidimensional project. 

The Employee dimension contains a DateOfBirth attribute and a MaritalStatus attribute. 

You need to minimize the amount of time required to process the cube. 

What should you do? To answer, select the appropriate relationship type for each attribute 

in the answer area. 

View Answer

Q7. - (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) tabular project for a Power View solution. 

You need to grant permission for salespersons to view only the data based on their sales territory. 

What should you do? 

A. Create a member and then create a Data Analysis Expressions (DAX) filter. 

B. Create a member and then create a Multidimensional Expressions (MDX) filter. 

C. Use SQL Server Management Studio to create a role. Then create a Data Analysis Expressions (DAX) filter. 

D. Use SQL Server Management Studio to create a role. Then create a Multidimensional Expressions (MDX) filter. 

View Answer

Q8. - (Topic 4) 

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance. 

You need to ascertain the memory consumed by each object in the SSAS instance. 

What should you do? 

A. Use the $System.discover_object_memory_usage dynamic management view. 

B. Use SQL Server Profiler to review session events for active sessions. 

C. Use the Usage Based Optimization wizard to design appropriate aggregations. 

D. Use the Performance Counter group named Processing. 

View Answer

Q9. - (Topic 4) 

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

You need to create a measure to count unique customers. 

What should you do? 

A. Use role playing dimensions. 

B. Use the Business Intelligence Wizard to define dimension intelligence. 

C. Add a measure that uses the Count aggregate function to an existing measure group. 

D. Add a measure that uses the DistinctCount aggregate function to an existing measure group. 

E. Add a measure group that has one measure that uses the DistinctCount aggregate function. 

F. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions. 

G. Add a hidden measure that uses the Sum aggregate function. Add a calculated measure aggregating the measure along the time dimension. 

H. Create several dimensions. Add each dimension to the cube. 

I. Create a dimension. Then add a cube dimension and link it several times to the measure group. 

J. Create a dimension. Create regular relationships between the cube dimension and the measure group. Configure the relationships to use different dimension attributes. 

K. Create a dimension with one attribute hierarchy. Set the IsAggrcgatable property to False and then set the DefaultMember property. Use a regular relationship between the dimension and measure group. 

L. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group. 

M. Create a dimension with one attribute hierarchy. Set the IsAggregatable property to False and then set the DefaultMember property. Use a many-to-many relationship to link the dimension to the measure group. 

N. Create a dimension with one attribute hierarchy. Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember property. Configure the cube dimension so that it does not have a relationship with the measure group. Add a calculated measure that uses the MemberValue attribute property. 

O. Create a new named calculation in the data source view to calculate a rolling sum. Add a measure that uses the Max aggregate function based on the named calculation. 

View Answer

Q10. - (Topic 1) 

You need to modify the environment before you create the QuarterSales report. 

What should you do? 

A. Add a date table to the model that contains columns for the fiscal and calendar quarters. 

B. Add a date table to the model that contains measures for the fiscal and calendar quarters. 

C. Configure a time dimension by using the Time Intelligence Wizard. 

D. Configure SSAS to use a server time dimension. 

View Answer