1Z0-921 Exam Training Practice Tests (Oracle MySQL 2021 Implementation Essentials)]

Question 1

You have created your Compute instance using an Oracle-provided Oracle Linux image.
You want to log in to your OCI Compute instance using SSH. Which three items do you need for this process?

A. The opc user B. SSH public key C. SSH private key D. Public IP address E. The root user F. User Password

Correct Answer: A

Question 2

What SQL keyword must be specified when creating a foreign key constraint?

A. unique PRIMARY key values for both child and parent tables B. the SET_FOREGIN variable in the my .cnf file C. an index on the foreign key D. a REFERENCES in the child table to the parent table E. a TRIGGER on the child table for cascading delete statements

Correct Answer: E

Question 3

Which three are levels in which MySQL Enterprise Monitor provides access control?

A. MySQL Enterprise Operations: the right to deploy the necessary MySQL Enterprise Agent 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 start/stop/restart/update MySQL Enterprise Monitor Services E. Specific data access: the rights to view specific types of potentially sensitive data

Correct Answer: B,C,E

Question 4

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

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

Correct Answer: B

Question 5

Which three options are valid reasons for using a primary key in a table?

A. preventing duplicate keys B. automatic storage of data in a sorted order C. increasing performance when using select statements D. to make it easier to change the PRIMARY KEY value E. exporting data faster with mysqldump F. maintaining a history of row insertions or updates

Correct Answer: A,C,E

Question 6

You set up a compressed full backup file from mysqlbackup by using the --compress option for MySQL Database backup. You are required to restore the database and apply the log.
Which two options should you add to the mysqlbackup to achieve the restoration of the database?

A. --copy-back-and-apply-log B. --decompress C. --apply-log-and-copy-back D. --uncompress-and-apply-log E. --uncompress

Correct Answer: A,E

Question 7

Which component of MySQL Enterprise Monitor provides trend analysis and capacity planning for MySQL databases?
Response:

A. MySQL Advisors B. Query Analyzer C. MySQL Dashboard D. MySQL Query Analyzer

Correct Answer: D

Question 8

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 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. The mysql.inventory table on SLAVE is cloned with the same content as MASTER, which has the same server UUID. E. All the MySQL instances (Master and Slave) have the same server_uuid in <datadir>/auto.cnf.

Correct Answer: A,C

Oracle MySQL 2021 Implementation Essentials - 1Z0-921 Exam Practice Test