Snapshot Interview Questions

1. Which of the following statement is false?

A. In synchronous mirroring, write acknowledgement is sent once both the mirrors are written

B. In synchronous mirroring, write response time can be slow as it depends on the slowest disk of the mirror

C. Write response to an application is faster for asynchronous mirroring as compared to synchronous mirroring

D. None of the mentioned

Correct Answer is : None of the mentioned

2. Which of the following statement is false for snapshots?

A. Snapshot technique can use copy-on-write mechanism

B. Uses point-in-time to ensure data integrity

C. Snapshot copy must be on a different device

D. None of the mentioned

Correct Answer is : Snapshot copy must be on a different device

3. Which of the following is true for CDP – Continuous Data Protection?

A. It backs up every change to the data

B. Can restore to any time in the past

C. Both the mentioned

D. None of the mentioned

Correct Answer is : Can restore to any time in the past

4. Which of the following is false for D2D2T – Disk to Disk to Tape backup?

A. Backup and Restore is faster

B. Tape is used for archiving and/or long term storage

C. Cheaper disks are generally used for backup device

D. None of the mentioned

Correct Answer is : None of the mentioned

5. Which of the following is false for NDMP protocol?

A. NDMP uses TCP/IP

B. NDMP allows selective file recovery

C. NDMP allows asynchronous event notification

D. None of the mentioned

Correct Answer is : None of the mentioned

6. Which of the syntax is used for creating database snapshot in SQL Server ?

A. CREATE Snapshot database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' )

B. CREATE DATABASESNAPSHOT database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' )

C. CREATE DATABASE database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' )

D. None of the mentioned

Correct Answer is : CREATE DATABASE database_snapshot_name ON ( NAME = logical_file_name, FILENAME = 'os_file_name' )

7. Point out the correct statement :

A. Snapshots can be used in conjunction with database mirroring for reporting purposes

B. A snapshot is write-only, static view of a database

C. A snapshot is read-only, dynamic view of a database

D. None of the mentioned

Correct Answer is : Snapshots can be used in conjunction with database mirroring for reporting purposes

8. Which of the following scenario prefers not to use database snapshots ?

A. Database Snapshots should be seen as high availability option

B. Database Snapshots should not be seen as an alternative to regular backups of your data

C. Snapshots can be created very quickly

D. All of the mentioned

Correct Answer is : Database Snapshots should not be seen as an alternative to regular backups of your data

9. Point out the wrong statement :

A. You cannot used SQL Server Management Studio for creating a database snapshots

B. Snapshots have to be created using T-SQL

C. All recovery models support database snapshot

D. A database can have one and only one snapshot

Correct Answer is : A database can have one and only one snapshot

10. To revert the database, use the following Transact-SQL statement:

A. RESTORE Snapshot FROM DATABASE_SNAPSHOT =

B. RESTORE DATABASE FROM DATABASE_SNAPSHOT =

C. REST DATABASE FROM DATABASE_SNAPSHOT =

D. None of the mentioned

Correct Answer is : RESTORE DATABASE FROM DATABASE_SNAPSHOT =

11. Which of the following message comes when you try to update or delete the data snapshot?

A. Row Deletion

B. The row was committed

C. Row has been updated

D. Failed to update the database

Correct Answer is : Row has been updated

12. Syntax for creating database snapshot in SQL Server is :

A. DROP DATABASE [snapshottest];

B. DELETE DATABASE [snapshottest];

C. DROP Snapshot [snapshottest];

D. None of the mentioned

Correct Answer is : DROP DATABASE [snapshottest];

13. .What should be done to check to see if data still exists in Snapshot ?

A. Run Delete on Database Snapshot

B. Run Update on Database Snapshot

C. Run Select on Database Snapshot

D. Run Insert on Database Snapshot

Correct Answer is : Run Select on Database Snapshot

Snapshot interview questions