MySQL 8.0 Database Administrator — Question 81

Examine this command, which executes successfully:
mysqlpump -–user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)

Answer options

• A. information_schema
• B. world
• C. employee
• D. sys
• E. mysql

Correct answer: A, D

Explanation

The correct answer is A and D because the information_schema and sys databases are system databases that are typically excluded from dumps created by mysqlpump. The other options, world, employee, and mysql, are user-defined or operational databases that are included in the backup.