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 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 in the diagram) must present total sales amount by category.
The country rows (the next six rows as shown in the diagram) must present total sales amount by country.
The total row must present the total sales for each year.
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 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 managing a SQL Server Reporting Services (SSRS) instance in native mode.
A system role named Developer Support is present on the server.
Members of the Developer Support role cannot modify the report execution timeout period.
You need to enable members of the Developer Support role to modify the report execution timeout period.
Which task should you add to the Developer Support role?

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 troubleshooting query performance for a SQL Server 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) 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 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 graphical item 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) tabular project.
The model has tables named Invoice Line Items and Products.
The Invoice Line Items table has the following columns:
– Product Id
– Unit Sales Price
The Unit Sales Price column stores the unit price of the product sold.
The Products table has the following columns:
– Product Id
– Minimum Sales Price
The Minimum Sales Price column is available only in the Products table.
You add a column named Is Undersell to the Invoice Line Items table.
The Is Undersell column must store a value of TRUE if the value of the Unit Sales Price is less than the value
of the Minimum Sales Price.
Otherwise, a value of FALSE must be stored.
You need to define the Data Analysis Expressions (DAX) expression for the Is Undersell column.
Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance,
sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use.
The sales team does not need any information other than sales-related resources in the tabular model.
The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and
administrative effort.
What should you do?