You are asked to examine user accounts and find:

Which two statements will best secure this environment? (Choose two.)

• A.REVOKE ALL PRIVILEGES FROM ''@'localhost';
• B.ALTER USER 'root'@'localhost' ACCOUNT LOCK;
• C.DROP USER ''@'localhost';
• D.ALTER USER bob PASSWORD = 'secret_password';
• E.ALTER USER bob@'%' IDENTIFIED BY 'secret_password';
• F.ALTER USER ''@'localhost' PASSWORD = 'secret_password';

Comment: *

Name: *

Email: *

Verification: *

The MySQL user `adam' currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the -single-option.
transaction
Which extra GRANT permissions are required for adam to take mysqldump backups?

• A.The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.
• B.The `adam' user must have the SUPER privilege in order to take data backups.
• C.The `adam' user must also have SELECT on the football database for backups to work.
• D.The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.

Comment: *

Name: *

Email: *

Verification: *

What are three methods to reduce MySQL server exposure to remote connections? (Choose three.)

• A.setting specific GRANT privileges to limit remote authentication
• B.setting --skip-networking when remote connections are not required
• C.using SSL when transporting data over remote networks
• D.setting --mysql_secure_configuration to enable paranoid mode
• E.using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

Comment: *

Name: *

Email: *

Verification: *

Multiversion Concurrency Control (MVCC) enables what type of backup?

• A.Hot
• B.Binary
• C.Logical
• D.Incremental

Comment: *

Name: *

Email: *

Verification: *

Which three allocate memory per thread in MySQL? (Choose three.)

• A.query cache
• B.thread cache
• C.read buffer
• D.internal temporary table
• E.sort buffer
• F.InnoDB buffer pool instance

Comment: *

Name: *

Email: *

Verification: *