MySQL 8.0 Database Administrator — Question 136

Which two are true about differences between logical and physical upgrades of MySQL databases? (Choose two.)

Answer options

• A. Post-upgrade table storage requirements after logical upgrades are usually smaller than that after physical upgrades.
• B. Physical upgrades are performed for current instances on bare metal deployments, whereas logical upgrades are used for virtual machines or containerized instances.
• C. Logical upgrades are much faster because they do not require restarting the mysqld process.
• D. Post-upgrade table storage requirements after physical upgrades are usually smaller than that after logical upgrades.
• E. Physical upgrades are much faster because they do not require restarting the mysqld process.
• F. Physical upgrades leave data in place, whereas logical upgrades require data to be restored from mysqldump-type backups taken before the upgrades.

Correct answer: C, F

Explanation

Answer C is correct because logical upgrades do not involve restarting the mysqld process, making them quicker. Answer F is also correct as physical upgrades maintain the existing data, whereas logical upgrades require restoring data from backups. The other options either provide incorrect comparisons or misrepresent the upgrade processes.