Question

Point out the wrong statement.

(a) Mirror database is the copy of the database that is typically fully synchronized with the principal database

(b) Redo queue is received transaction log records that are waiting on the disk of a mirror server

(c) Database mirroring provides less redundancy of the data

(d) All of the mentioned

I had been asked this question in my homework.

Enquiry is from Database Mirroring in section Enterprise Data Management of SQL Server

Answer 1

Right choice is (c) Database mirroring provides less redundancy of the data

To explain I would say: Database mirroring provides complete or almost complete redundancy of the data depending on whether the operating mode is high-safety or high-performance.