MySQL 8.0 Database Administrator — Question 70

You made some table definition changes to a schema in your MySQL Server.
Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

Answer options

• A. MySQL writes SDI to the binary log for distributed backups.
• B. MySQL keeps InnoDB metadata changes in .sdi files in datadir.
• C. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).
• D. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.
• E. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

Correct answer: C, D

Explanation

The correct answers, C and D, accurately describe how MySQL handles metadata changes by serializing it in JSON format as SDI and storing a copy in the InnoDB user tablespace. Options A, B, and E are incorrect because they either misrepresent how MySQL logs or stores metadata changes, or suggest operations not performed in this context.