1Z0-908 practice question 12 of 25
Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?
Full set: 140 questionsMySQL Enterprise Transparent Data Encryption (TDE) utilizes a two-tier key architecture, comprising a master encryption key and tablespace keys. The master encryption key is managed by a component called a keyring. MySQL provides various keyring plugins to manage this master key. Several of these plugins, such as keyringokv for Oracle Key Vault, keyringaws for Amazon Web Services Key Management Service, and keyringhashicorp for HashiCorp Vault, are specifically designed to store the master key in a secure, centralized key management system, separate from the database server. This is a core feature of an enterprise-grade TDE implementation.
B. TDE is a feature exclusive to the InnoDB storage engine; it does not support MyISAM tables. Additionally, keyringengine is not a valid configuration variable.
C. Tablespace keys cannot be "regenerated." They are created once and stored in the tablespace header. If the master key is lost, the tablespace keys cannot be decrypted, rendering the data permanently unrecoverable.
D. TDE for individual tables requires that the innodbfilepertable option is enabled, meaning tables are stored in their own tablespaces, not the system tablespace.
1. MySQL 8.0 Reference Manual, Section 15.13, "InnoDB Data-at-Rest Encryption": This section provides the overview of the TDE architecture. It states, "InnoDB data-at-rest encryption uses a two-tier encryption key architecture, consisting of a master encryption key and tablespace keys. The master encryption key is stored in a keyring."
2. MySQL 8.0 Reference Manual, Section 6.4.4, "The MySQL Keyring": This section details the keyring plugin infrastructure. It lists several plugins, including keyringokv, keyringaws, and keyringhashicorp, which are used for connecting to centralized key management solutions. This supports the correctness of option A.
3. MySQL 8.0 Reference Manual, Section 15.13.1, "Encryption Prerequisites": This page explicitly states, "Data-at-rest encryption is only supported for InnoDB tables stored in file-per-table tablespaces." This directly refutes options B and D.
4. MySQL 8.0 Reference Manual, Section 15.13.2, "Encryption and Recovery": This section clarifies the recovery process, stating, "You are responsible for managing the master encryption key. If the master encryption key is lost, the encrypted tablespace data is unrecoverable." This refutes the claim in option C that keys can be regenerated.
Keep practicing
Take the free 1Z0-908 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-908 practice questions
- Question 2You must run multiple instances of MySQL Server on a single host. Which three methods are…
- Question 3Which two tools are available to monitor the global status of InnoDB locking? (Choose two…
- Question 4Which two MySQL Server accounts are locked by default? (Choose two.)
- Question 5All MySQL Server instances belonging to InnoDB Cluster have SSL configured and enabled. Y…
- Question 6t is a non-empty InnoDB table. Examine these statements, which are executed in one sessio…
- Question 8Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostnam…
