MySQL 8.0 Database Administrator — Question 14

Examine this list of MySQL data directory binary logs:
binlog.000001
binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

Answer options

• A. All databases are backed up to the output file.
• B. All non-active binary logs are removed from the master.
• C. All binary logs are deleted from the master.
• D. All binary logs are backed up and then deleted.
• E. All databases, excluding master metadata, are backed up to the output file.
• F. All details regarding deleted logs and master metadata are captured in the output file.

Correct answer: C, E

Explanation

The correct answer C is accurate because the --delete-master-logs option causes all binary logs to be removed after the dump. Option E is also correct as it indicates that only the databases are backed up without the master metadata. Options A, B, D, and F are incorrect as they either misrepresent the backup process or do not reflect the functionality of the command used.