1. Which of the following statement is false?
Correct Answer is : None of the mentioned
2. Which of the following statement is false for snapshots?
Correct Answer is : Snapshot copy must be on a different device
3. Which of the following is true for CDP – Continuous Data Protection?
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?
Correct Answer is : None of the mentioned
5. Which of the following is false for NDMP protocol?
Correct Answer is : None of the mentioned
6. Which of the syntax is used for creating database snapshot in SQL Server ?
Correct Answer is : CREATE DATABASE database_snapshot_name
ON
(
NAME = logical_file_name,
FILENAME = 'os_file_name'
)
7. Point out the correct statement :
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 ?
Correct Answer is : Database Snapshots should not be seen as an alternative to regular backups of your data
9. Point out the wrong statement :
Correct Answer is : A database can have one and only one snapshot
10. To revert the database, use the following Transact-SQL statement:
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?
Correct Answer is : Row has been updated
12. Syntax for creating database snapshot in SQL Server is :
Correct Answer is : DROP DATABASE [snapshottest];
13. .What should be done to check to see if data still exists in Snapshot ?
Correct Answer is : Run Select on Database Snapshot