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

A. MyISAM

B. NDB

C. MEMORY

D. ARCHIVE

E. InnoDB

An existing asynchronous replication setup is running MySQL 8.

Which two steps are a part of implementing GTID replication? (Choose two.)

A. Enable GTID by executing this on the master and the slave: SET GLOBAL GTID_ENABLED=on;

B. Execute this on the slave to enable GTID: START SLAVE IO_THREAD WITH GTID;

C. Restart MySQL (master and slave) with these options enabled: --gtid_mode=ON --log-bin --log-slave-updates --enforce-gtid-consistency

D. Execute this on the slave to enable GTID: RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;

E. On the slave, alter the MySQL master connection setting with: ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

F. On the slave, alter the MySQL master connection setting with: CHANGE MASTER TO MASTER_AUTO_POSITION = 1;

Which three are requirements for a secure MySQL Server environment? (Choose three.)

A. Restrict the number of OS users that have access at the OS level.

B. Ensure appropriate file system privileges for OS users and groups.

C. Minimize the number of non-MySQL Server-related processes running on the server host.

D. Encrypt the file system to avoid needing exact file-system permissions.

E. Keep the entire software stack on one OS host.

F. Run MySQL server as the root user to prevent incorrect sudo settings.

Which two MySQL Server accounts are locked by default? (Choose two.)

A. any user set as DEFINER for stored programs

B. any internal system accounts

C. any new ROLE accounts

D. any user created without a password

E. any user created with a username, but missing the host name

You recently upgraded your MySQL installation to MySQL 8.0.

Examine this client error:

Which option will allow this client to connect to MySQL Server?

A. [mysqld] default_authentication_plugin=sha256_password

B. ALTER USER user IDENTIFIED WITH mysql_native_password BY 'password';

C. [mysqld] default_authentication_plugin=caching_sha2_password

D. ALTER USER user IDENTIFIED WITH caching_sha2_password BY 'password';

E. ALTER USER user IDENTIFIED WITH sha256_password BY 'password';

F. [mysqld] default_authentication_plugin=mysql_native_password

Examine this statement, which executes successfully:

Now examine this query:

Which two statements can do this? (Choose two.)

A. ALTER TABLE employees ADD INDEX (birth_date DESC);

B. ALTER TABLE employees ADD INDEX ((MONTH(birth_date)));

C. ALTER TABLE employees ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

D. ALTER TABLE employees ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date- >>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);

E. ALTER TABLE employees ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

F. ALTER TABLE employees ADD INDEX (birth_date);

You are using mysqlcheck for server maintenance. Which two statements are true? (Choose two.)

A. The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

B. The mysqlcheck --optimize --all-databases command reclaims free space from table files.

C. The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

D. The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

E. The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

Which two methods allow a DBA to reset a user's password? (Choose two.)

A. ALTER USER statement

B. mysql_secure_installation utility

C. SET PASSWORD statement

D. mysqladmin client program

E. GRANT statement

Which two are features of MySQL Enterprise Firewall? (Choose two.)

A. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands

B. blocking of potential threats by configuring pre-approved whitelists

C. modifying SQL statement dynamically with substitutions

D. automatic locking of user accounts who break your firewall

E. provides stateless firewall access to TCP/3306

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;