Assume that MySQL Enterprise Monitor is configured to monitor MySQL 8.0.10 or a later instance. Which three features are available?

A. creating e-mail alerts and SNMP traps for MySQL warnings

B. starting and stopping the MySQL instance

C. analyzing executed MySQL queries

D. deploying MySQL agent on supported target operating system

E. monitoring the availability of the MySQL Instance

F. tracing import and export with mysqldump

Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

A. MySQL Servers with Group Replication to replicate data to all members of the cluster.

B. MySQL Online Hot Backup to keep data consistent and always ready to be used.

C. MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.

D. MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

E. MySQL Router to ensure client requests are load balanced and routed to the correct servers.

Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

A. MySQL Enterprise Monitor and MySQL Audit

B. MySQL Workbench and MySQL Enterprise Firewall

C. MySQL Audit and MySQL Workbench

D. SQL Enterprise Monitor and MySQL Enterprise Authentication

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug- in

from being removed at run time.

Which two options should you include in the MySQL configuration file?

A. audit_log_permanent=ON

B. audit-log=FORCE_PLUS_PERMANENT

C. plugin-load=audit_log.so

D. plugin-audit=ON, ALWAYS

E. LOAD PLUGIN=AUDIT_LOG

The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A. On the Master server, disable binlog by removing the --log-bin option.

B. Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.

C. To safely purge binary log files, perform these steps:

1.

On each slave server, use show slave status to check which log file it is reading.

2.

Obtain a listing of the binary log files on the master server with show binary logs.

3.

Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up- to-date, this is the last log file on the list.

4.

Make a backup of all the log files you are about to delete. (This step is optional, but always

advisable.)

5.

Purge all log files up to but not including the target file by using the purge binary logs statement

D. Execute the purge binary logs statement without argument.

E. Delete all binlog files manually on the file system to release storage spaces.

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.

You have a backup image file that is backed up using MySQL Enterprise Backup with the --compress option: /home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

A. Option A

B. Option B

C. Option C

D. Option D

E. Option E

What SQL keyword must be specified when creating a foreign key constraint?

A. a TRIGGER on the child table for cascading delete statements

B. a REFERENCES in the child table to the parent table

C. unique PRIMARY key values for both child and parent tables

D. the SET_FOREGIN variable in the my .cnf file

E. an index on the foreign key

Which MySQL Enterprise Edition plug-in replaces real values with substitutes?

A. MySQL Enterprise Audit

B. MySQL Enterprise Scalability

C. MySQL Enterprise No-Login Authentication

D. MySQL Enterprise Transparent Data Encryption (TDE)

E. MySQL Enterprise Data Masking and De-identification

Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?

A. Custom Image

B. Object Storage

C. existing VCN

D. bare metal Oracle Linux shape

E. ssh key pair

F. subnet configured on a Virtual Cloud Network (VCN)