070-470 試験問題を無料オンラインアクセス

You are designing a reporting solution that uses SQL Server Reporting Services (SSRS) in SharePoint integrated mode.
The reporting solution must meet the following requirements:
---
Allow report writers to reuse content between different reports. Allow report writers to modify reusable content in SharePoint. Retain version history for report content.
You need to choose a reporting method that meets the requirements.
What should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.linked reports
• B.drillthrough reports
• C.report parts
• D.subreports

HOTSPOT
A sales cube contains two years of data.
The sales team must see year-over-year (YOY) and month-over-month (MOM) sales metrics.
You need to modify the cube to support the sales team's requirements.
Which Business Intelligence Wizard enhancements should you use? (To answer, configure the appropriate option or options in the dialog box in the answer area.)

正解：

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

You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with which users can filter the report by a single date. The parameter value cannot be directly used to filter the Multidimensional Expressions (MDX) query for the dataset.
You need to ensure that the report displays data filtered by the user-entered value. You must achieve this goal by using the least amount of development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Edit the dataset query parameter. Change the Value property of the report parameter to an expression that uses the same format as the date dimension member key value.
• B.Edit the dataset query parameter. Change the Name property of the dataset query parameter so that it points to a name value for each date dimension member.
• C.Change the dataset query to Transact-SQL (T-SQL). Use the OPENROWSET function to query the cube. Output the cube results to the T-SQL query and use a Convert function to change the report parameter value into the same format as the date dimension member.
• D.Edit the dataset query parameter. Create a subcube subquery that uses the StrToSet MDX function and accepts the report parameter value.

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.
Table1 is initially visible but the user must be able to choose when to hide it.
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.Add a parameter to the report so users can choose the display state of Table1.
• C.Configure Textbox1 to drill through to rerun the report to toggle the display of Table1.
• D.For the properties of Table1, configure the Display can be toggled by this report item option to use Table1.