MySQL 8.0 Database Administrator — Question 57

Which two statements are true about the binary log encryption feature? (Choose two.)

Answer options

• A. It encrypts any connecting slaves connection thread.
• B. It can be set at run time.
• C. It requires a keyring plugin.
• D. When enabled it encrypts existing binary logs.
• E. It can be activated per session.

Correct answer: A, E

Explanation

Option A is correct because binary log encryption does indeed secure the connection threads of any slaves connecting to the master. Option E is also correct as the feature can be activated for individual sessions. Options B, C, and D are incorrect because they misrepresent how the binary log encryption feature operates; it cannot be set at runtime, does not require a keyring plugin, and does not encrypt existing logs retroactively.