1Z0-922 Sample Questions & Answers
You'll be tested on ten equally weighted areas: backups, replication and high availability, monitoring and the HeatWave cluster, privileges, users and security tooling, schema and query design, plus Enterprise Edition's own architecture and installation steps.
Launch the full 1Z0-922 simulator →Showing 6 of 12 free samples.
- Question 1Intermediate
Introduction to MySQL Enterprise Edition · Enterprise products and features
An organization requires centralized key management for its database encryption keys (TDE). Which MySQL Enterprise capability natively integrates with third-party key management solutions like Oracle Key Vault or HashiCorp Vault?
Show answer & explanation
Correct answer: B
MySQL Enterprise Edition provides advanced keyring plugins (e.g., keyring_okv, keyring_hashicorp) that allow Transparent Data Encryption (TDE) keys to be stored and managed securely in external enterprise key management appliances. The community edition only provides a basic file-based keyring.
flowchart LR MySQL[MySQL Server] Plugin[Keyring Plugin] Plugin Vault[Oracle Key Vault / HashiCorp Vault] MySQL --> TDE[Encrypted InnoDB Tablespaces] - Question 2Intermediate
MySQL Installation and Architecture · MySQL architecture
When a client application connects to a MySQL server and issues a query, the server processes it through multiple architectural layers. In which specific layer does the server perform query parsing, optimization, and execution planning?
Show answer & explanation
Correct answer: B
The SQL Layer (or logical layer) is responsible for query parsing, authorization, optimization, and execution planning. The Connection Layer handles authentication and thread management, while the Storage Engine Layer (like InnoDB) handles actual data storage and retrieval.
- Question 3Advanced
MySQL Installation and Architecture · Installation and configuration
Scenario: A database administrator is configuring a new Linux-based MySQL Enterprise Server.
The administrator creates a configuration file at
/etc/my.cnfsettingmax_connections=500. However, a developer also places a.my.cnffile in themysqluser's home directory settingmax_connections=200.When the administrator starts the mysqld service using the default systemd startup scripts, what will be the effective value of
max_connections, and why?Show answer & explanation
Correct answer: B
MySQL reads option files in a specific sequence. On Unix/Linux, it typically reads
/etc/my.cnf, then/etc/mysql/my.cnf, thenSYSCONFDIR/my.cnf, then$MYSQL_HOME/my.cnf, and finally~/.my.cnf. Because the user-specific file is read last, any conflicting variables defined there will override the values set in the global files. - Question 4Beginner
MySQL Installation and Architecture · Installation and configuration
A system administrator needs to dynamically increase the
max_connectionsvalue on a running MySQL Server without restarting the database. Which command achieves this?Show answer & explanation
Correct answer: B
The
max_connectionsvariable is a global system variable that can be changed dynamically. You must use theSET GLOBALsyntax to change it for the running server.SET SESSIONonly applies to the current connection, andmax_connectionscannot be set at the session level. - Question 5Intermediate
MySQL Installation and Architecture · MySQL architecture
Review the following core InnoDB architecture components. When a transaction modifies data in the InnoDB Buffer Pool, which component is primarily responsible for ensuring those modifications are durable even if the server crashes before the modified data pages are flushed to the data files?
flowchart TD Client --> BufferPool[InnoDB Buffer Pool] BufferPool --> |Modified Pages| DataFiles[(Data Files)] BufferPool --> |Transaction Data| ComponentX[?] ComponentX --> |Durability| Disk[(Disk)]Show answer & explanation
Correct answer: C
The Redo Log is a disk-based data structure used during crash recovery to correct data written by incomplete transactions. When data is modified in the buffer pool, the changes are written to the redo log on disk to ensure durability (the 'D' in ACID) before the actual data pages are lazily flushed to the data files.
- Question 6Beginner
Designing Databases · Datatypes and objects
A developer is designing a table to store event logs for a globally distributed application. The application requires the exact time an event occurred to be recorded, and it must automatically adjust to the time zone of the connecting client when queried. Which MySQL data type should be used for this column?
Show answer & explanation
Correct answer: B
The TIMESTAMP data type automatically converts values from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. DATETIME does not perform any time zone conversions; it stores the literal value exactly as provided.
Ready for the real thing?
The full 1Z0-922 simulator has every exam-style question, timed mode, and instant scoring.