Online Access Free 70-465 Practice Test

You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Azure.
Which method should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

• A.Generate scripts to create all of the all database objects and all of the data, and then execute the scripts by using SQL Azure.
• B.Extract a data-tier application, and then import the application.
• C.Back up the database, and then restore the database.
• D.Create a SQL Server Integration Services (SSIS) package, and then run the package.

DRAG DROP
You define a table by using the following statement.

The Teachers table contains one million records. A sample record of the XML data output is as follows:

You plan to create queries against the table based on grade.
You need to recommend which indexes should be applied to the XML fields. The solution must meet the following requirements:
- Reduce the amount of time required to query the table based on grade.
- Minimize the size of the index.
What should you recommend? To answer, drag the appropriate index types to the correct fields. Each index type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Correct Answer:

DRAG DROP
You need to recommend a backup process for data warehouse database. The solution must meet the following requirements:
- Ensure that if a hardware failure occurs, you can bring the database online without
losing more than 24 hours of transactions. - Minimize the amount of administrative effort required to restore any lost data. - Minimize the space used by transaction logs.
What should you include in the recommendation?
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 need to recommend a solution to minimize the amount of time it takes to execute USP_1.
With what should you recommend replacing Table1?

• A.A temporary table
• B.A function
• C.A table variable
• D.A view

You need to implement changes to the system to reduce contention and improve performance of the SalesOrderDetail table.
Which three actions should you perform? Each correct answer presents part of the solution. Choose three.

• A.ALTER DATABASE [ProdDB] SET ALLOW_SNAPSHOT_ISOLATION ON
• B.Use (TABLOCK) hints in the report queries
• C.Use (SNAPSHOT] hints in the report queries
• D.SET TRANSACTION ISOLATION LEVEL SNAPSHOT
• E.ALTER DATABASE [ProdDB] SET READ_COMMITTED_SNAPSHOT ON
• F.Use (SNAPSHOT] hints in the update statements
• G.SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
• H.ALTER DATABASE [ProdDB] SET READ_COMMITTED_SNAPSHOT OFF