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

A. Data is encrypted automatically, in real time, after it is written to storage.

B. Enables data-at-rest encryption by encrypting the physical files of the database.

C. Encryption key is stored in a centralized key memory location

D. Tablespace keys are managed manually behind the scenes.

You are using the innoDB engine and the innodb_f ile_per_table option is set. You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory. What will happen to the inventory table?

A. The table will be optimized and replicated.

B. The table will be checked for errors and repaired.

C. The table storage space will be reduced.

D. The table statistics will be stored.

Which two statements are true about MySQL Enterprise Firewall?

A. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

B. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.

C. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

D. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

E. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

F. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain.

Which two deployment architectures could you use for scaling-out database reads?

A. Implementing a three-node, single-primary InnoDB Cluster.

B. Edit the configuration file and increase the value for parallel_read_workers and reboot the server

C. Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.

D. Altering the storage engine for all tables to memory to increase performance.

E. Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.

Which three are requirements for MySQL Group Replication (GR)?

A. Data to be replicated must be stored in the InnoDB transactional storage engine.

B. The use of global transaction identifiers is required.

C. Primary keys are required on every replicated table.

D. GR only works with MySQL versions 8.0.12 or higher.

E. The binary log format must be set to mixed.

F. The minimum number of required nodes for achieving a consensus is two.