NEW QUESTION 1

You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?

• A. Implement the cube as a local cube.
• B. Ensure that the measure group measures only use semiadditive aggregation functions.
• C. Implement the linked measure group as a local measure group.
• D. Ensure that the measure group measures only use nonadditive aggregation functions

Answer: C

NEW QUESTION 2

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Revenue and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of revenue.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: ACD

NEW QUESTION 3

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique color scheme combination of foreground and background colors.
You need to ensure that all of the text boxes in the table headers use the correct business unit colors.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Add one report variable for Colo
• B. Assign it with an expression to return the appropriate color
• C. For each header text box, set the Color and BackgroundColor properties by using the variable.
• D. Add two report variables named Color and BackgroundColo
• E. Assign them with expressions to return the appropriate color
• F. For each header text box, use expressions to set the Color and BackgroundColor properties by using the variables.
• G. For each header text box, assign expressions to the Color and BackgroundColor properties.
• H. Add two Microsoft Visual C# functions to the code block of the report to implement Color and BackgroundColor function
• I. For each header text box, use expressions to set the Color and BackgroundColor properties by using the functions.

Answer: D

NEW QUESTION 4

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 measur
• B. Then set the target valu
• C. Check in the changes before the next release cycle.
• D. Create a KPI based on the OrderQuantity column and then set the target valu
• E. Check in the changes before the next release cycle.
• F. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measur
• G. Then set the target valu
• H. Check in the changes before the next release cycle.
• I. Create a measure by using the SUM((OrderQuantity]) expressio
• J. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target valu
• K. Check in the changes before the next release cycle.

Answer: D

NEW QUESTION 5
DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube. You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), 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.)

• A. Mastered
• B. Not Mastered

Answer: A

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* You can use the Linked Object Wizard to either link to or import cubes, dimensions, measure groups, calculations, and Key Performance Indicators (KPIs). You can link to or import these items from another database on the same server or from a database on a remote server
* On the Select a Data Source page of the Linked Object Wizard, choose the Analysis Services data source or create a new one.
* On the Select Objects page of the wizard, choose the dimensions you want to link to in the remote database. You cannot link to linked dimensions in the remote database.
* Incorrect:
The Business Intelligence Wizard can guide you through some or all the following steps: Define time intelligence for cubes.
Define account intelligence for cubes and dimensions. Define dimension intelligence for cubes and dimensions. Define unary operators for cubes.
Set custom member formulas for cubes and dimensions. Specify attribute ordering for dimensions.
Enable dimension writeback for dimensions. Define semi-additive behavior for cubes. Define currency conversion for cubes.

NEW QUESTION 6

You are developing a SQL Server Reporting Services (SSRS) sales summary report.
The report header consists of several images. Report users require PDF exports of the report with no bulky images of the report header.
You need to ensure that the header of the report is hidden when a user exports the report to PDF format.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Set the Hidden property of the report header to (Globals!RenderFormat.Name = "PDF").
• B. Set the Hidden property of the report header to (Globals!RenderFormat.IsInteractive = False).
• C. Set the Hidden property of the report header to FALSE.
• D. Set the Hidden property of the report header to TRUE.

Answer: A

NEW QUESTION 7

You maintain SQL Server Analysis Services (SSAS) instances.
You need to configure an installation of PowerPivot for Microsoft SharePoint in a SharePoint farm.
Which tool should you use? (Each correct answer presents a complete solution. Choose all that apply.)

• A. SQL Server Configuration Manager
• B. PowerPivot Configuration Tool
• C. SharePoint Products Configuration Wizard
• D. SharePoint Central Administration
• E. PowerShell

Answer: ABD

NEW QUESTION 8

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.

Answer: A

NEW QUESTION 9

You need to create the KPI in the AdhocReports project. What should you do?

• A. Create a measure by using the SUM([OrderQuantity]) expressio
• B. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value.
• C. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measur
• D. Then set the target value.
• E. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measur
• F. Then set the target value.
• G. Create a KPI based on the OrderQuantity column and then set the target value.

