MySQL 8.0 Database Administrator — Question 5

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

Answer options

• A. It creates a logical backup of all MySQL user accounts.
• B. It creates a logical backup of all metadata, but contains no table data.
• C. It returns an error because the mysqldump command should have been used.
• D. It creates a logical backup of only the users database.

Correct answer: A

Explanation

The correct answer is A because the mysqlpump command with the --users option is specifically designed to create a backup of all MySQL user accounts. Option B is incorrect because it refers to metadata only and does not acknowledge the focus on user accounts. Option C is wrong as mysqlpump is a valid command for this purpose, and option D is incorrect since the command does not limit the backup to just the users database.