Q1. - (Topic 4)
You are designing a SQL Server Reporting Services (SSRS) report based on a SQL Server Analysis Services (SSASJ cube.
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 circle.
Which report item should you add?
A. Linear Gauge
B. Indicator
C. Data Bar
D. Radial Gauge
E. Sparkline
Answer: B
Q2. HOTSPOT - (Topic 4)
You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows Azure SQL Database database table.
In a report table showing sales by countries and cities, you need to enable users to hide or show cities by clicking the name of a country.
Which property page of the city text box should you use? (To answer, select the appropriate tab in the answer area.)
Answer:
Q3. - (Topic 2)
You need to configure the format of the Sales Total measure.
Which value should you use for the FormatString property?
A. $#,##0.00;($#,##0.00)
B. #,##0.00;-#,##0.00
C. Currency
D. A custom-entered value
Answer: C
Q4. - (Topic 4)
You maintain a multidimensional Business Intelligence Semantic Model (BISM) that was developed with default settings.
The model has one cube and the cube has one measure group. The measure group is based on a very large fact table and is partitioned by month. The fact table is incrementally loaded each day with approximately 800,000 new rows.
You need to ensure that all rows are available in the cube while minimizing the processing time.
Which processing option should you use?
A. Process Index
B. Process Data
C. Process Add
D. Process Default
E. Process Clear
F. Process Full
Answer: C
Q5. - (Topic 4)
You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1.
You need to develop the report to meet the requirement.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. For the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.
B. Configure Textbox1 to drill through to rerun the report to toggle the display of Table1.
C. For the properties of Table1, configure the Display can be toggled by this report item option to use Table1
D. Add a parameter to the report so users can choose the display state of Table1.
Answer: A
Q6. - (Topic 4)
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 Maximum Sales Price
The Maximum Sales Price column is available only in the Products table.
You add a column named Is Overpriced to the Invoice Line Items table. The Is Overpriced column must store a value of TRUE if the value of the Unit Sales Price is greater than the value of the Maximum Sales Price. Otherwise, a value of FALSE must be stored.
You need to define the Data Analysis Expressions (DAX) expression for the Is Overpriced column.
Which DAX formula should you use? (Each answer represents a complete solution. Choose all that apply.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: A,C
Q7. - (Topic 4)
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 statement in a trace by using SQL Server Profiler.
Which event class should you use?
A. Get Data From Aggregation
B. Query Subcube
C. Query Begin
D. Progress Report Begin
E. Calculate Non Empty Begin
F. Execute MDX Script Begin
Answer: C
Q8. - (Topic 1)
After you deploy the RegionalSales report, users report that they cannot see product data when they receive the reports by email.
You need to ensure that the sales department managers can see all of the data.
In the report, you update the Hidden property of each group.
What should you do next?
A. In When the report is initially run, select Show or hide based on an expression. Set the expression to = (GlobalslRenderFormat.IsIntcractivc)
B. In When the report is initially run, select Show.
C. In When the report is initially run, select Show or hide based on an expression. Set the expression to =NOT (GlobalslRenderFormat.IsInteractive).
D. In When the report is initially run, select Hide.
Answer: D
Q9. - (Topic 3)
You need to create a measure for DOD sales.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Use the Data Analysis Expressions (DAX) PARALLELPERIOD ( ) function.
B. Create a date dimension by using the Dimension wizard with a date template.
C. Specify a date table by using a Mark the Date table.
D. Use the Multidimensional Expressions (MDX) PARALLELPERIOD( ) function.
Answer: A,C
Q10. - (Topic 4)
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a Microsoft Azure SQL Database 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. Indicator
B. Data Bar
C. Image
D. Sparkline
E. Gauge
Answer: A,E