Answer: A

NEW QUESTION 10

You are designing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department has the following requirements for the cube:
✑ Include a year-over-year (YOY) calculation
✑ Include a month-over-month (MOM) calculation
You need to ensure that the calculations are implemented in the cube. Which Multidimensional Expressions (MDX) function should you use?

• A. UNREGINTERCEPT()
• B. LASTPERIODS()
• C. TIMEINTELLIGENCE()
• D. PARALLELPERIOD()

Answer: D

NEW QUESTION 11

You work in the Business Intelligence (BI) department of a multinational company.
To share its sales data between the various subsidiaries, the company has requested a new corporate BI solution that meets the following requirements:
✑ The solution must use SQL Server Analysis Services (SSAS) multidimensional or tabular Business Intelligence Semantic Model (BISM).
✑ The model must incrementally add 10 million fact rows of sales data per month.
✑ The model must be translated to English, German, Chinese, or Spanish based on users' locale.
✑ The model must be able to contain the most recent 36 months of data, in order to let users query the data.
You need to select the appropriate model type and partitioning strategy to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Create and deploy a BISM multidimensional model with one partition for all of the data.
• B. Create and deploy a BISM tabular model with one partition for each of the 36 months.
• C. Create and deploy a BISM multidimensional model with one partition for each of the 36 months.
• D. Create and deploy a BISM tabular model with one partition for all of the data.

Answer: C

NEW QUESTION 12

You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the Customer Geography dimension supports relationships between attributes.
You need to increase query and dimension processing performance.
What should you do?

• A. For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.
• B. For the dimension attributes of the Customer Geography dimension, set the GroupingBehavior property to EncourageGrouping.
• C. For the Customer Geography dimension, set the Processing Mode property to LazyAggregations.
• D. For the Customer Geography dimension, set the ProcessingPriority property to 1.

Answer: A

NEW QUESTION 13

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year Month Number, and InvCount. The report includes a table that displays the inventory count per year, as shown in the following table.

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?

• A. Add an Indicator item to a new column on the right of the Inv Count colum
• B. Select the Directional Indicator type and then assign the MonthNumber field to the Start property.
• C. Add a Sparkline item to a new column on the right of the Inv Count colum
• D. Then select the InvCount field for Values and the MonthNumber field for Series Groups.
• E. Add a Sparkline item to a new column on the right of the Inv Count colum
• F. Then select the InvCount field for Values and the MonthNumber field for Category Groups.
• G. Add a text box to a new column on the right of the Inv Count colum
• H. Then use a Go to report action to link to a separate report showing the monthly trend.
• I. Add an Indicator item to a new column on the right of the Inv Count colum
• J. Select the Directional Indicator type and then select the MonthNumber field for Value.

Answer: C

NEW QUESTION 14

You manage a SQL Server Reporting Services (SSRS) instance in SharePoint integrated mode.
You identify a problem with the operations performed by the Report Server Web service. You need to view the Report Server trace logs. In which directory should you view the
files?

• A. %ProgramFiles%Microsoft SQL ServerMSRS10_50.MSSQLSERVERReporting ServicesLogFiles
• B. %ProgramFiles%Common FilesMicrosoft SharedWeb Server Extensions14Web ServicesReportServerLogFiles
• C. %ProgramFiles%Common FilesReportServerLogFiles
• D. %ProgramFiles%Microsoft SQL ServerMSRS11.MSSQLSERVERReporting ServicesLogFiles

Answer: D

NEW QUESTION 15

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?

• A. Create a separate partition for each team.
• B. Create a separate data source for each team.
• C. Create a perspective for the sales team.
• D. Enable client side security to filter non-sales data.

Answer: C

NEW QUESTION 16

