Database Backup and Recovery Basics

Submit

2. What must occur before you can perform transaction log backups in SQL Server?

Database must be in Simple recovery mode

Database must be in Full or Bulk-logged recovery mode

All tables must have clustered indexes

Replication must be enabled

3. Which backup strategy minimizes storage requirements for frequent backups?

Full backups only

Full plus incremental backups

Full plus differential backups

Transaction log backups only

Submit

5. What is the primary purpose of testing backup and recovery procedures?

To verify backups are valid and recovery works as expected

To document backup schedules

To reduce RTO values

To compress backup files

6. Which component stores database changes in SQL Server for recovery purposes?

Tempdb

Transaction log

Backup file

System catalog

Submit

8. What is the main benefit of backup compression?

Faster backup operations

Reduced storage requirements and faster transfer

Improved database performance

Automatic encryption of backup files

9. Which strategy involves maintaining a synchronized copy of the database on a different server?

Backup compression

Database replication

Log shipping

Archival backup

10. What is the primary risk of using the SIMPLE recovery model?

Slower backup operations

Large transaction log files

Cannot perform point-in-time restore

Requires more backup storage

11. What is the primary purpose of a full database backup?

Create a complete copy of the entire database at a specific point in time

Back up only tables modified since the last backup

Restore individual rows without affecting other data

Monitor database activity in real time

12. Transaction logs are essential for which type of recovery?

Crash recovery only

Point-in-time recovery

Media failure recovery

All of the above

13. What does RPO measure in a backup strategy?

Time needed to restore from backup

Maximum acceptable data loss in terms of time

Physical recovery point offset

Replication process overhead

14. What does RTO stand for in disaster recovery planning?

Recovery Time Objective

Replication Transfer Option

Redundant Transaction Output

Remote Topology Optimization

Submit

16. Which recovery model in SQL Server allows point-in-time recovery?

Simple

Bulk-logged

Full

17. What is the main advantage of incremental backups over differential backups?

They back up all changes since the last full backup

They consume less storage by backing up only changes since the last backup

They provide faster recovery times

They require fewer backup media

18. In SQL Server, what does the SIMPLE recovery model allow?

Point-in-time restore to any moment

Restore only to the last full or differential backup

Automatic transaction log truncation

Both b and c

19. Which backup type captures only changes made since the last full backup?

Full backup

Differential backup

Incremental backup

Snapshot backup

General Databases Intermediate Backup and Recovery Basics Quiz

1. A _____ backup includes all database changes since the last incremental backup.

2.

What first name or nickname would you like us to use?

2. What must occur before you can perform transaction log backups in SQL Server?

3. Which backup strategy minimizes storage requirements for frequent backups?

4. A _____ backup includes all database changes since the last full backup.

5. What is the primary purpose of testing backup and recovery procedures?

6. Which component stores database changes in SQL Server for recovery purposes?

7. A _____ strategy involves maintaining one or more standby databases that receive transaction logs.

8. What is the main benefit of backup compression?

9. Which strategy involves maintaining a synchronized copy of the database on a different server?

10. What is the primary risk of using the SIMPLE recovery model?

11. What is the primary purpose of a full database backup?

12. Transaction logs are essential for which type of recovery?

13. What does RPO measure in a backup strategy?

14. What does RTO stand for in disaster recovery planning?

15. A _____ is a read-only copy of a database at a specific moment in time.

16. Which recovery model in SQL Server allows point-in-time recovery?

17. What is the main advantage of incremental backups over differential backups?

18. In SQL Server, what does the SIMPLE recovery model allow?

19. Which backup type captures only changes made since the last full backup?