Which three are recommended configurations for installing and running MySQL InnoDB Cluster?

• A. smaller VM,s work best - with a maximum of eight vCPU,s and 16GB of RAM
• B. Networks must be in separate regions.
• C. Use Network-attached storage (NAS) for the data files.
• D. The number of machines per group must be 3, 5, 7 or 9.
• E. isolated machine resources
• F. use SSD,s for data and replication logs
• G. Groups must be in even numbers; 2, 4, 6, 8.

Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

• A. connections through the local host via the UNIX socket file
• B. authentication via Pluggable Authentication Modules (PAMs)
• C. Simple Authentication and Security Layer
• D. Native Windows services
• E. authentication using SHA-256 password hashing
• F. SECURID authentication and authorization identity

What three are ways to export and import data in MySQL Workbench?

• A. Backup Data Export and Import Wizard
• B. Data Modeling Import Export Wizard
• C. SQL Data Export and Import Wizard
• D. Binary Data Export and Import Wizard
• E. Result Data Export and Import
• F. Table Data Export and Import Wizard

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).
When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.
What are two ways to successfully configure Workbench based on the MySQL access credentials?

• A. Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
• B. Convert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.
• C. Open the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.
• D. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

You have three machines with MySQL Databases running on Linux platform.
Which backup procedures would allow online and remote backup of the MySQL Database on the three machines to a connected Storage NFS?

• A. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on all three machines.3. Start mysqlbackup on all machines to back up the database to the mounted volume using - -backup-dir.4. Validate the backup using the mysqlbackup program to ensure that the backup created is valid.
• B. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on machine which is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - -backup-dir and by giving--hosts=machine1:port1, machine2:port2, machine3:port3.4. Validate the backups using the mysqlbackup program to ensure that the backups created are valid.
• C. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Workbench on a separate machine, which is used to connect to the three machines to back up and restore.3. Startup MySQL backup from MySQL Workbench to back up the three databases.4. Validate the backup by using MySQL Workbench to ensure that the backup created is valid.
• D. 1. Mount the Remote Storage NFS volume to each of the three machines with proper privilege for the backup OS user to have all access.2. Install MySQL Enterprise Backup on the machine that is used to start the backup.3. Start mysqlbackup on only one machine with the installation to back up the databases for the three machines to the mounted volume using - - backup-dir and by specifying -- config-files=my1.cnf, my2.cnf, my3.cnf.my1.cnf, my2cnf, and my3.cnf are the MySQL Database Configuration files on the three machines.4. Validate the backup by using the mysqlbackup program to ensure that the backup created is valid.