Data Mirror Interview Questions

Data Mirror interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. __________ feature will be removed in a future version of Microsoft SQL Server.

A. Log shipping

B. Database snapshots

C. Database mirroring

D. None of the mentioned

Correct Answer is : Database mirroring

2. Point out the correct statement :

A. Database mirroring is a solution for lowering the availability of a SQL Server database

B. Log shipping is a solution for increasing the availability of a SQL Server database

C. Mirroring is implemented on a per-database basis

D. All of the mentioned

Correct Answer is : Mirroring is implemented on a per-database basis

3. Which of the following benefit is provided by database mirroring ?

A. Increases data protection

B. Improves the availability of the production database

C. Increases availability of a database

D. All of the mentioned

Correct Answer is : All of the mentioned

4. Database mirroring operates in how many modes ?

A. 2

B. 3

C. 4

D. 5

Correct Answer is : 3

5. 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

Correct Answer is : Database mirroring provides less redundancy of the data

Data Mirror interview questions