Microsoft : 70-460 Questions & Answers

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

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be
used in the definition of a hierarchy. The City column exists in the Geography table that is
related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

• A. Option E
• B. Option B
• C. Option D
• D. Option A
• E. Option C
• F. Option F

DRAG DROP
You have a business intelligence (BI) infrastructure.
You create a SQL Server Integration Services (SSIS) project that contains the packages for the BI infrastructure.
You need to automate the deployment of the SSIS project. The solution must ensure that the deployment can occur as part of an unattended Transact-SQL script.
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.

You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
- Report utility functions and business logic in code - Standardized report formatting properties such as fonts and colors for report branding
Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset.
• B. Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report.
• C. Store the formatting properties and code in database objects. Use stored procedures to populate a default value for report parameters and map each parameter to a corresponding formatting property.
• D. Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template.

You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands:
High Yield
Medium Yield
Low Yield
You add a table to the report. Then you define two columns based on the fields named VineyardName and YTDGrapeYield.
You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape yield values.
What should you do?

• A. Use an expression for the Style property of the vineyard text box.
• B. Add an indicator to the table.
• C. Use an expression for the Font property of the vineyard text box.
• D. Use an expression for the Color property of the vineyard text box.
• E. Use an expression for the TextDecoration property of the vineyard text box.