Oracle 1z1-320 Value Pack (Frequently Bought Together)

You are setting up a MySQL Cluster on two machines, where each machine is hosting the following:
-1x ndbmtd
-1x ndb_mgmd
-1x mysqld
The cluster is started. What will happen if the network connection between the two machines is disconnected?

• A. The entire cluster will be shut down.
• B. A MySQL Cluster backup process will be kick-started automatically.
• C. The MySQL Cluster service will be paused. After the network is online, the MySQL Cluster service will be resumed.
• D. Components from one of the machines will be chosen as victim. Only one machine will provide service.
• E. All components will be running correctly and independently. Machine1 and Machine2 have all data and they can provide service online.

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

Which three backup scenarios can be accommodated with MySQL Enterprise Backup? (Choose three.)

• A. making a single file backup by creating backups in single-file format
• B. converting a database backup from another database vendor to MySQL
• C. making a backup directly into tape device by using MySQL Enterprise Backup Media Management Software (MMS)
• D. making partial backup and optimistic backup
• E. creating a cloud backup

MySQL Enterprise provides query analyzing metrics for SQL statements. Which four MySQL environments will provide QUAN metrics?

• A. All MySQL (with MySQL Enterprise Monitor Proxy)
• B. MySQL 5.7.9 Community (and later)
• C. MySQL 5.5.9 (and later)
• D. All MySQL (when MySQL connectors with Aggregator is used for the application)
• E. MySQL 5.6.14 Commercial (and later)

You want to create a copy of the City table and include all the data. The new table name is City_part. Which statement would accomplish this task?

• A. CREATE TABLE City_part LIKE City;
• B. CREATE TABLE City_part AS SELECT * FROM City;
• C. INSERT INTO City_part SELECT * FROM City;
• D. CREATE TABLE City_part LIKE City INSERT INTO City_part * FROM City;