1z1-320 by Oracle Valid Free Exam Practice Test

Question 1

A MySQL server (Linux-based installation, Port 3306, default) needs to be monitored. The MySQL server and the MySQL Enterprise Monitor (MEM) are located in different security zones, which are protected with a firewall. Which port must be opened for MEM agentless monitoring?

A. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server B. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server C. Port 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server D. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor

Correct Answer: D

Question 2

MySQL Replication Environment (Master and Slave) is prepared. What are the two options for connecting a Java application to the MySQL Master and Slave?

A. Use MySQL Router with the following configuration:[DEFAULT]logging_folder=
/var/log/mysqlrouter[logger]level=INFO[routing: failover]bind_port =
7001mode=replicationdestinations=master:3306, slave:3306The Java application can connect to bind_port=7001 B. The default JDBC driver is automatically configured with High Availability Option by pointing the connection URL to any one of the MySQL instances. C. Use MySQL Router with the following
configuration:[DEFAULT]logging_folder=/var/log/mysqlrouter[logger]level=INFO[routing:
failover]bind_port = 7001mode=read-writedestinations= master:3306, slave:3306The Java application can connect to bind_port=7001. D. Use MySQL Connector/J with the com.mysql.jdbc.ReplicationDriver with JDBC URL asjdbc:mysql:replication://[mater host] [:port], [slave host 1] [:port] [, [slave host 2] [:port]] ...
[/[database]] [? propertyName=propertyValue1 [&propertyName2-propertyValue2]...]

Correct Answer: D

Question 3

Which two statements are true about MySQL Enterprise Firewall?

A. MySQL Enterprise Firewall is available only in MySQL Enterprise versions 5.7.10.and later. B. System tables named firewall_users and firewall_whitelist in the mysql database provide persistent storage of firewall data. C. MySQL Enterprise Firewall shows only notifications blocked connections, which originated outside of your network's primary domain. D. 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. E. On Windows systems, MySQL Enterprise Firewall is controlled and managed by using the Windows Internet Connection Firewall control panel. F. Server-side plug-ins named MYSQL_FIREWALL_USERS and MYSQL_FIREWALL-WHITELIST implement INFORMATION_SCHEMA tables that provide views into the firewall data cache.

Correct Answer: B,F

Question 4

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

A. UPDATE mysql.user SET Password=PASSWORD ('Invalid') WHERE User= 'joe'; B. CREATE USER 'joe'@%' DENY ALL PRIVILEGES C. CREATE USER 'joe'@'0.0.0.0'SET Password=PASSWORD ('%!%') D. You cannot deny access to a user based on his or her username. E. Insert Joe's name into the mysql.user_restriction table, and issue the FLUSH PRIVILEGES command.

Correct Answer: E

Question 5

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=FORCE_PLUS_PERMANENT B. plugin-audit=ON, ALWAYS C. plugin-load=audit_log.so D. audit_log_permanent=ON E. LOAD PLUGIN=AUDIT_LOG

Correct Answer: A,D

Question 6

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

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

Correct Answer: A,B,D

Question 7

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. Logins are granted only if the user's client application and the corresponding MySQL instance are on the same IP address. 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. 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. E. 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.

Correct Answer: D,E

Question 8

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_log_file_size=12G, innodb_buffer_pool_instances=12, innodb_buffer_pool_size=48G B. innodb_data_file_path=/var/lib/seq-write, innodb_buffer_pool_size=36G, innodb_page_cleaners=8 C. plugin_load= "thread_pool.so", innodb_page_cleaners=12,
innodb_log_group_home_dir=/var/lib/seq-write D. mysql_numa_interleave=ON, innodb_buffer_pool_instances=8, innodb_log_file_size=24G E. innodb_file_per_table=ON, innodb_numa_interleave=ON, lower_case_table_names=1 F. innodb_buffer_pool_instances=12, innodb_buffer_pool_size=24G, innodb_log_file_size=12G

Correct Answer: A,B,D

Question 9

For accessing a new default MySQL Cloud Service (CS) cloud environment, you used the "Create SSH Keys function" during the guided MySQL CS setup. You want to use Putty from your Windows Client. Identify the correct steps.

A. Convert the private key to ppk format first, and use the new private key for authentication. B. Open Port 22 on your MySQL CS Instance and convert the private key to ppk format. This new private key can be used for authentication. C. Use the provided private key for authentication. D. You open Port 22 on your MySQL CS Instance and configure Putty with the provided private key.

Correct Answer: B

Question 10

Which two ports need to be opened on a network firewall to allow an outside client (on the other side of the firewall) to be able to access a MySQL instance inside the firewall?

A. Port 3306/tcp [MySQL], when tunneling is not used from within MySQL Workbench B. Port 13306/tcp [MySQL], when using TCP/IP via a command-line client C. Port 22/tcp [SSH], when using TCP/IP over SSH D. Port 18443/tcp [MySQL], when connecting from MySQL Workbench to a Windows MySQL server

Correct Answer: A,C

Oracle MySQL Cloud Service 2018 Implementation Essentials - 1z1-320 Exam Practice Test