MySQL 8.0 Database Administrator — Question 117

You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

Answer options

• A. ibbackup files
• B. *.CSM files
• C. *.sdi files
• D. *.ibd files
• E. ib_logfile* files

Correct answer: D, E

Explanation

The correct answers are D and E because *.ibd files contain the actual InnoDB table data, and ib_logfile* files are the transaction logs necessary for recovery. Options A, B, and C do not pertain to the primary files necessary for a complete backup of InnoDB data.