Oracle MySQL 2021 Implementation Essentials - 1Z0-921 Exam Practice Test

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

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

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

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. 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.

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

A. Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.

B. 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.

C. 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.

D. 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.

A. MySQL Enterprise Backup provides the point-in-time recovery functionality.

B. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

C. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.

D. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

E. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.

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.

A. The super privilege is required when starting, stopping, or restarting monitored MySQL databases.

B. The super privilege is required when creating and populating the inventory table, as well as running statements such as show master logs or SHOW ENGINE INNODB STATUS.

C. Monitoring metrics need super and root privileges because they are not available for a less-privileged user.

D. MySQL Enterprise Monitor creates the required users automatically.

A. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

B. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.

C. The MASTER and SLAVE are grouped as one instance for monitoring.

D. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

E. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.

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 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.

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 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.

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 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.

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 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.

A.

B.

C.

D.

E.