MS SQL Server - 65 - Backup MCQ

65 – Backup MCQ

1 / 25

1. What is a Full Database Backup in SQL Server?

A backup of individual database files

A backup of a specific filegroup

A backup of the entire database including all data and objects

A backup of only the transaction log

2 / 25

2. What is the primary purpose of a Full Database Backup?

To backup only specific tables within a database

To provide a point-in-time recovery option

To back up the entire database for disaster recovery

To create a copy of the transaction log

3 / 25

3. In SQL Server, what is a Differential Backup?

A backup of a specific file or filegroup

A backup of only the transaction log

A backup of the entire database including all data and objects

A backup of changes made since the last full or differential backup

4 / 25

4. What is the primary advantage of using Differential Backups?

Smaller backup file size

Point-in-time recovery options

Automatic transaction log backups

Faster backup and restore operations

5 / 25

5. What does a Transaction Log Backup in SQL Server capture?

Changes made since the last full or differential backup

File-level changes within a database

System-level configuration settings

All data and objects in the database

6 / 25

6. What is the primary purpose of a Transaction Log Backup?

To create a copy of the transaction log

To back up the entire database for disaster recovery

To back up specific tables within a database

To provide point-in-time recovery options

7 / 25

7. Which SQL Server backup type is crucial for maintaining a complete transaction log chain for point-in-time recovery?

Transaction Log Backup

File or Filegroup Backup

Differential Backup

Full Database Backup

8 / 25

8. In SQL Server, what is a File or Filegroup Backup?

A backup of a specific file or filegroup within the database

A backup of individual database files

A backup of only the transaction log

A backup of the entire database including all data and objects

9 / 25

9. What is the primary advantage of using File or Filegroup Backups?

Faster backup and restore operations

Smaller backup file size

Point-in-time recovery options

Automatic transaction log backups

10 / 25

10. Which SQL Server backup type is used to back up specific portions of a database, such as individual files or filegroups?

Differential Backup

Transaction Log Backup

File or Filegroup Backup

Full Database Backup

11 / 25

11. What is the purpose of a Full Database Backup in SQL Server?

To back up the entire database including all data and objects

To back up only specific tables within a database

To provide point-in-time recovery options

To create a copy of the transaction log

12 / 25

12. Which backup type captures all changes made to the database since the last Full Database Backup or Differential Backup?

Full Database Backup

File or Filegroup Backup

Differential Backup

Transaction Log Backup

13 / 25

13. What is the primary use of a Differential Backup in SQL Server?

To back up the entire database including all data and objects

To capture changes made since the last full or differential backup

To back up only specific tables within a database

To create a copy of the transaction log

14 / 25

14. Which SQL Server backup type is often used to create a baseline for other backups?

Transaction Log Backup

File or Filegroup Backup

Full Database Backup

Differential Backup

15 / 25

15. In SQL Server, what is a Transaction Log Backup?

A backup of a specific file or filegroup

A backup of changes made since the last full or differential backup

A backup of individual database files

A backup of the entire database including all data and objects

16 / 25

16. What is the primary purpose of a Transaction Log Backup in SQL Server?

To create a copy of the transaction log

To back up the entire database for disaster recovery

To capture changes made since the last full or differential backup

To back up specific tables within a database

17 / 25

17. Which SQL Server backup type captures all changes made to the database since the last Transaction Log Backup or Full Database Backup?

File or Filegroup Backup

Differential Backup

Transaction Log Backup

Full Database Backup

18 / 25

18. In SQL Server, what is the primary purpose of a File or Filegroup Backup?

To back up a specific file or filegroup within the database

To create a copy of the transaction log

To back up specific tables within a database

To capture changes made since the last full or differential backup

19 / 25

19. What is the primary advantage of using Transaction Log Backups in SQL Server?

Automatic database schema backups

Faster backup and restore operations

Point-in-time recovery options

Smaller backup file size

20 / 25

20. Which SQL Server backup type is essential for point-in-time recovery, allowing you to restore a database to a specific moment in time?

File or Filegroup Backup

Differential Backup

Full Database Backup

Transaction Log Backup

21 / 25

21. What is the purpose of a File or Filegroup Backup in SQL Server?

To back up specific tables within a database

To create a copy of the transaction log

To capture changes made since the last full or differential backup

To back up a specific file or filegroup within the database

22 / 25

22. Which SQL Server backup type is typically used for capturing changes made since the last full or differential backup?

File or Filegroup Backup

Full Database Backup

Transaction Log Backup

Differential Backup

23 / 25

23. What is the primary use of Transaction Log Backups in SQL Server?

To back up specific tables within a database

To create a copy of the transaction log

To provide point-in-time recovery options

To back up the entire database including all data and objects

24 / 25

24. Which SQL Server backup type is suitable for disaster recovery and restoring a database to its latest state?

Full Database Backup

Differential Backup

File or Filegroup Backup

Transaction Log Backup

25 / 25

25. What is the primary advantage of using Differential Backups in SQL Server?

Point-in-time recovery options

Faster backup and restore operations

Automatic transaction log backups

Smaller backup file size

Your score is

MS SQL Server – 65 – Backup MCQ