70-459 – Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform

QUESTION 1
You need to configure the ProcessUpdateProc stored procedure to stop running in the event of a
failure of one of the UPDATE statements.
How should you modify the ProcessUpdateProc stored procedure?

A. By configuring the SET NOCOUNT to on.
B. By configuring the SET NOEXEC option to on.
C. By configuring the XACT_ABORT option to on.
D. By configuring the XACT_ABORT option to off.

Answer: C

Explanation:

---

QUESTION 2
You need to design a solution to that enables the recovery of the DailyReportsTemp database in
less than one hour in the event of a storage hardware failure. Your solution must minimize costs.
What should you recommend?

A. SQL Server Failover Clustering
B. Peer-to-peer replication
C. Differential backups
D. Log shipping
E. Database snapshots

Answer: D

Explanation:

---

QUESTION 3
You need to recommend a solution to meet the recovery requirements for the Manufacturing
database. Your solution must minimize costs.
What should you recommend?

A. Database snapshots
B. Transaction log backups.
C. Differential backups
D. SQL Server Failover Clustering
E. Peer-to-peer replication

Answer: A

Explanation:

---

QUESTION 4
You need to address the backup issues of the Sales database.
How can you reduce the time it takes to back up the Sales database?

A. By configuring table partitioning.
B. By configuring filegroups.
C. By configure the Resource Governer
D. By configuring Copy-Only backups.

Answer: B

Explanation:

---

Best Microsoft MCTS Certification, Microsoft MCITP Training at certkingdom.com