User account baduser@hostname on your MySQL instance has been compromised.
Which two commands stop any new connections using the compromised account? (Choose two.)

• A.ALTER USER baduser@hostname PASSWORD DISABLED;
• B.ALTER USER baduser@hostname MAX_USER_CONNECTIONS 0;
• C.ALTER USER baduser@hostname ACCOUNT LOCK;
• D.ALTER USER baduser@hostname IDENTIFIED WITH mysql_no_login;
• E.ALTER USER baduser@hostname DEFAULT ROLE NONE;

Comment: *

Name: *

Email: *

Verification: *

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

• A.table data
• B.primary indexes
• C.user privileges
• D.InnoDB Data Dictionary
• E.change buffer
• F.doublewrite buffer

Comment: *

Name: *

Email: *

Verification: *

Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

• A.MyISAM
• B.ARCHIVE
• C.InnoDB
• D.NDB
• E.MEMORY

Comment: *

Name: *

Email: *

Verification: *

You want to check the values of the sort_buffer_size session variables of all existing connections.
Which performance_schema table can you query?

• A.session_variables
• B.global_variables
• C.variables_by_thread
• D.user_variables_by_thread

Comment: *

Name: *

Email: *

Verification: *

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: *