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

Question 1

You need to load the MySQL Enterprise Audit plug-in at database startup and prevent the audit plug-in from being removed at run time.
Which two options should you include in the MySQL configuration file?

A. LOAD PLUGIN=AUDIT_LOG

B. plugin-load=audit_log.so

C. plugin-audit=ON, ALWAYS

D. audit-log=FORCE_PLUS_PERMANENT

E. audit_log_permanent=ON

Correct Answer: D,E

Question 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 SLAVE and MASTER instances are started with the same configured value for the option - - monitor_server_uuid.

C. The MASTER and SLAVE are grouped as one instance for monitoring.

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

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

Correct Answer: C,D

Question 3

How would you restrict a user Joe from accessing all MySQL database objects?

A. Insert Joe,s name into the mysql.user_restriction cable, and issue the FLUSH PRIVILEGES command.

B. REVOKE ALL PRIVILEGES, GRANT OPTION FROM ,joe,@,%,;

C. CREATE USER ,joe'@,0.0.0.0, SET Password=PASSWORD(,% ! %,)

D. CREATE USER , joe,@1' %' DENY ALL PRIVILEGES

E. UPDATE mysql.user SET Password=PASSWORD(,Invalid,) WHERE User=,joe';

Correct Answer: A

Question 4

Which three are requirements for MySQL Group Replication (GR)?

A. The binary log format must be set to mixed.

B. Primary keys are required on every replicated table.

C. The minimum number of required nodes for achieving a consensus is two.

D. The use of global transaction identifiers is required.

E. GR only works with MySQL versions 8.0.12 or higher.

F. Data to be replicated must be stored in the InnoDB transactional storage engine.

Correct Answer: A,B,F

Question 5

You are using the innoDB engine and the innodb_f ile_per_table option is set.
You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.
What will happen to the inventory table?

A. The table will be checked for errors and repaired.

B. The table storage space will be reduced.

C. The table will be optimized and replicated.

D. The table statistics will be stored.

Correct Answer: C

Question 6

You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?

A. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - - compress-level to select the level of compression.

B. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.

C. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.

D. Use mysqldump with the - -changesonly option.

E. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.

Correct Answer: A,D

Question 7

Which two statements are true about MySQL Enterprise Authentication?

A. MySQL Enterprise Edition automatically connects to Oracle Password Vault to verify user passwords..

B. MySQL Enterprise Authentication determines what operation the user can perform.

C. MySQL Enterprise Authentication supports Linux Pluggable Authentication Modules (PAM).

D. MySQL Enterprise Authentication supports Windows Active Directory.

E. MySQL Enterprise Authentication makes it more difficult to set up security because you have different sets of security policies.

Correct Answer: C,D

Question 8

Which three statements describe MySQL Enterprise Backup?

A. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.

B. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.

C. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.

D. MySQL Enterprise Backup provides the point-in-time recovery functionality.

E. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.

Correct Answer: A,B,D

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

Latest Update

Useful Links

Contact Us