Oracle MySQL 2021 Implementation Essentials Sample Questions:

1. How does MySQL HeatWave improve query performance?
Response:

A) By offloading analytics queries to an in-memory, highly parallel processing engine.
B) By caching the entire database in memory.
C) By replicating data across multiple servers.
D) By automatically creating indexes on frequently used columns.

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

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

3. What three are ways to export and import data in MySQL Workbench?

A) Result Data Export and Import
B) Backup Data Export and Import Wizard
C) Table Data Export and Import Wizard
D) Binary Data Export and Import Wizard
E) SQL Data Export and Import Wizard
F) Data Modeling Import Export Wizard

4. The replication for a Master and Slave MySQL Servers is up and running. The disk space for Master Server is continuously growing. The binlog size keeps growing. Which two methods can fix the issue?

A) To safely purge binary log files, perform these steps:
B) On the Master server, disable binlog by removing the --log-bin option.
C) Execute the purge binary logs statement without argument.
D) Set the expire_logs_days system variable to expire binary log files automatically after a given number of days.
E) Delete all binlog files manually on the file system to release storage spaces.

5. Which best describes database horizontal scale-out architecture deployment in MySQL in a read-heavy environment?

A) Allocating more CPU to the database instance to improve throughput performance.
B) Increasing the memory capacity so that there is a larger pooling buffer to increase the database read performance.
C) Adding more MySQL servers and sharing the same dacadir on a shared storage component like NFS.
D) Increasing the storage capacity so that the database can store more data to scale.
E) Deploy MySQL read-only slaves utilizing replication so that the slaves can be used for reads.

Solutions: