You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

• A.ibbackupfiles
• B.*.CSMfiles
• C.*.sdifiles
• D.*.ibdfiles
• E.ib_logfile*files

Comment: *

Name: *

Email: *

Verification: *

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.VERIFY_IDENTITY
• B.VERIFY_CA
• C.PREFERRED
• D.REQUIRED

Comment: *

Name: *

Email: *

Verification: *

Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

• A.The transactions table was created with innodb_file_per_table=OFF.
• B.Truncating the sales and leads table will free up disk space.
• C.Executing ALTER TABLE transactions will enable you to free up disk space.
• D.Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
• E.Truncating the transactions table will free up the most disk space.

Comment: *

Name: *

Email: *

Verification: *

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

• A.server configuration rollback
• B.performance metrics
• C.server runtime configuration
• D.view definitions
• E.InnoDB buffer pool LRU management data
• F.access control lists
• G.stored procedure definitions
• H.table definitions

Comment: *

Name: *

Email: *

Verification: *

Examine Joe's account:
CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'
GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'
All existing connections for joe are killed.
Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

• A.ALTER USER 'joe'@'%' PASSWORD HISTORY 0
• B.REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'
• C.ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE
• D.ALTER USER 'joe'@'%' ACCOUNT LOCK
• E.REVOKE USAGE ON *.* FROM 'joe'@'%'
• F.ALTER USER 'joe'@'%' SET password='*invalid*'

Comment: *

Name: *

Email: *

Verification: *