1Z0-908 practice question 12 of 25

Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

Full set: 140 questions
Answer options
A: MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location. Correct answer
B: Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.
C: Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.
D: TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.
Correct Answer:
A. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.
Explanation

MySQL 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.

Why Incorrect

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.

References

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.

Scroll to Top