Pass with 070-470 Practice Materials 100% for sure

You are designing a SQL Server Reporting Services (SSRS) report for a bank. The bank has Automated Teller Machines (ATMs) in several regions. ATM operational data is stored in a SQL Azure database.
The report must use a map to display the location and status of the ATMs as shown in the following exhibit. (Click the Exhibit button.)

You need to ensure that the report displays only a user selected map region.
Which source of spatial data should you use for the map?

• A. ESRI shape file
• B. SQL Server spatial query
• C. Bing Maps layer
• D. Map gallery

You need to identify changes in the financial database.
What should you do?

• A. Add SQL Server mirroring to each table.
• B. Enable change data capture on each table.
• C. Perform a full extract of each table.
• D. Create an AlwaysOn Availability Group that includes all the tables.
• E. Add SQL Server log shipping to each table.

You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a data model.
Which role permission should you use?

• A. Browser
• B. Read
• C. select
• D. Explorer
• E. Process
• F. Administrator

You are modifying a star schema data mart that feeds order data from a SQL Azure 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. Combine the distinct flag/indicator combinations into a single dimension.
• C. Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.
• D. Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.

You are developing a SQL Server Reporting Services (SSRS) report. The report includes a dataset with fields named Year, MonthNumber, and RegCount. The report includes a table that displays the number of recorded registration occurrences per year, as shown in the following diagram.

You need to modify the table to include a graphical item displaying the monthly registration trend to the right of the Reg Count column.
What should you do?

• A. Add an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then select the MonthNumber field for Value.
• B. Add a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Category Groups.
• C. Add a text box to a new column on the right of the Reg Count column. Then use a Go to report action to link to a separate report showing the monthly trend.
• D. Add an Indicator item to a new column on the right of the Reg Count column. Select the Directional Indicator Type and then assign the MonthNumber field to the Start property.
• E. Add a Sparkline item to a new column on the right of the Reg Count column. Then select the RegCount field for Values and the MonthNumber field for Series Groups.