Try Microsoft : 70-460 valid & accurate questions and answers

You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
- Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A. Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
• B. Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.
• C. Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.
• D. Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.

You are creating a new report in SQL Server Report Builder. You add a Windows Azure SQL Database data source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following table.

The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Country field on the rows and a grouping of the Year field on the columns.
You need to add the categories on the rows of the matrix.
Which Row Group option should you select when you add the group?

• A. Child Group
• B. Adjacent Below
• C. Parent Group
• D. Adjacent Above

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. Gauge
• E. Data Bar

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. Set the Type property of the partition's measure group to Forecast.
• B. Implement the local measure group as a linked measure group.
• C. Implement the linked measure group as a local measure group.
• D. Set the StorageMode property of the linked measure group to Rolap.

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

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