Online Access Free 070-470 Exam Questions

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

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

HOTSPOT
You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on the results of a currency exchange SOAP web service
call.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.

Correct Answer:

DRAG DROP
You administer a SQL Server Reporting Services (SSRS) infrastructure. Data alerts are provisioned.
You need to monitor the number of report data feed processing events during every automated execution.
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.)

Correct Answer:

You are developing a BI Semantic Model (BISM) that will be used to analyze complex budgeting and forecast data sourced from a financial database. The model will be deployed to a server with 32 GB of RAM.
The source data, located in a SQL Server data warehouse, is currently using 10 terabytes of disk space and is doubling in size every three months. The model will be queried by staff in the accounting department by using Microsoft Excel 2010.
You need to ensure the highest query performance and scalability for the accounting department queries.
Which project type should you choose?

• A.PowerPivot workbook
• B.tabular project that uses the DirectQuery query mode
• C.tabular project that uses the In-Memory query mode
• D.multidimensional project

You are working with a SQL Server Reporting Services (SSRS) instance in native mode. An item role named Developer is present on the server.
The Developer role cannot view and modify report caching parameters.
You need to ensure that the Developer role can view and modify report caching parameters.
Which task should you add to the Developer role?

• A.view data sources
• B.Manage all subscriptions
• C.Manage report history
• D.Manage individual subscriptions