Oracle MySQL 2021 Implementation Essentials Sample Questions:

1. Which two deployment architectures could you use for scaling-out database reads?

A) Changing the system setting with memory stickiness to true in order not to swap out mysq1dfrom memory.
B) Altering the storage engine for all tables to memory to increase performance.
C) Adding a memcached-tier for caching data and objects in RAM to reduce the number of times an external data source must be read.
D) Implementing a three-node, single-primary InnoDB Cluster.
E) Edit the configuration file and increase the value for parallel_read_workers and reboot the server

2. Which three statements are true about MySQL Enterprise Backup?

A) It cannot back up encrypted tablespaces.
B) It performs logical backups.
C) It enables you to take non-locking backups.
D) It provides the ability to create incremental backups.
E) It performs hot or warm backups.

3. Which two statements are true about MySQL Enterprise Firewall?

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

4. 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?

A) Open 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.
B) Configure TCP/IP over SSH and based on the created private key, opc-User, and MySQL access credentials, you can access the MySQL OCI instance.
C) Configure the MySQL Router first and based on those settings, you access your MySQL CS instance.
D) Convert 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.

5. Which is true about inserting an additional line in a single document stored in MySQL document store?

A) The path specified must be an array position past the end of an array using the JSON_POSITION statement.
B) You cannot insert a single line, you have to replace the entire document with a new document.
C) You specify the new element,s position in the JSON_ARRAY_INSERT statement.
D) Any new lines can only be inserted at the end of the document.

Solutions: