MySQL 8.0 Database Administrator — Question 58

Which two statements are true about the mysqld-auto.cnf file? (Choose two.)

Answer options

• A. This file is for storing MySQL Server configuration options in ISON format.
• B. This file is for logging purposes only and is never processed.
• C. It is read and processed at the beginning of startup configuration.
• D. It is read and processed at the end of startup configuration.
• E. It is always updated with changes to system variables.
• F. This file is for storing MySQL server_uuid values only.

Correct answer: D, E

Explanation

The correct answers are D and E because the mysqld-auto.cnf file is processed at the end of the startup configuration, allowing it to capture the final state of system variables. Options A, B, C, and F are incorrect as they misrepresent the purpose and handling of the mysqld-auto.cnf file.