Question No. 1

Which three components can MySQL InnoDB Cluster use to Achieve database high availability?

AMySQL Servers with Group Replication to replicate data to all members of the cluster.

BMySQL Online Hot Backup to keep data consistent and always ready to be used.

CMySQL Shell to create and administer InnoDB Clusters using the built-in AdminAPI.

DMySQL X Plugin to enable MySQL to use the X Protocol to speed up and monitor data replication.

EMySQL Router to ensure client requests are load balanced and routed to the correct servers.

Show Answer

Correct Answer: A, C, E

https://www.sqlshack.com/deploy-mysql-innodb-clusters-for-high-availability/

Question No. 2

You have a backup image file that is backed up using MySQL Enterprise Backup with the ---compress option:

/home/mysq1/backup/full/mybackup/myimage. Img

You are required to perform a database restore to a new machine to provision the database. Which command can provision the new database in the datadir as /home/mysql/data/MEB?

A.

B.

C.

D.

E.

AOption A

BOption B

COption C

DOption D

EOption E

Show Answer

Correct Answer: B

Question No. 3

Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?

AYou forgot to enable port 3306.

BThe opc user can be used to access MySQL only with the created SSH-Key.

COnly root is allowed to access from non-localhost.

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

EThe OCI instance is still in the 'creation' process.

Show Answer

Correct Answer: A

Question No. 4

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?

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

BThe MASTER and SLAVE are grouped as one instance for monitoring.

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

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

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

Show Answer

Correct Answer: B, D

Question No. 5

You establish MySQL Enterprise Server on Oracle Cloud Infrastructure connection via Secure Shell (SSH).

When accessing a new MySQL Enterprise Edition Oracle Cloud Infrastructure (OCI) instance, you want to use MySQL Enterprise Workbench for SQL and remote management.

What are two ways to successfully configure Workbench based on the MySQL access credentials?

AOpen the MySQL OCI instance access port 3306. For the MySQL connection, you use this port, and, in addition, you configure the remote management based on SSH based on the provided key.

BConfigure the MySQL Router first and based on those settings, you access your MySQL CS instance.

CConfigure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.

DConvert the private key to ppk format first. Based on TCP/IP over SSH and based on the created private key, opc-user, and MySQL access credentials, you can access the MySQL CS instance.

Show Answer

Correct Answer: A

Free Oracle 1Z0-920 Exam Actual Questions

The questions for 1Z0-920 were last updated On Jan 12, 2025