70-465 Designing Database Solutions for Microsoft SQL Server 2012

---

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:

---

QUESTION 5
You need to provide a group of users from the IT and Manufacturing departments the
minimum administrative rights to view database information and server state for the
Manufacturing database on MainDB1.
What should you do?

A. You should configure a Database Role.
B. You should configure a Server Role.
C. You should configure a Shared SQL Server Login.
D. You should configure a Local Security Group.

Answer: B

Explanation:

---

Best Microsoft MCSA: SQL Server 2012,
Microsoft 70-465 Training at certkingdom.com