Online Access Free 1z0-320 Practice Test

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

Consider the following SQL statement which is using the InnoDB storage engine and with global AUTOCOMMIT=1.
BEGIN;
CREATE TABLE t1 (c1 INT);
CREATE TABLE t2 (c1 INT);
ROLLBACK;
What is the result after issuing the ROLLBACK command?

• A.Both the tables, t1 and t2, are created.
• B.Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
• C.Only the t1 table is created.
• D.Only the t2 table is created.

Which three are part of the core MySQL architecture? (Choose three.)

• A.Disk parity/RAID
• B.Parser
• C.Storage engines
• D.Optimizer
• E.mysqldump

Your customer has provided you with the following server specifications: 64-bit, Oracle Linux 6, 24 Numa CPU cores, 48 GB memory, and sequential write-optimized drives in the /var/lib/seq-write directory. The customer wants you to optimize their MySQL 5.7.10 installation for the server resources available.
Identify three correct configurations for this server setup.

• A.innodb_data_file_path=/var/lib/seq-write, innodb_buffer_pool_size=36G, innodb_page_cleaners=8
• B.innodb_file_per_table=ON, innodb_numa_interleave=ON, lower_case_table_names=1
• C.mysql_numa_interleave=ON, innodb_buffer_pool_instances=8, innodb_log_file_size=24G
• D.innodb_buffer_pool_instances=12, innodb_buffer_pool_size=24G, innodb_log_file_size=12G
• E.innodb_log_file_size=12G, innodb_buffer_pool_instances=12, innodb_buffer_pool_size=48G
• F.plugin_load= "thread_pool.so", innodb_page_cleaners=12,
  innodb_log_group_home_dir=/var/lib/seq-write

You want to access your MySQL Cloud Service cloud environment from an external application based on ODBC. What are the required steps?

• A.Switch to the Compute Cloud Service Dashboard and disable reject:*.public-internet
• B.Create a new SSH key for your ODBC connector.
• C.Enable SSH tunnel and access MySQL based on TCP/IP over SSH.
• D.Access to the OS (SSH) and MySQL (3306) are open by default.
• E.Enable ora_p2admin_mysql, which opens port 3306 on the Access Rules tab.