You are creating a SQL Server Analysis Services (SSAS) multidimensional database.
Users need a time dimension for:
✑ Dates
✑ Delivery dates
✑ Ship dates
You need to implement the minimum number of required SSAS objects. 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 that uses the LastNonEmpty aggregate functio
• F. Use a regular relationship between the time dimension and the measure group.
• G. Add a measure group that has one measure that uses the DistinctCount aggregate function.
• H. Add a calculated measure based on an expression that counts members filtered by the Exists and NonEmpty functions.
• I. Add a hidden measure that uses the Sum aggregate functio
• J. Add a calculated measure aggregating the measure along the time dimension.
• K. Create several dimension
• L. Add each dimension to the cube.
• M. Create a dimensio
• N. Then add a cube dimension and link it several times to the measure group.
• O. Create a dimensio
• P. Create regular relationships between the cube dimension and the measure grou
• Q. Configure the relationships to use different dimension attributes.
• R. Create a dimension with one attribute hierarch
• S. Set the IsAggregatable property to False and then set the DefaultMember propert
• T. Use a regular relationship between the dimension and measure group.
• . Create a dimension with one attribute hierarch
• . Set the IsAggregatable property to False and then set the DefaultMember propert
• . Use a many-to-many relationship to link the dimension to the measure group.
• . Create a dimension with one attribute hierarch
• . Set the ValueColumn property, set the IsAggregatable property to False, and then set the DefaultMember propert
• . Configure the cube dimension so that it does not have a relationship with the measure grou
• . Add a calculated measure that uses the MemberValue attribute property.
• . Create a new named calculation in the data source view to calculate a rolling su
• . Add a measure that uses the Max aggregate function based on the named calculation.

Answer: A

NEW QUESTION 17

You are developing a SQL Server PowerPivot workbook that sources data from a Microsoft Azure SQL Database database. The PowerPivot model includes a single table named FactSales that consists of four columns named Year, Country, Product and Revenue. The model includes the following two measures.
✑ Sales:=SUM(FactSales[Revenue])
✑ Sales %:=[Sales] / CALCULATE([Sales], ALL(FactSales))
In Microsoft Excel 2010 you create the following PivotTable report.

Users report that the Sales % measure computes an incorrect ratio. The measure should meet a requirement to compute a ratio over all visible sales values defined by the query filters. The Grand Total value for the Sales % measure should equal 100%.
You need to fix the Sales % measure to meet the requirement. Which Data Analysis Expressions (DAX) expression should you use?

• A. = [Sales] / CALCULATE([Sales])
• B. = [sales] / [Sales](ALLSELECTED(FactSales))
• C. = [sales] / CALCULATE([Sales], VALUES(FactSales[Year]), VALUES(FactSales[Country]))
• D. = [sales] / [Sales](ALLEXCEPT(FactSales, FactSales[Year]))

Answer: B

NEW QUESTION 18

You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT).
The report must define a report parameter to prompt the user for the business unit. Each business unit has a unique font scheme combination of font and size properties.
You need to ensure that all of the text boxes in the table headers use the correct business unit font properties.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Add one report variable for FontFamily Assign it with an expression to return the appropriate color
• B. For each header text box, set the Color and FontSize properties by using the variables.
• C. For each header text box, assign expressions to the FontFamily and FontSize properties.
• D. Add two report variables named FontFamily and FontSiz
• E. Assign them with expressions to return the appropriate color
• F. For each header text box, use expressions to set the FontFamily and FontSize properties by using the variables.
• G. Add two Microsoft Visual C# functions to the code block of the report to implement FontFamily and FontSize function
• H. For each header text box, use expressions to set the FontFamily and FontSize properties by using the functions.

Answer: D

NEW QUESTION 19

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 rol
• D. Then create a Data Analysis Expressions (DAX) filter.
• E. Use SQL Server Management Studio to create a rol
• F. Then create a Multidimensional Expressions (MDX) filter.

Answer: C

NEW QUESTION 20

You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string.
You need to configure the appropriate query mode. Which query mode should you select?

• A. In-Memory with DirectQuery
• B. DirectQuery with In-Memory
• C. In-Memory
• D. DirectQuery

Answer: A

NEW QUESTION 21
......