1Z0-320 exam question

Pass 1Z0-320 Exam By Practicing Latest 1Z0-320 VCE and PDF Braindumps

Attention please! Here is the shortcut to pass your Hotest 1Z0-320 vce exam! Get yourself well prepared for the Oracle Cloud Newest 1Z0-320 vce dumps MySQL Cloud Service 2018 Implementation Essentials exam is really a hard job. But don’t worry! We We, provides the most update 1Z0-320 new questions. With We latest 1Z0-320 vce, you’ll pass the Oracle Cloud Apr 06,2022 Latest 1Z0-320 exam questions MySQL Cloud Service 2018 Implementation Essentials exam in an easy way

We Geekcert has our own expert team. They selected and published the latest 1Z0-320 preparation materials from Official Exam-Center.

The following are the 1Z0-320 free dumps. Go through and check the validity and accuracy of our 1Z0-320 dumps.1Z0-320 free dumps are questions from the latest full 1Z0-320 dumps. Check 1Z0-320 free questions to get a better understanding of 1Z0-320 exams.

Question 1:

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

A. MySQL Replication Connector/J (ReplicationDriver) 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 servers allow different database server configuration.

Correct Answer: BDE


Question 2:

The MySQL pluggable authentication plug-in for Windows is enabled and configured. The following command is executed on a MySQL Server: CREATE USER `SQL_admin\’@\’%\’ IDENTIFIED WITH authentication_windows AS `joe, henry, “Power Users”\’;

Which two statements are valid?

A. When any of the named users is using a Linux Client, the user can access the MySQL Server from a MYSQL Client with the password configured in MySQL.

B. User Joe may log in to a Windows Client and then access the MySQL Server from a MySQL Client without being asked about a password.

C. When any of the named users is using a Linux Client, the user can access the MySQL Server from s MySQL Client with the password configured in the Windows Active Directory.

D. When any of the named users is using a Java application based on his or her Windows Client, no authentication is necessary to log in to MySQL.

E. Logins are granted only if the user\’s client application and the corresponding MySQL instance are on the same IP address.

Correct Answer: BD


Question 3:

You get a Maintenance notification about your Oracle MySQL Cloud Service. What are the implications?

A. There are no maintenance operations planned. You need to do them manually.

B. Depending on the planned outage, you may not be affected by it. You need to read the maintenance details in the support notice.

C. You need to agree to the maintenance windows. If not, you are not affected by the outage.

D. You can expect an outage of your MySQL Cloud Service during the planned time.

Correct Answer: D


Question 4:

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 – – backup-image=/backups/image.enc – – encrypt – -key-file= keyfile – -backup-dir=/var/tmp/backup backup-to-image

B. # mysqlbackup- – encrypt – -key-file=keyfile – -backup-dir=/var/tmp/backup backup

C. # mysqlbackup – – backup-image=/backups/image.enc – – encrypt- – encrypt-key=keyfile – – backup-dir=/var/tmp/backup backup-to-image

D. # mysqlbackup – – backup-image=/backups/image.enc – – encrypt – -key=keyfile – -backup-dir=/var/tmp/backup backup-to-image

E. # mysqlbackup- – encrypt – -key-file=keyfile – -backup-dir=/var/tmp/backup ?timestamp backup

Correct Answer: D

Reference: https://dev.mysql.com/doc/mysql-enterprise-backup/4.1/en/meb-encryption.html


Question 5:

You use MySQL Enterprise Monitor for a group of MySQL servers. In recent weeks, the MySQL Enterprise Monitor has slowed down significantly.

Which two preventative actions should you take if your number of monitored MySQL instances has changed?

A. Increase the disk space with at least 10% of the database size.

B. Increase the necessary operating system swap space (Linux): mkswap /dev/sdx; swapon/dev/sdx, /etc/fstab.

C. Increase the amount of RAM available to the JVM installed with Tomcat. The JVM memory settings are defined by the JAVA_OPTS line of the setenv file, which sets the environment variables for Tomcat (–JvmMs/-Xms and -JvmMx/-Xmx).

D. Tune the InnoDB Buffer Pool of the MySQL Enterprise Monitor Repository database. This can have a significant impact on performance (innodb_buffer_pool_size).

Correct Answer: AD

Reference: https://dev.mysql.com/doc/refman/5.6/en/innodb-buffer-pool.html


Question 6:

Your newly created MySQL Cloud Service is not available from your application. Select the two correct options that apply.

A. You forgot to create the correct SSL/TLC certificate during the setup process.

B. The `opc\’ user can be used to access MySQL only with the created SSH-Key.

C. Only `root\’ is allowed to access from non-localhost.

D. The MySQL instance is still in the “Creation” process.

E. You forgot to enable port 3306.

Correct Answer: CE


Question 7:

Which command in MySQL Utility can perform and start replication among a slave and multiple masters?

A. mysqlrplcheck

B. mysqlrplms

C. mysqlrpladmin

D. mysqlreplicatems

E. mysqlreplicate

Correct Answer: B

Reference: https://dev.mysql.com/doc/mysql-utilities/1.5/en/mysqlrplms.html


