Free Microsoft 70-465 Exam Dumps Questions & Answers

You are the administrator for a SQL Server 2014 instance that stores the data for an online transaction processing sales system.
The company takes full backups every week; differential backups on the days with no full backups; and hourly transaction backups. These backups are stored on a backup server in the company's data center.
Every week, the company places the full backup on a tape and sends it to a third-party backup storage system.
The company is worried that a disaster might occur that could destroy their computer center and cause them to lose orders.
You need to determine the best method for providing the smallest amount of data loss and downtime without leasing or purchasing additional physical locations.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

• A.  Set up SQL Server Always On by using a SQL Server on a Windows Azure Virtual Machine.
• B.  Use the Microsoft SQL Server Backup to Microsoft Windows Azure Tool to direct all backups to a different geographical location.
• C.  Set up SQL Server Always On with a SQL Azure database as a replica.
• D.  Put the differential backup on tape and send it to the third-party backup storage system.

You are building a stored procedure for a Windows Azure SQL Database. The procedure will add multiple rows to a table.
You need to design the stored procedure to meet the following requirements:
If any of the new rows violates a table constraint, then no further additions must be attempted and all changes made by the stored procedure must be discarded.
If any errors occur, a row must be added to an audit table, and the original error must be returned to the caller of the stored procedure.
What should you include in the design?

• A.  An explicit transaction that has error handling enabled
• B.  An implicit transaction that has XACT.ABORT enabled
• C.  An explicit transaction that has XACT_ABORT disabled
• D.  An implicit transaction that has error handling enabled

DRAG DROP
You plan to deploy SQL Server 2012.
You are designing two stored procedures named USP_1 and USP_2 that have the following requirements:
- Prevent data read by USP_1 from being modified by other active processes. - Prevent USP_2 from performing dirty reads.
You need to recommend the isolation level for each stored procedure. The solution must maximize concurrency.
Which isolation levels should you recommend?
To answer, drag the appropriate isolation level to the correct stored procedure in the answer area.

Correct Answer:

You need to recommend a solution to minimize the amount of time it takes to execute USP_2.
What should you recommend?

• A.  A database snapshot
• B.  A temporary table
• C.  A table variable
• D.  Snapshot isolation

You plan to create a database.
The database will be used by a Microsoft .NET application for a special event that will last
for two days.
During the event, data must be highly available.
After the event, the database will be deleted.
You need to recommend a solution to implement the database while minimizing costs. The
solution must not affect any existing applications. What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.  SQL Server 2014 Express with Advanced Services
• B.  SQL Server 2014 Enterprise
• C.  SQL Server 2014 Standard
• D.  SQL Azure