Exam 1z0-908 All QuestionsBrowse all questions from this exam
Question 42

Examine this command, which executes successfully:

mysqlpump -–user=root --password > full_backup.sql

Which two databases will be excluded from this dump? (Choose two.)

    Correct Answer: A, D

    In the context of MySQL, certain system databases are excluded from dumps by default when using the mysqlpump utility. Specifically, the 'information_schema' and 'sys' databases are not included in such dumps. The 'information_schema' contains metadata about the database objects and is not typically included in backups. Similarly, the 'sys' database is a system database providing various system views and functions primarily for performance and monitoring purposes, which is also excluded by default. Therefore, the two databases that will be excluded from this dump are 'information_schema' and 'sys'.

Discussion
ZehirOptions: AD

Mysqlpump does not dump the performance_schema, ndbinfo, or sys schema by default. Mysqlpump does not dump the INFORMATION_SCHEMA schema. https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html#mysqlpump-restrictions

marklvOptions: AD

AD Does not dump performance_schema, ndbinfo, or sys, schema_information