Oracle MySQL Cloud Service 2018 Implementation Essentials : 1z0-320

When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period.
There is no update/alternation to tables with non-InnoDB storage engines.
Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking?

• A. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.
• B. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use - -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking.
• C. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.
• D. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - - only-innodb option to back up only InnoDB tables, to avoid blocking.
• E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the - -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the --no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.

The MySQL Cloud Service (CS) is a database offering from Oracle. Which three statements are correct?

• A. MySQL CS is based on the MySQL GPLv2 version from the Oracle Linux 6 with optimizations for the Cloud (Oracle Flexible Architecture Standard).
• B. MySQL CS configuration can be changed in /etc/my.cnf.
• C. Oracle MySQL Enterprise Tools & Plugins are available as optional services (installation Feature Pack I/II).
• D. MySQL CS is based on an IaaS Oracle Linux image including full root privileges to the OS.
• E. MySQL CS is installed based on the Oracle Flexible Architecture Standard.
• F. MySQL CS is based on the MySQL Enterprise Product Suite.

Identify three features of MySQL Enterprise Backup.

• A. You can validate the results of a MySQL Enterprise Backup to ensure that your backup has integrity.
• B. You can back up data that has changed since the last backup with incremental backup.
• C. You can edit the output file produced by a MySQL Enterprise Backup.
• D. You can run the output file produced by a MySQL Enterprise Backup through a MySQL session because the output file consists of SQL statements.
• E. You can back up individual tables or individual tablespaces with MySQL Enterprise Backup while your server instance is online.

You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Identify two reasons for this problem.

• A. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_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 mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

A keyfile has been generated as follows:
# openssl rand 32 -hex >keyfile
# cat keyfile
6a1d325e6ef0577f3400b7cd624ae574f5186d0da2eeb946895de418297ed75b
You are required to do a backup on the MySQL database using MySQL Enterprise Backup with encryption.
Which option can perform the backup with the keyfile provided in order to encrypt the backup files?

• A. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup - timestamp backup
• B. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt- - encrypt-key=keyfile - - backup-dir=/var/tmp/backup backup-to-image
• C. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key=keyfile -
  -backup-dir=/var/tmp/backup backup-to-image
• D. # mysqlbackup - - backup-image=/backups/image.enc - - encrypt - -key-file= keyfile -
  -backup-dir=/var/tmp/backup backup-to-image
• E. # mysqlbackup- - encrypt - -key-file=keyfile - -backup-dir=/var/tmp/backup backup