PrepAway - Latest Free Exam Questions & Answers

Which SQL Server component(s) must be included in the SRDF/S replication to meet this requirement?

You have decided to implement SRDF/S to replicate your Microsoft SQL Server database to a remote site. The database is running in mixed-mode authentication and is comprised of three data files, each in their own file group. One of the requirements of this solution is that the database be restartable at the remote site without losing any data.
Which SQL Server component(s) must be included in the SRDF/S replication to meet this requirement?

PrepAway - Latest Free Exam Questions & Answers

A.
Master, Model, MSDB, and the production database

B.
Production database

C.
Master, Model, TempDB, and the production database

D.
Master, Model, MSDB, TempDB, and the production database


Leave a Reply