01. MySQL Enterprise Audit is enabled, but a review finds that connections from one application account do not appear in the audit log while other accounts do.
What should be examined first?
a) The filter that determines which events are written for that account
b) Whether that application connects through a different network path
c) Whether the audit log has reached its configured size limit
d) Whether the account holds the privilege required to be audited
02. After a planned primary switch in an InnoDB Cluster, one application continues to send writes to the former primary and receives errors, while other applications recover automatically.
What distinguishes that application?
a) It uses a different storage engine for its tables rather than the one the cluster requires
b) It was connected before the switch, and existing sessions are never redirected
c) Its account lost the write privilege during the switch
d) It connects to a member directly rather than through MySQL Router
03. Why can MySQL Enterprise Backup produce a consistent backup while transactions continue to commit?
a) It copies only tables that have no open transactions against them
b) It relies on crash recovery to repair the files after they are restored
c) It takes a consistent point in the data files and tracks the changes occurring during the copy
d) It locks the whole server for the copy, and releases it when the files are written
04. In the two-tier key hierarchy used by MySQL Enterprise Transparent Data Encryption, where is the master key held?
a) Outside the database, in a keyring
b) In the option file the server reads at startup
c) Inside the encrypted tablespace, alongside the data it protects
d) In the data dictionary alongside the table metadata
05. What does initializing a MySQL server produce that a freshly extracted set of binaries does not yet have?
a) The binary log, which the server uses for replication and for recovery
b) A prepared data directory containing the system tablespace and data dictionary
c) The option file the server will read at startup
d) The service definition that starts the server at boot
06. On a replica, the received events are up to date with the source but the data lags well behind.
Which thread is the bottleneck?
a) The binary log dump thread on the source
b) The I/O receiver thread
c) The connection handler on the replica
d) The SQL applier thread
07. Which MySQL Enterprise product blocks statements that do not match the patterns learned for an account?
a) MySQL Enterprise Monitor
b) MySQL Enterprise Authentication
c) MySQL Enterprise Firewall
d) MySQL Enterprise Audit
08. Reporting must draw on data from six regional MySQL servers, consolidated onto one server.
Which topology fits?
a) Multi-source replication into a single replica
b) Circular replication linking all six servers
c) Source–replica replication from one of the six
d) Group Replication across all six servers
09. An inner join between two tables silently omits rows the team expected to see. The join column permits nulls, and the missing rows are exactly those where it is null.
What explains the omission?
a) The inner join silently converted itself to a filtered outer join
b) A null does not match any value, so those rows find no partner
c) Null values are excluded from the index, so the rows are never examined
d) The two columns use different data types and cannot be compared
10. Transparent Data Encryption protects a set of tablespaces. A database administrator with full privileges reads the sensitive columns without difficulty.
Why does encryption not prevent this?
a) The tablespaces were encrypted without the keyring, so nothing can decrypt them
b) The administrator holds the master key, which grants read access to the data
c) It protects the data at rest, and an authorized session is served decrypted values
d) Encryption applies only to newly written rows, not to existing data
The Oracle MySQL Implementation Associate (1Z0-922) Sample Question Set is designed to help you prepare for the Oracle MySQL Implementation Certified Associate certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-922 Certification Practice Exam.