Question 8:

Which three installation options are available for installing the MySQL Enterprise Monitor/Agent on Linux?

A. A GUI for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

B. A CLI-based wizard MySQL Enterprise Monitor, Agent, and a MySQL Repository database

C. A script (with an option file) for installing MySQL Enterprise Monitor, Agent, and a MySQL Repository database

D. A MySQL Enterprise Monitor to remotely deploy the MySQL Monitor Agent

E. A browser-based wizard to remotely deploy the MySQL Monitor Agent

Correct Answer: ABC


Question 9:

Name three ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances.

A. Email

B. SMS

C. Notification tab on the dashboard

D. Browser pop-ups

E. Direct support call from an Oracle representative

Correct Answer: ABC


Question 10:

You are required to set up a backup user ([email protected]) on the MySQL Database. The user should have the backup and restore privileges and additional privileges required for using transportable tablespaces (TTS). To back up and restore InnoDB tables.

Which syntax accomplishes this?

A. CREATE USER `mysqlbackup\’@localhost\’IDENTIFIED BY `new-password\’;

B. CREATE USER `mysqlbackup\’@localhost\’ IDENTIFIED BY `new-password\’; GRANT RELOAD ON *.* TO `mysqlbackup\’@\’localhost\’; GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO `mysqlbackup\’@\’localhost\’; GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO `mysqlbackup\’@\’localhost\’; GRANT REPLICATION CLIENT ON *.* TO `mysqlbackup\’@\’localhost\’; GRANT SUPER ON *.* TO `mysqlbackup\’@\’ localhost; GRANT PROCESS ON *.* `mysqlbackup\’@\’localhost\’;

C. CREATE USER `mysqlbackup\’@\’localhost\’ IDENTIFIED BY `new-password\’; GRANT RELOAD ON *.* TO `\’mysqlbackup\’@\’localhost\’; GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO `mysqlbackup\’@\’localhost\’; GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO `mysqlbackup\’@localhost\’;

D. CREATE USER `mysqlbackup\’@\’localhost\’ IDENTIFIED BY `new-password\’; GRANT RELOAD ON *.* to `mysqlbackup\’@localhost\’; GRANT CREATE, INSERT, DROP, UPDATE ON, mysql.backup_progress TO `mysqlbackup\’@\’localhost\’; GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO `mysqlbackup\’@\’localhost\’; GRANT REPLICATION CLIENT ON *.* to `mysqlbackup\’@\’localhost\’; GRANT SUPER ON *.* TO `mysqlbackup\’@\’localhost\’; GRANT PROCESS ON *.* TO `mysqlbackup\’@\’localhost\’; GRANT LOCK TABLES, SELECT, CREATE, ALTER ON *.* TO `mysqlbackup\’@\’localhost\’; GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_sbt_history TO `mysqlbackup\’@\’localhost\’;

E. CREATE USER `mysqlbackup\’@\’localhost\’ IDENTIFIED BY `new-password\’; GRANT RELOAD ON *.* TO `mysqlbackup\’@\’localhost\’; GRANT CREATE, INSERT, DROP, UPDATE ON mysql.backup_progress TO `mysqlbackup\’@\’localhost\’; GRANT CREATE, INSERT, SELECT, DROP, UPDATE ON mysql.backup_history TO `mysqlbackup\’@\’localhost\’; GRANT REPLICATION CLIENT ON *.* TO `mysqlbackup\’@\’localhost\’;

Correct Answer: A


Question 11:

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of a large table named INVENTORY.

What command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

A. ANALYZE TABLE INVENTORY;

B. mysqlcheck INVENTORY

C. mysqldump INVENTORY

D. OPTIMIZE TABLE INVENTORY;

Correct Answer: D

Reference: https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html


Question 12:

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.

Which two options should you include in the MySQL configuration file?

A. audit_log_permanent=ON

B. audit-log=FORCE_PLUS_PERMANENT

C. plugin-load=audit_log.so

D. plugin-audit=ON, ALWAYS

E. LOAD PLUGIN=AUDIT_LOG

Correct Answer: AB

Reference: https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html


Question 13:

Assume that MySQL Enterprise Monitor is configured to monitor MySQL 5.6 or a later instance. Which three features are available?

A. Deploying MySQL Agent on supported target operating system

B. Tracing import and export with mysqldump

C. Monitoring the availability of the MySQL instance

D. Creating E-Mail Alerts and SNMP Traps for MySQL Warnings

E. Starting and Stopping the MySQL Instance

F. Analyzing executed MySQL queries

Correct Answer: ABD


Question 14:

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

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

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.

Correct Answer: B


Question 15:

How do you restrict a user named joe from being able to connect from any IP address to a MySQL database?

A. Insert Joe\’s name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command.

B. You cannot deny access to a user based on his or her username.

C. CREATE USER `joe\’@%\’ DENY ALL PRIVILEGES

D. UPDATE mysql.user SET Password=PASSWORD (`Invalid\’) WHERE User= `joe\’;

E. CREATE USER `joe\’@\’0.0.0.0\’SET Password=PASSWORD (`%!%\’)

Correct Answer: A