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

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

Comment: *

Name: *

Email: *

Verification: *

Examine this command and output:

Which two statements are true? (Choose two.)

• A.The lock is at the metadata object level.
• B.The lock is a shared lock.
• C.The lock is an exclusive lock.
• D.The lock is at the table object level.
• E.The lock is a row-level lock.
• F.The lock is an intentional lock.

Comment: *

Name: *

Email: *

Verification: *

You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTERcommand are correct.
Examine the GTID information from both master and slave:

Which statement is true?

• A.Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
• B.Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbbGTIDs in its binary logs.
• C.Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc- cccc-ccccccccccccGTIDs.
• D.Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
• E.Replication will work.

Comment: *

Name: *

Email: *

Verification: *

Which two are use cases of MySQL asynchronous replication? (Choose two.)

• A.MySQL Enterprise Backup will automatically back up from an available slave.
• B.You can scale reads by adding multiple slaves.
• C.You can scale writes by creating a replicated mesh.
• D.It guarantees near real-time replication between a master and a slave.
• E.It allows backup to be done on the slave without impacting the master.

Comment: *

Name: *

Email: *

Verification: *

You plan to install MySQL Server by using the RPM download.
Which two statements are true? (Choose two.)

• A.You can provide the root password interactively.
• B.The MySQL RPM package installation supports deploying multiple MySQL versions on the same host.
• C.MySQL uses the RPM relocatable installation target feature.
• D.The functionality is split among several RPM package files.
• E.You must manually initialize the data directory.
• F.You can find the root password in the error log after the first start.

Comment: *

Name: *

Email: *

Verification: *