MySQL 8.0 Database Administrator — Question 52

Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

Answer options

• A. The redo logs are backed up first, then the transaction and archive tables.
• B. The redo logs are backed up only if there are changes showing for the transactions tables.
• C. The redo logs are not backed up at all.
• D. The archive tables are backed up first, then the transaction tables and redo logs.
• E. The transaction tables are backed up first, then the archive tables and redo logs.

Correct answer: B

Explanation

The correct answer is B because redo logs are typically backed up only when there are actual changes in the associated transaction tables, ensuring that only necessary data is processed. Options A and D incorrectly suggest that redo logs are backed up before or in conjunction with other tables without considering changes, while C erroneously states that redo logs are not backed up at all. Option E misrepresents the order of backup operations.