Courseiva
Incident and Event ResponsemediumMultiple SelectObjective-mapped

DOP-C02 Incident and Event Response Practice Question

A DevOps team is investigating a production incident where an Amazon RDS for MySQL database experienced a sudden spike in connections and CPU utilization. The team suspects a SQL injection attack. Which TWO actions should the team take to investigate and mitigate the incident?

⚠ Common exam trap

A common mix-up: candidates confuse reactive scaling (Option E) or read replicas (Option D) with proper incident response, failing to recognize that investigation and mitigation require enabling logging and backup capabilities, not just increasing capacity.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

Enable automated backups and ensure point-in-time recovery is configured.

Enabling automated backups and point-in-time recovery ensures that the database can be restored to a state before the suspected SQL injection attack, preserving data integrity and enabling forensic analysis. Option C is correct because RDS Enhanced Monitoring provides OS-level metrics (CPU, memory, disk I/O) to correlate with the spike, while audit logs capture actual SQL queries, which are essential for identifying malicious patterns and confirming the attack vector.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Delete the error logs to free up storage space.

    Why it's wrong here

    Deleting the error logs to free up storage space is counterproductive during an incident investigation. RDS error logs contain critical forensic data such as failed connection attempts, authentication failures, and database engine errors that help identify the attack vector or root cause. Removing them destroys potential evidence and violates standard incident response procedures, while the underlying storage issue should be addressed by scaling storage or exporting logs to Amazon S3.

  • Enable automated backups and ensure point-in-time recovery is configured.

    Why this is correct

    Enabling automated backups with point-in-time recovery (PITR) is the correct immediate response because it lets you restore the database to any second within the retention window, such as a timestamp just before the compromise occurred. Automated backups take daily snapshots, and RDS continuously records transaction logs to enable PITR, minimizing data loss if tables were dropped or data was tampered with. This is the foundational recovery mechanism to return the system to a known-good state.

  • Enable RDS Enhanced Monitoring and audit logs to capture SQL queries.

    Why this is correct

    Enabling RDS Enhanced Monitoring and audit logs is also correct for the investigation phase. Enhanced Monitoring provides OS-level metrics like CPU, memory, file I/O, and network traffic, helping you spot anomalous behavior or resource spikes during the incident window. Audit logs capture every SQL statement and login attempt, giving you a record of exactly what queries were executed and by which account, which is essential for post-incident forensics and identifying the attacker's actions.

  • Create a read replica to offload traffic from the primary instance.

    Why it's wrong here

    Creating a read replica does not help address a security incident because a read replica only offloads read traffic and does not enhance data integrity, traceability, or recovery. Worse, if the primary instance is compromised, replication can propagate malicious changes or triggers to the replica. It would neither identify the attack source nor prevent data loss, so it is an inappropriate response.

  • Increase the DB instance size to handle the increased load.

    Why it's wrong here

    Increasing the DB instance size to handle the increased load is irrelevant to the underlying security incident. Vertical scaling addresses performance and capacity constraints, but if the incident involves unauthorized access, data corruption, or malicious queries, adding CPU or memory will not resolve the root cause and may temporarily mask symptoms while leaving the attack unmitigated. This action also incurs cost without contributing to forensic analysis or recovery.

About these practice questions

One of 251 original DOP-C02 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This DOP-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DOP-C02 exam.