Courseiva
Data Store Management →hardMultiple Choice

DEA-C01 Data Store Management Practice Question

Network Topology
aws rds describe-db-instancesdb-instance-identifier mydbquery 'DBInstances[0].[Engineoutput textRefer to the exhibit.Output:mysql available False None

Refer to the exhibit. A data engineer ran the CLI command to check the configuration of an RDS instance named 'mydb'. Which statement accurately describes the current configuration?

⚠ Common exam trap

AWS often tests the misconception that a database with 'available' status must be a read replica or Multi-AZ, but the absence of the 'ReadReplicaSourceDBInstanceIdentifier' and 'MultiAZ: False' clearly identify it as a standalone Single-AZ instance.

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

✓

The database is a Single-AZ deployment and is not a read replica

The CLI command output shows 'DBInstanceStatus: available' and 'MultiAZ: False', indicating the database is running as a Single-AZ deployment. Additionally, the absence of a 'SourceDBInstanceIdentifier' field confirms it is not a read replica. The 'ReadReplicaSourceDBInstanceIdentifier' is not present, which would be required if it were a read replica.

Answer analysis

Option-by-option breakdown

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

  • ✗

    The database is in the 'stopped' state

    Why it's wrong here

    The CLI output shows the instance as available, not stopped, so this contradicts the exhibit. Stopped is correct only when DBInstanceStatus reports 'stopped', which occurs after deliberately halting an instance; the displayed status field indicates the database is running normally.

  • ✓

    The database is a Single-AZ deployment and is not a read replica

    Why this is correct

    The CLI output shows no MultiAZ or ReadReplica fields, confirming a standalone Single-AZ instance. This satisfies the stem's requirement to describe the current configuration accurately: the database runs in one Availability Zone with no read replica, so it offers no automatic failover or read scaling.

  • ✗

    The database is a read replica of another instance

    Why it's wrong here

    The exhibit shows no read-replica configuration, such as a SourceDBInstanceIdentifier or replica status, so this misreads the output. Read replicas are the right answer when the CLI output names a source instance and shows asynchronous replication; the displayed fields instead describe the primary instance's own settings.

  • ✗

    The database is a Multi-AZ deployment

    Why it's wrong here

    The exhibit lists a single Availability Zone with no secondary standby, so Multi-AZ is unsupported. Multi-AZ applies when the output shows MultiAZ set to true and paired AZ identifiers; here the configuration reflects a single-AZ instance, meaning no synchronous standby replica exists.

About these practice questions

Courseiva writes every DEA-C01 question from scratch — 1,321 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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 DEA-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 DEA-C01 exam.