MySQL 8.0 Database Administrator — Question 6

You plan to take daily full backups, which include the ndbinfo and sys (internal) databases.
Which command will back up the databases in parallel?

Answer options

• A. mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
• B. mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
• C. mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
• D. mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

Correct answer: B

Explanation

The correct answer is B because mysqlpump is designed to perform backups in parallel, which is ideal for efficiently backing up multiple databases. Options A and D utilize mysqldump, which does not support parallel processing for backups, while option C does not specify the inclusion of the specific databases mentioned.