MySQL 8.0 Database Administrator — Question 17

Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

Answer options

• A. It supports only non-blob datatypes.
• B. It does not support the transportable tablespaces feature.
• C. It supports all indexes transparently.
• D. It decrypts data for use in memory.
• E. It enforces encryption from disk to memory and over network transmission.

Correct answer: C, D

Explanation

Answer C is correct because InnoDB data-at-rest encryption does indeed support all indexes transparently. Answer D is also correct as it specifies that data is decrypted for use in memory. Options A and B are incorrect since InnoDB supports blob datatypes and does support transportable tablespaces. Option E is misleading as it implies encryption is enforced during network transmission, which is not a feature of data-at-rest encryption.