MySQL 8.0 Database Administrator — Question 1

Which two are features of MySQL Enterprise Firewall? (Choose two.)

Answer options

• A. recording incoming SQL statement to facilitate the creation of a whitelist of permitted commands
• B. blocking of potential threats by configuring pre-approved whitelists
• C. modifying SQL statement dynamically with substitutions
• D. automatic locking of user accounts who break your firewall
• E. provides stateless firewall access to TCP/3306

Correct answer: A, B

Explanation

The correct answers, A and B, highlight the capabilities of MySQL Enterprise Firewall in establishing a whitelist and blocking threats. Options C, D, and E do not accurately describe the firewall's functionalities, as it does not modify SQL statements dynamically, automatically lock user accounts, or provide stateless access.