Oracle 1Z0-320 Question Answer

You have the MySQL 5.7 database fuming. MySQL Enterprise Backup 3.12 Is installed and it Is used to bade up the MySQL 5.7 database. The backup has failed. Identify the reason.

A. MySQL Enterprise Backup 3.x does not support MySQL 5.7. MySQL Enterprise Backup 4.x or later is required to back up MySQL 5.7.
B. MySQL Workbench must be Installed with MySQL Enterprise Backup to enable the backup to run successfully.
C. MySQL 5.7 Is supported in MySQL Enterprise Backup 3.x with the MySQL 5.7 extension pack.
D. MySQL 5.7 is supported In MySQL Enterprise Backup 3.x providing that the MySQL 5.7 Is pre registered In the MySQL Enterprise Backup configuration file.
E. mysqlbackup with MySQL Enterprise Backup 3.x must be executed once with the -- upgrad on MySQL 5.7 database to allow the mysql.backup_proqress and mysql.backup_history tables to be patched.

Answer: A


By using the asynchronous MySQL Replication architecture, data can be replicated to slaves. Identify three use cases of MySQL Replication.

A. MySQL Replication Connector/) (Replication Driver) Is provided to allow read capability on slave and write capability on master.
B. MySQL Enterprise Backup will back up from Slave automatically.
C. It provides multi-master access where the application can write and read data across the database servers.
D. It allows backup to be done on the slave without impacting, the master.
E. You can create a slave server for reporting applications, which get only read access to the slave servers. It off-loads the master server. Additional slave servers allow different database server configuration.

Answer: A,B,E