Courseiva
← DBS-C01
Full test
Management and Operations →hardMultiple ChoiceObjective-mapped

DBS-C01 Management and Operations Practice Question

Exhibit

Refer to the exhibit. A database specialist receives the following Amazon CloudWatch Logs excerpt from an Amazon RDS for MySQL DB instance:

2024-11-15 10:23:45 UTC [ERROR] [MY-013118] [InnoDB] Page [page id: space=5, page number=1234] log sequence number 567890 is in the future! Current system log sequence number 567800.
2024-11-15 10:23:46 UTC [ERROR] [MY-011825] [InnoDB] Unable to purge a record because it is in a non-tablespace page.
2024-11-15 10:24:01 UTC [ERROR] [MY-013114] [InnoDB] Database page corruption on disk or a failed file read of page [page id: space=5, page number=1235]. You may have to recover from a backup.

A database specialist sees the above error log entries from an Amazon RDS for MySQL DB instance. Which action should be taken to resolve the issue?

⚠ Common exam trap

A common mix-up: candidates confuse table-level repair commands (like mysqlcheck or REPAIR TABLE) with the need for a full database restore, not realizing that InnoDB corruption typically requires point-in-time recovery from a backup rather than a simple repair operation.

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

✓

Restore the DB instance from the latest automated snapshot.

The error log entries indicate corruption in the InnoDB tablespace, likely due to a crash or hardware failure. Restoring from the latest automated snapshot is the correct action because it provides a consistent, point-in-time recovery of the entire database, including all table structures and data, without relying on potentially corrupted files. This approach ensures data integrity and avoids further damage that could occur from attempting repairs on a corrupted instance.

Answer analysis

Option-by-option breakdown

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

  • ✗

    Increase the allocated storage for the DB instance.

    Why it's wrong here

    Incorrect: Storage size does not fix logical corruption.

  • ✓

    Restore the DB instance from the latest automated snapshot.

    Why this is correct

    Correct: Restoring from a clean snapshot is the standard recovery method for page corruption.

  • ✗

    Reboot the DB instance to clear the error.

    Why it's wrong here

    Incorrect: Reboot will not fix page corruption; the error will reoccur.

  • ✗

    Run the mysqlcheck command to repair the corrupted tables.

    Why it's wrong here

    Incorrect: RDS does not provide shell access; mysqlcheck cannot be run directly.

Visual reference

Client Recursive Resolver Root DNS (13 root servers) TLD DNS (.com, .org, …) Authoritative example.com query IP addr answer

About these practice questions

One of 1,663 original DBS-C01 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 DBS-C01 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 DBS-C01 exam.