Database Fundamentals — Question 76

You have a database that contains 10 terabytes of data. You need to back up the database every two hours.
Which type of backup should you use?

Answer options

• A. archive
• B. incremental
• C. partial
• D. full

Correct answer: C

Explanation

A partial backup is suitable in this scenario because it allows you to back up portions of the database rather than the entire dataset, which is efficient for a large database. A full backup would take too long and consume excessive resources, while incremental backups only save changes since the last backup, making them unsuitable for the requirement of backing up every two hours.