You are developing a SQL Server Reporting Services (SSRS) report.
The report includes a dataset with fields named Year, MonthNumber, and InvCount.
The report includes a table that displays the inventory count per year, as shown in the following diagram.
You need to modify the table to include a graphicalitem displaying the inventory count trend to the right of the
Inv Count column.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) multidimensional database.
The underlying data source does not have a time dimension table.
You need to implement a time dimension.
What should you do?

You are troubleshooting query performance for a SQLServer Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query s
tatement in a trace by using SQL Server Profiler.
Which event class should you use?

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.)
01 CREATE MEMBER CURRENTCUBE.Measures.SamePeriodPreviousYearSales AS
02 (Measures.[Sales Amount],
03 ________________ (
04 [Date Order].[Calendar].[Calendar Year],
05 1,
06 [Date Order].[Calendar].CurrentMember)),
07 FORMAT_STRING = “#,#.00”;
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.

You are managing a SQL Server Reporting Services (SSRS) instance in native mode.
A system role named Developer Support is present onthe server.
Members of the Developer Support role cannot modifythe report execution timeout period.
You need to enable members of the Developer Supportrole to modify the report execution timeout period.
Which task should you add to the Developer Support role?

You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services
(SSAS) cube.
The cube is used to measure sales growth by salesperson.
The cube contains a Key Performance Indicator (KPI)to show if a salesperson s sales are off target, slightly off
target, or on target.
You need to add a report item that visually displays the KPI status value as a red, yellow, or green flag.
Which report item should you add?

You are creating a new report in SQL Server Report Builder.
You add a SQL Azure data source.
Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following diagram.

The category rows (the first three rows as shown inthe diagram) must present total sales amount by category.
The country rows (the next six rows as shown in thediagram) must present total sales amount by country.
The total row must present the total sales for eachyear.
You add a matrix to the report.
You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?

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?

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast
data sourced from a financial database.
The model will be deployed to a server with 28 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 15 terabytes of disk spaceand is
doubling in size every month.
The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?

You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure
database.
You need to design the report to show the sum of sales.
The sales must be grouped by region on the rows andyear on the columns.
Which report item should you add? To answer, selectthe appropriate setting in the answer area.