DBS-C01 Management and Operations Practice Question

Exhibit

Refer to the exhibit.

-- AWS CLI command output for describe-db-instances:

{
  "DBInstances": [
    {
      "DBInstanceIdentifier": "prod-db",
      "Engine": "mysql",
      "DBInstanceStatus": "available",
      "StorageEncrypted": false,
      "BackupRetentionPeriod": 7,
      "PreferredBackupWindow": "05:00-06:00",
      "LatestRestorableTime": "2023-03-15T04:30:00Z"
    }
  ]
}

Refer to the exhibit. A DBA is checking the backup configuration of an RDS MySQL instance. The current time is 2023-03-15T06:00:00Z. What is the most recent point to which the database can be restored?

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

✓

2023-03-15T04:30:00Z

The latest restorable time is 2023-03-15T04:30:00Z, which is within the backup window. Option A is incorrect because 2023-03-15T03:00:00Z is earlier than the latest restorable time, so it is not the most recent point. Option B is incorrect because 2023-03-15T05:30:00Z is later than the latest restorable time, so it is not within the backup window. Option D is incorrect because although the backup window ends at 06:00, the latest restorable time is 04:30, not 06:00.

Answer analysis

Option-by-option breakdown

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

✗
2023-03-15T03:00:00Z
Why it's wrong here
This is earlier than the latest restorable time.
✗
2023-03-15T05:30:00Z
Why it's wrong here
This time is after the latest restorable time of 04:30.
✓
2023-03-15T04:30:00Z
Why this is correct
This is the latest restorable time shown.
✗
2023-03-15T06:00:00Z
Why it's wrong here
The backup window ends at 06:00, but latest restorable time is 04:30.

Go deeper

1 more way this is tested on DBS-C01

These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.

Variation 1. Which THREE factors should be considered when selecting the backup strategy for an Amazon RDS for PostgreSQL DB instance? (Choose 3.)

hard

✓ A.The backup retention period
✓ B.The Recovery Point Objective (RPO) requirement
✓ C.The impact of the backup window on database performance
D.The need for Multi-AZ deployment
E.The encryption at rest requirement

Why A: The backup retention period directly determines how far back you can perform a point-in-time recovery (PITR) for an RDS for PostgreSQL instance. Amazon RDS stores automated backups and transaction logs for the specified retention period (1 to 35 days), and this period must be aligned with your compliance and operational requirements. Choosing an appropriate retention period is a fundamental factor in defining the backup strategy.

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.

DBS-C01 Management and Operations Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question

1 more way this is tested on DBS-C01