Q1. HOTSPOT - (Topic 9) 

You administer a SQL Server Analysis Services (SSAS) cube. 

You plan to optimize the cube partitions by using usage-based optimization. 

You need to configure the SSAS instance. 

Which properties should you configure? To answer, select the appropriate properties in the 

dialog box in the answer area. 

View Answer

Q2. - (Topic 10) 

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server. 

The Folder Access Controller role consists of only the Set security for individual items task. When role members open Report Manager, they cannot view folders. 

You need to modify the Folder Access Controller role so that the role members can view folders. 

Which task should you add to the Folder Access Controller role? 

A. Manage data sources 

B. Manage folders 

C. View models 

D. View reports 

View Answer

Q3. - (Topic 7) 

You need to ensure that the Sales measure in the Power View field list meets the 

requirements. 

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

A. Format the column to display zero decimal places. 

B. Hide the column from client tools. 

C. Create a measure named Sales based on the column by using the Data Analysis Expressions (DAX) SUM() function. 

D. Rename the column to Sales. 

E. Format the measure to display zero decimal places. 

View Answer

Q4. - (Topic 10) 

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database. 

The report must display the value and status of a Key Performance Indicator (KPI). 

Which report item should you use? (Each answer presents a complete solution. Choose all that apply.) 

A. Sparkline 

B. Gauge 

C. Indicator 

D. Data Bar 

E. Image 

View Answer

Q5. - (Topic 10) 

You are developing a SQL Server Reporting Services (SSRS) sales summary report. The report header consists of several images. 

You need to ensure that the header of the report is hidden when a user exports the report to PDF format. 

Which Hidden property expression should you use for the report header? (More than one answer choice may achieve the goal. Select the BEST answer.) 

A. = True 

B. = False 

C. = (Globals!RenderFormat.Name = "PDF") 

D. = (Globals!RenderFormat.IsInteractive = False) 

View Answer

Q6. DRAG DROP - (Topic 10) 

You manage a SQL Server Reporting Services (SSRS) instance running in native mode. 

You are troubleshooting a performance problem and need to know which reports are frequently executed. You discover that the report server execution logs are empty, despite significant report activity. 

You need to ensure that the server is configured for report execution logging. 

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. - (Topic 10) 

You are developing a SQL Server Analysis Services (SSAS) cube named Sales Planning. The cube consists of two measure groups named Sales and Planning. 

Each measure group is based on a data warehouse fact table and consists of a single MOLAP partition that has the same name as its measure group. 

The Planning measure group consists of two measures: 

.. 

Forecast, which uses the Sum aggregate function Forecast Count, which uses the Count aggregate function 

Users contribute planning values by using a legacy application. An extract, transform, load (ETL) process is scheduled to periodically transfer the planning values from the database of the legacy application to the data warehouse. 

Financial analysts query the Sales Planning cube and report that the planning values are sometimes out of date. A new company requirement mandates that the planning values be entered directly into the cube by using Microsoft Excel 2010 PivotTable What-If Analysis. 

You need to write-enable the Planning partition. 

What should you do before write-enabling the partition? 

A. Set the ProcessingMode property of the Planning partition to LazyAggregations. 

B. Set the Type property of the Planning measure group to Budget. 

C. Remove the Forecast Count measure. 

D. Convert the Planning measure group to a linked measure group. 

E. Set the StorageMode property of the Planning partition to Rolap. 

F. Set the ProcessingMode property of the Planning measure group to LazyAggregations. 

View Answer

Q8. - (Topic 8) 

You need to implement the SalesCommission model to support the planned reports and queries. 

What should you do? 

A. Create a date table that contains only one row for each date on which a sale is recorded. 

B. Use the existing transaction date column in the sales table for date calculations. 

C. Create a date table that contains a row for every date since data started being recorded. 

D. Create a new calculated date column in the sales table for date calculations. 

View Answer

Q9. DRAG DROP - (Topic 9) 

You are designing a SQL Server Analysis Services (SSAS) data model on a very large 

data warehouse. 

The fact tables in the data warehouse contain terabytes of data in tens of billions of rows. 

You must support the following features: 

... 

Complex attribute/column relationships Advanced calculations in the data model definition Advanced calculations using logic deployed in a custom assembly 

You need to choose the correct SSAS design strategy. 

What should you do? 

To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.) 

View Answer

Q10. DRAG DROP - (Topic 3) 

You need to extend the schema design to store the product dimension data. 

Which design should you use? 

To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.) 

View Answer