[PDF and VCE] Free 1Z0-320 PDF Real Exam Questions and Answers Free Download

Attention please! Here is the shortcut to pass your Jun 06,2022 Newest 1Z0-320 QAs exam! Get yourself well prepared for the Oracle Cloud Newest 1Z0-320 practice MySQL Cloud Service 2018 Implementation Essentials exam is really a hard job. But don’t worry! We We, provides the most update 1Z0-320 vce. With We latest 1Z0-320 dumps, you’ll pass the Oracle Cloud Newest 1Z0-320 pdf 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.If you need to check sample questions of the 1Z0-320 free dumps, go through the Q and As from 1Z0-320 dumps below.

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 want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by a MEM agent should automatically monitor discovered instances.

How can you change the Advisor Setting?

A. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.

B. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.

C. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.

D. Go to the configuration section (MEM) and configure the default login credentials.

Correct Answer: B

Reference: https://docs.oracle.com/cd/E17952_01/mysql-monitor-3.0-relnotes-en/news-3-0-0.html


Question 4:

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 5:

You are requested to export data from a set of the following tables in the database `world_x\’. Tables (country, countryinfo, location)

Which two options would allow you to export data as files?

A. using MySQL Client and the – -dump option to dump the tables to files: # mysql –u -p –h -P — dump world_x.country world_x.countryinfo world_x.location

B. using MySQL Client and EXPORT TO to export data one by one: mysql>EXPORT world_x.country TO `/output/country.txt\’; mysql>EXPORT world_x.countryinfo TO `/output/countryinfo.txt\’; mysql>EXPORT world_x.location TO `/output/location.txt\’;

C. using MySQL Client and SELECT …INTO OUTFILE `\’ from to export data one by one: mysql>select * into outfile `/output/country.txt\’ from world_x.country; mysql>select * into outfile `/output/countryinfo.txt\’ from world_x.countryinfo; mysql>select * into outfile `/output/location.txt\’ from world_x.location;

D. using mysqlexport to export multiple tables in a database in one command line: # mysqlexport –u- h -P -p world_x country countryinfo location> mydump.sql

E. using mysqldump to dump multiple tables in a database in one command line: # mysqldump –u- h -P -p world_x country countryinfo location> mydump.sql

Correct Answer: CE


Question 6:

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

What are two key differences between the use of ndbd and ndbmtd?

A. ndbd can be configured as ndbmtd by applying the option – – mtd.

B. In the event of critical errors, ndbd generates a trace file with the name ndb_node_id_trace.log.trace_id, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id

C. ndbd is single-threaded mode; however, ndbmtd runs by default in multithreaded mode.

D. ndbd is single-threaded mode.ndbmtd runs by default in single-threaded mode; you must configure it to use multithreads.

E. In the event of critical errors, ndbd generates all trace in error log, whereas ndbmtd generates a trace file with the name pattern ndb_node_id_trace.log.trace_id_tthread_id.

Correct Answer: DE


Question 8:

When there are long-running queries, mysqbackup hangs there to wait for the completion of the queries. You know that the system has only user data on InnoDB and there is no DDL execution during the backup period. There is no update/ alternation to tables with non-InnoDB storage engines.

Which two ways allow the MySQL Enterprise Backup to be executed without being blocked or without locking?

A. Running mysqlbqckup from a remote machine enabled you to back up the database without locking.

B. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds) and does not disturb the normal processing of mysqld much. However, use – -single-user-mode to back up the long-running queries to allow mysqlbackup to run successfully without locking.

C. There is no extra option. MySQL Enterprise Backup does this automatically by kicking out the long-running queries.

D. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the – – only-innodb option to back up only InnoDB tables, to avoid blocking.

E. The locked phase at the end of a mysqlbackup run is short (maybe a few seconds), and does not disturb the normal processing of mysqld much. However, use the – -no-locking option to backup up the non-InnoDB files. Note that MyISAM, .frm, and other files copied under the –no-locking setting cannot be guaranteed to be consistent, if they are updated during this final phase of the backup.

Correct Answer: BE

Reference: https://docs.oracle.com/cd/E17952_01/mysql-enterprise-backup-3.10-en/mysql-enterprise-backup-3.10-en.pdf (page 62)


Question 9:

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 10:

After the installation of the MySQL Server, you cannot find MySQL Utilities. How would you correct the problem?

A. MySQL Utilities comes with MySQL Enterprise Monitor. Download MySQL Enterprise Monitor to install.

B. MySQL Utilities is installed with MySQL Server Binary. Put the MySQL bin folder into PATH to allow execution.

C. MySQL Utilities is a package from MySQL Connector. Download the MySQL/Connector and install.

D. MySQL Utilities comes with MySQL Enterprise Backup. Download MySQL Enterprise Monitor to install.

E. MySQL Utilities is a package of utilities that are used for maintenance and administration of MySQL servers. Download the MySQL Utilities separately from www.mysql.com.

Correct Answer: E

Reference: https://dev.mysql.com/doc/workbench/en/wb-mysql-utilities.html


Question 11:

Identify an example of creating an Enterprise Encryption function.

A. [email protected] = CREATE_ASYMMETRIC_PRIV_KEY (@algo, @key_len);

B. VALIDATE FUNCTION create_asymmetric_priv_key WITH `openssl_udf.so\’;

C. INSERT INTO t1 (key-col) FUNCTION(CREATE_ASYMMETRIC_PRIV_KEY(`RSA\’, 1024));

D. CREATE FUNCTION asymmetric_decrypt RETURNS STRING SONAME `openssl_udf.so\’;

Correct Answer: D

Reference: https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/enterprise-encryption-installation.html


Question 12:

Which two statements are true about MySQL Enterprise Firewall?

A. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel.

B. The firewall functionality is dependent upon SHA-256 and ANSI-specific functions built in to the mysql.firewall table. These functions cannot be deleted, even by the root user.

C. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later.

D. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

E. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data.

F. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network\’s primary domain.

Correct Answer: DE

Reference: https://planet.mysql.com/entry/?id=5989808


Question 13:

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


Question 14:

Identify three levels in which MySQL Enterprise Monitor provides access control.

A. MySQL Enterprise Operations: the right to start/stop/restart/update MySQL Enterprise Monitor Services

B. Asset visibility: the rights to access data collected from hosts or MySQL instances

C. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration

D. Specific data access: the rights to view specific types of potentially sensitive data

E. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent

Correct Answer: BCD

Reference: https://dev.mysql.com/doc/mysql-monitor/3.4/en/mem-acl-users-roles-ref.html


Question 15:

The MySQL database for backup with used data is configured only with the InnoDB storage engine. System data including SP, VIEWs, and users in the system database are all static. For any changes with system data, the database backup will be done separately.

You are requested to optimize backup performance to reduce backup time by using MySQL Enterprise Backup for the daily backup operation with user data (configured with the InnoDB storage engine).

Which three options would you choose to optimize the backup performance?

A. Shutting down the MySQL database and using MySQL Enterprise Backup to restart the MySQL Database to remove any potential locking

B. Using the – – only- innodb or – – only- innodb- with 璮rm option to back up only InnoDB tables

C. Running multiple MySQL Enterprise Backups at the same time to back up the same database to allow parallel database backups on MySQL

D. Running the backup with the backup policy, full backup and incremental backup, supported by MySQL Enterprise Backup to reduce the daily backup time

E. Using the – – no-locking option to backup non_InnoDB files

Correct Answer: CDE


Tagged: Tags