Data Backup Solutions Interview Questions

Data Backup Solutions interview questions

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

Total Questions: 5

1. Backing up your SQL Server database is essential for _______ your data.

A. protecting

B. preventing

C. replication

D. None of the mentioned

Correct Answer is : protecting

2. Point out the correct statement :

A. Using differential backups can save available space

B. Using full backups can save available space

C. Using partial backups can save available space

D. None of the mentioned

Correct Answer is : Using differential backups can save available space

3. How many types of backups are provided by SQL Server ?

A. 5

B. 6

C. 7

D. 8

Correct Answer is : 8

4. Features provided by SQL Server backups include :

A. Wire compression of data for optimal backup and restore time

B. Supports full and transaction log style backups

C. Backup of MS SQL Server databases without interrupting running MS SQL Server services

D. All of the mentioned

Correct Answer is : All of the mentioned

5. Point out the wrong statement :

A. SQL Server 2003 Enterprise and later versions support compressing backups

B. SQL Server 2008 Enterprise and later versions support compressing backups

C. SQL Server 2000 Enterprise and later versions support compressing backups

D. All of the mentioned

Correct Answer is : SQL Server 2008 Enterprise and later versions support compressing backups

Data Backup Solutions interview questions