Oracle MySQL 2019 Implementation Essentials - 1Z0-920 Exam Questions [2026]

QUESTION NO: 1
Which features of MySQL Enterprise Edition should you use to proactively monitor and track data changes in your databases?

A. MySQL Enterprise Monitor and MySQL Audit B. MySQL Workbench and MySQL Enterprise Firewall C. SQL Enterprise Monitor and MySQL Enterprise Authentication D. MySQL Audit and MySQL Workbench

Correct Answer: C

QUESTION NO: 2
Which two statements are true about MySQL Enterprise Firewall?

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

Correct Answer: A,F

QUESTION NO: 3
Which three are requirements for MySQL Group Replication (GR)?

A. Data to be replicated must be stored in the InnoDB transactional storage engine. B. The minimum number of required nodes for achieving a consensus is two. C. GR only works with MySQL versions 8.0.12 or higher. D. The use of global transaction identifiers is required. E. The binary log format must be set to mixed. F. Primary keys are required on every replicated table.

Correct Answer: A,E,F

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 4
After installing MySQL 8.0, you initialize the data directory with the --initialize command. Which two are places where you can find the root password?

A. The root_pw variable stored in the mysq1.install table. B. The root password displayed on the screen via a [warning] message. C. As root, execute the show password command by using the SHA-256 password encryption plug-in. D. The root password is not given and is blank. You must manually set the root password. E. The root password inserted in the error log set by the --log-error=[file_name] variable

Correct Answer: A,C

QUESTION NO: 5
The MySQL Replication Environment (Master and Slave) is prepared.
What two are options for connecting a Java application to the MySQL Master and Slave?
A)

B)

C)

D)

A. Option A B. Option C C. Option D D. Option B

Correct Answer: A

QUESTION NO: 6
Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?

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

Correct Answer: A

QUESTION NO: 7
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.
Which two are possible reasons for this problem?

A. The MASTER and SLAVE are grouped as one instance for monitoring. B. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID. C. The SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid. D. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf. E. The mysql.instance table on SLAVE is cloned with the same content as MASTER, which has the same server UUID.

Correct Answer: A,E