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

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.Image
• B.Indicator
• C.Sparkline
• D.Data Bar
• E.Gauge

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 (KPD 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?

• A.a Data Bar
• B.an Indicator
• C.a Gauge that uses the Linear type
• D.a Gauge that uses the Radial type
• E.a Sparkline

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.
You need to hide the tables and columns.
What should you do?

• A.In the Properties window for the applicable tables and columns, set the Visible property to True
• B.Right-click the applicable tables and columns and select the Hide from Client Tools option.
• C.In the Properties window for the applicable tables and columns, set the Enabled property to False
• D.Right-click the applicable tables and columns and select the Hide option.

HOTSPOT
A company maintains separate environments for test, production, and quality assurance. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.
You create an SSIS project to perform a weekly refresh of the company's data warehouse and cubes. The project has three packages.
You need to configure the project to ensure so that the test and production teams can run each package without manually adding server-specific information.
Which program should you use?
To answer, select the appropriate program in the answer area.

正解：

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.
You create a measure group named Exchange Rate that consists of measures pertaining to currency exchange rates. One of the measures in this group is named Average Rate and it will be used to report the average currency exchange rate over time.
Currently the AggregationFunction property for the Average Rate measure is set to Sum.
You need to ensure that Average Rate measure reports the average of the currency exchange rate over time.
Which value should you select for the AggregationFunction property for the Average Rate measure? To answer, select the appropriate setting in the answer area.

正解：