Free Oracle 1Z0-920 Exam Dumps Questions & Answers

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

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

• A.  SQL Enterprise Monitor and MySQL Enterprise Authentication
• B.  MySQL Audit and MySQL Workbench
• C.  MySQL Enterprise Monitor and MySQL Audit
• D.  MySQL Workbench and MySQL Enterprise Firewall

You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1; You receive the following error:
ERROR 1031 (HY000): Table storage engine for 'test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

• A.  The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.
• B.  You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.
• C.  The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.
• D.  The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.

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

• A.  MySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.
• B.  MySQL Router to ensure client requests are load balanced and routed to the correct servers.
• C.  MySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.
• D.  MySQL Online Hot Backup to keep data consistent and always ready to be used.
• E.  MySQL Servers with Group Replication to replicate data to all members of the cluster.

Which two statements about the download of MySQL Enterprise Backup are correct?

• A.  MySQL Enterprise Backup comes with MySQL Connector and is freely available for download.
• B.  MySQL Enterprise Backup comes with MySQL Utilities Package, which is available for download publicly on http://www.mysql.com.
• C.  MySQL Enterprise Backup comes with all MySQL editions including community edition.
• D.  MySQL Enterprise Backup can be downloaded from My Oracle Support (MOS).
• E.  MySQL Enterprise Backup is a separate package from MySQL Enterprise Edition. It can be downloaded from https://edelivery.oracle.com.