Mirroring Interview Questions

Mirroring interview questions

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

Total Questions: 8

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

3. Database mirroring operates in how many modes ?

A. 2

B. 3

C. 4

D. 5

Correct Answer is : 3

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

5. Which of the following modes writes the data on the principal and mirror databases synchronously ?

A. High safety with automatic cluster

B. High safety

C. High safety with automatic failover

D. High performance

Correct Answer is : High safety with automatic cluster

6. The high performance mode is only available in the __________ edition of SQL Server.

A. Enterprise

B. Express

C. Compact

D. None of the mentioned

Correct Answer is : Enterprise

7. Which of the following is upgrade step to database mirroring ?

A. Switch to high performance (sync)

B. Perform a rolling upgrade

C. Switch back to high performance (sync)

D. None of the mentioned

Correct Answer is : Perform a rolling upgrade

8. Which of the following pair of technology is supported in SQL Server ?

A. Mirroring and Replication

B. Mirroring and Clustering

C. Mirroring and Log Shipping

D. All of the mentioned

Correct Answer is : All of the mentioned

Mirroring interview questions