AWS Certified SysOps Administrator – Associate (legacy) — Question 338

A user wants to find the particular error that occurred on a certain date in the AWS MySQL RDS DB. Which of the below mentioned activities may help the user to get the data easily?

Answer options

• A. It is not possible to get the log files for MySQL RDS
• B. Find all the transaction logs and query on those records
• C. Direct the logs to the DB table and then query that table
• D. Download the log file to DynamoDB and search for the record

Correct answer: C

Explanation

Amazon RDS for MySQL allows administrators to direct log files directly to database tables, enabling them to easily search and analyze log data using standard SQL queries. Other methods, such as exporting logs to Amazon DynamoDB or parsing raw transaction logs, are either unsupported or unnecessarily complex for this task. Therefore, routing the logs to a DB table is the most efficient approach to locate a specific historical error.