PrepAway - Latest Free Exam Questions & Answers

Which of the following is TRUE with regards to the use of a Database mirroring strategy?

You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing the use of a Database mirroring strategy.
Which of the following is TRUE with regards to the use of a Database mirroring strategy? (Choose
all that apply.)

PrepAway - Latest Free Exam Questions & Answers

A.
Only user databases can be mirrored.

B.
All databases, including the master, msdb, tempdb, or model databases, can be mirrored.

C.
Database mirroring is supported with cross-database transactions and distributed transactions.

D.
A mirrored database cannot be renamed during a database mirroring session.

Explanation:


Leave a Reply