MySQL 8.0 Database Administrator — Question 34

You have a MySQL system with 500 GB of data that needs frequent backups.
You use a mix of MyISAM and InnoDB storage engines for your data.
Examine your backup requirement:
The MySQL system being backed up can never be unavailable or locked to the client applications.
The recovery from the backup must work on any system.
Only 1 hour of data can be lost on recovery of the backup.
Which option fulfills all backup requirements?

Answer options

• A. Take a physical backup of the MySQL system.
• B. Use the Clone Plugin to copy the data to another MySQL system.
• C. Take a logical backup of the MySQL system.
• D. Take your backup from a slave of the MySQL system.

Correct answer: C

Explanation

The correct answer is C, as a logical backup allows for consistent data extraction without locking the database, ensuring availability for client applications. Options A and B do not guarantee that the database remains accessible during the backup process, while option D does not meet the requirement of recoverability on any system.