MySQL 8.0 Database Administrator — Question 24

Examine this command, which executes successfully:
shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb
Which two statements are true? (Choose two.)

Answer options

• A. It executes flush tables with read lock.
• B. It enforces consistent backups for all storage engines.
• C. The backup created is a consistent data dump.
• D. This option uses the READ COMMITTED transaction isolation mode.
• E. It is a cold backup.

Correct answer: A, D

Explanation

The correct answers are A and D. Option A is true because the command uses a read lock to ensure a consistent snapshot, while option D is correct as it operates under the READ COMMITTED isolation level. Options B, C, and E are incorrect because the command does not enforce consistent backups across all storage engines, does not guarantee a consistent data dump without additional measures, and is not a cold backup since it is taken while the database is running.