Which of the following is the best action for the administrator to take?

A database administrator manages a database server that is running low on disk space. A lot of backup files are stored on the server’s disks.

Which of the following is the best action for the administrator to take?
A . Move all the backup files to external disks.
B . Delete all the backup files containing data that is rated as classified.
C . Delete all the backup files that are not required by the backup retention policy.
D . Delete all the backup files except for the most recent one.

View Answer

Answer: C

Explanation:

The best action for the administrator to take is to delete all the backup files that are not required by the backup retention policy. This will free up disk space on the server and also comply with the best practices for data backup and recovery. The backup retention policy defines how long the backup files should be kept and when they should be deleted or archived. The other options are either risky, inefficient, or impractical. For example, moving all the backup files to external disks would require additional hardware and time, deleting all the backup files containing data that is rated as classified would compromise data security and compliance, and deleting all the backup files except for the most recent one would limit the recovery options in case of a disaster.

Reference: CompTIA DataSys+ Course Outline, Domain 5.0 Business Continuity, Objective 5.2 Given a scenario, implement backup and restoration of database management systems.