MySQL 8.0 Database Administrator — Question 41

Which statement is true about cold backups?

Answer options

• A. They are backups taken from snapshots of a running database.
• B. They are backups taken from OS copy commands.
• C. They are good to use if only data structures must be backed up but not log files.
• D. They are good to use when many users are online accessing the database.

Correct answer: A

Explanation

The correct answer is A because cold backups involve creating backups while the database is not running, ensuring data consistency. Option B is incorrect as cold backups do not typically rely on OS copy commands. Option C is wrong because cold backups can include both data structures and log files. Option D is also incorrect since cold backups are not ideal when many users are online.