Examine this statement and output:

You must try to reduce query execution time.
Which two queries should you focus on? (Choose two.)

• A.QN = 4
• B.QN = 3
• C.QN = 1
• D.QN = 5
• E.QN = 2

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 features of MySQL Enterprise Firewall? (Choose two.)

• A.automatic locking of user accounts who break your firewall
• B.modifying SQL statement dynamically with substitutions
• C.blocking of potential threats by configuring pre-approved whitelists
• D.recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
• E.provides stateless firewall access to TCP/3306

Comment: *

Name: *

Email: *

Verification: *

You plan to take daily full backups, which include the ndbinfoand sys (internal) databases.
Which command will back up the databases in parallel?

• A.mysqldump --single-transaction > full-backup-$(date +%Y%m%d).sql
• B.mysqlpump --include-databases=% > full-backup-$(date +%Y%m$d).sql
• C.mysqlpump --all-databases > full-backup-$(date +%Y%m%d).sql
• D.mysqldump --all-databases > full_backup-$(date +%Y%m%d).sql

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

• A.It supports all indexes transparently.
• B.It supports only non-blob datatypes.
• C.It does not support the transportable tablespaces feature.
• D.It decrypts data for use in memory.
• E.It enforces encryption from disk to memory and over network transmission.

Comment: *

Name: *

Email: *

Verification: *