Q1. HOTSPOT - (Topic 4) 

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

Which tab should you select? (To answer, select the appropriate tab in the answer area.) 

View Answer

Q2. - (Topic 4) 

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

A model contains tables and columns that must not be visible to the user. The columns and tables cannot be removed because they are used in calculations. The calculations are used to calculate the budget and forecast for the current quarter. 

You need to hide the tables and columns. 

What should you do? 

A. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide option. 

B. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Visible property to True. 

C. Before adding the forecast calculations to the model, right-click the applicable tables and columns and select the Hide from Client Tools option. 

D. After adding the budget calculations to the model, in the Properties window for the applicable tables and columns, set the Enabled property to False. 

View Answer

Q3. - (Topic 4) 

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

The model includes a table named DimEmployee. The table contains employee details, including the sales territory for each employee. The table also defines a column named EmployeeAlias which contains the Active Directory Domain Services (AD DS) domain and logon name for each employee. You create a role named Employees. 

You need to configure the Employees roles so that users can query only sales orders for their respective sales territory. 

What should you do? 

A. Add a row filter that implements the LOOKUPVALUE and USERNAME functions. 

B. Add a row filter that implements only the CUSTOMDATA function. 

C. Add a row filter that implements the LOOKUPVALUE and CUSTOMDATA functions. 

D. Add a row filter that implements only the USERNAME function. 

View Answer

Q4. DRAG DROP - (Topic 4) 

You are developing a SQL Server Analysis Services (SAS) multidimensional project that is configured to source data from a SQL Azure database. 

You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source. 

You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition. 

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

Q5. - (Topic 3) 

You need to identify the reports that produce the errors that Marc is receiving. 

What should you do? 

A. Write a query by using the Subscriptions table in the report server database. 

B. Write a query by using the Execution Log 3 view in the report server database. 

C. Use the Windows Event Viewer to search the Application log for errors. 

D. Search the ReportServerService_<timestamp>.log file for errors. 

View Answer

Q6. - (Topic 3) 

You need to create the KPI in the AdhocReports project in time for the next production release cycle. 

What should you do? 

A. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle. 

B. Create a KPI based on the OrderQuantity column and then set the target value. Check in the changes before the next release cycle. 

C. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle. 

D. Create a measure by using the SUM((OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value. Check in the changes before the next release cycle. 

View Answer

Q7. - (Topic 4) 

You are developing a SQL Server Analysis Services (SSAS) tabular database. To maximize performance, queries must be resolved only by using cache. 

You need to configure the appropriate query mode. 

Which query mode should you select? 

A. DirectQuery with In-Memory 

B. In-Memory with DirectQuery 

C. In-Memory 

D. DirectQuery 

View Answer

Q8. DRAG DROP - (Topic 4) 

You have a database named DB1. DB1 contains four tables named FactSales, DimTime, DimCustomer, and DimEmployee. A sample from DimEmployee is shown in the following table. 

A sample from DimCustomer is shown in the following table. 

A sample from FactSales is shown in the following table. 

You need to identify which type of dimension must be created for each table. 

Which type of dimension should you create for each table? To answer, drag the appropriate dimensions to the correct tables. Each dimension 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. 

View Answer

Q9. DRAG DROP - (Topic 4) 

You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report parameters named StartDate and FinishDate as shown in the following diagram. 

The Data Type property of the parameters is set to Date/Time. 

You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters. 

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

Q10. - (Topic 3) 

You need to deploy the StandardReports project. 

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

A. Use the Analysis Services Deployment utility to create an XMLA deployment script. 

B. Deploy the project from SQL Server Data Tools (SSDT). 

C. Use the Analysis Services Deployment wizard to create an XMLA deployment script. 

D. Use the Analysis Services Deployment wizard to create an MDX deployment script. 

View Answer