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

The correct answer is B. It creates a logical backup of all metadata, but contains no table data. https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html

Backup and Recovery

Question

You execute this command:

shell> mysqlpump --exclude-databases=% --users Which statement is true?

Options

AIt creates a logical backup of all MySQL user accounts.
BIt creates a logical backup of all metadata, but contains no table data.
CIt returns an error because the mysqldump command should have been used.
DIt creates a logical backup of only the users database.

How the community answered

(28 responses)

A
4% (1)
B
75% (21)
C
7% (2)
D
14% (4)

Explanation

https://docs.oracle.com/cd/E17952_01/mysql-5.7-en/mysqlpump.html

Topics

#mysqlpump#logical backup#--exclude-databases#--users option

Community Discussion

No community discussion yet for this question.

Full 1Z0-908 Practice