MySQL 8.0 Database Administrator — Question 43

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

Answer options

• A. recording the order in which queries are issued
• B. audit of all queries
• C. point-in-time recovery
• D. replication
• E. logging the duration and locks for all queries

Correct answer: C, D

Explanation

The correct answers are C and D because binary logs are crucial for point-in-time recovery, allowing restoration of the database to a specific moment, and for replication, which enables data to be synchronized across multiple MySQL instances. Options A, B, and E are not valid uses since binary logs do not inherently serve as an audit log nor track query performance metrics.