MySQL Cloud Service 2018 Implementation Essentials (1z1-320) Free Practice Test

Question 1

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. Using the - - only- innodb or - - only- innodb- with -frm option to back up only InnoDB tables

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

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

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

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

Correct Answer: B,C,E

Question 2

You have a MySQL Server instance (running with Port# 3306) monitored by the Service Manager in MySQL Enterprise Monitor. You cloned the MySQL Database instance and configured it to be a replicated MySQL instance as Slave using Port# 3316 on the same machine as the Master Server. The replication configuration is working correctly. The Master and Slave Servers are running.
You are trying to add the newly created MySQL Slave instance to the Monitor. The Service Manager in MySQL Enterprise Monitor notifies you that the new instance is successfully added; however, it is not added correctly at the newly added configuration points to the old Master monitored items. The Monitor shows only one monitored MySQL instance for Master and Slave.
Identify two reasons for this problem.

A. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

B. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.

C. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

D. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.

E. The MASTER and SLAVE are grouped as one instance for monitoring.

Correct Answer: C,E

Question 3

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 22/tcp (SSH) from MySQL Enterprise Monitor to MySQL server

B. Port 21/tcp (ftp) from MySQL Enterprise Monitor to MySQL server

C. Port 18443/tcp (Tomcat) from MySQL server to MySQL Enterprise Monitor

D. Port 3306/tcp (MySQL) from MySQL Enterprise Monitor to MySQL server

Correct Answer: C

Question 4

You are using the MySQL Enterprise Audit plug-in, and the audit.log file is corrupted.
What steps would you perform to create a new audit file?

A. Stop the MySQL server. Reinstall the audit plug-in by using INSTALL PLUGIN audit_log SONAME
'audit_log.so'; Delete the corrupted file. Restart the MySQL server.

B. As the root user, execute the FLUSH AUDIT LOGS command. Refresh the audit plug-in with SET GLOBAL audit_log_status =REFRESH.

C. Stop the MySQL server. Move or rename the existing audit.log file. Restart the MySQL server.

D. As the root user, execute the SET GLOBAL audit_log_flush=ON command.

Correct Answer: A

Question 5

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. Application administration: the rights to view or change the MySQL Enterprise Monitor configuration

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

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

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

Correct Answer: B,C,E

Question 6

You have a text file named "xyz.csv" exported from another system.

You are asked to import data to a MySQL Database table named "country".
The table definition is as follows:

Identify the action that imports the data from Workbench or MySQL Client to the database correctly.

A. Convert the data into MDI and restore the MySQL data from it.

B. Use mysqlimport to load the mycountry.csv data file with the --csv option specified.

C. Use the LOAD DATA INFILE syntax to load data into the database table.

D. Create a DIRECTORY LINK object on the database and use INSERT into mycountry SELECT * from mycountry.csv.

Correct Answer: C

Question 7

Which two MySQL features are provided exclusively with the Enterprise Edition license, in addition to the database server?

A. MySQL Enterprise Firewall

B. MySQL Enterprise Monitor

C. MySQL Replication

D. MySQL Cluster Manager

Correct Answer: A,B

Question 8

A Cloud customer already has many database instances configured and running in the cloud, however, they are reporting that they are unable to create any more instances.
What could be the problem?

A. The customer account might have reached its compute quota.

B. The customer reached the database instance limit of 32.

C. The customer has not kept up with their patching requirements; new instances cannot be created unless the majority or the template of existing instances are up-to date.

D. The customer does not have proper user rights.

Correct Answer: B

Question 9

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

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

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

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

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

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

Correct Answer: B,C,D

Question 10

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. plugin-load=audit_log.so

B. audit_log_permanent=ON

C. LOAD PLUGIN=AUDIT_LOG

D. audit-log=FORCE_PLUS_PERMANENT

E. plugin-audit=ON, ALWAYS

Correct Answer: B,D

Welcome to TestSimulate

Oracle MySQL Cloud Service 2018 Implementation Essentials (1z1-320) Free Practice Test