You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server.
Which value of --ssl-mode will do this?

• A.REQUIRED
• B.VERIFY_IDENTITY
• C.PREFERRED
• D.VERIFY_CA

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

• A.Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
• B.Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
• C.TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
• D.MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

Comment: *

Name: *

Email: *

Verification: *

Examine this command, which executes successfully:
cluster.addInstance('<user>@<host>:<port>', {recoveryMethod: 'clone'})
Which three statements are true? (Choose three.)

• A.A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.
• B.InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.
• C.A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.
• D.It is always slower than {recoveryMethod: 'incremental'}.
• E.InnoDB tablespaces outside the datadir are able to be cloned.
• F.The account used to perform this recovery needs the BACKUP_ADMIN privilege.

Comment: *

Name: *

Email: *

Verification: *

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

Which statement is true?

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

Comment: *

Name: *

Email: *

Verification: *

t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?

• A.If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.
• B.If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
• C.If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
• D.mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.

Comment: *

Name: *

Email: *

Verification: *