Read replicas for performance in AWS - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a read replica of an RDS instance.

AWS

aws rds create-db-instance-read-replica --db-instance-identifier myreadreplica --source-db-instance-identifier [1]

Drag options to blanks, or click blank then click option'

Asourceinstance

Bmyreadreplica

Creplicadb

Dmydbinstance

Attempts:

3 left

💡 Hint

Common Mistakes

Using the replica name instead of the source instance name.

Confusing the source and replica identifiers.

The --source-db-instance-identifier option specifies the original database instance to replicate. Here, it should be the source instance name.

2fill in blank

medium

Complete the code to enable automatic backups required for read replicas.

AWS

aws rds modify-db-instance --db-instance-identifier mydbinstance --backup-retention-period [1]

Drag options to blanks, or click blank then click option'

A0

B1

C30

D7

Attempts:

3 left

💡 Hint

Common Mistakes

Setting backup retention to 0 disables backups, which is invalid for read replicas.

Choosing a very high number unnecessarily.

Read replicas require automatic backups enabled. Setting --backup-retention-period to 1 or more days enables backups.

3fill in blank

hard

Fix the error in the command to describe read replicas of an RDS instance.

AWS

aws rds describe-db-instances --filters Name=read-replica-source-db-instance-identifier,Values=[1]

Drag options to blanks, or click blank then click option'

Amyreadreplica

Breplicainstance

Cmydbinstance

Dsourceinstance

Attempts:

3 left

💡 Hint

Common Mistakes

Using the replica name instead of the source instance name in the filter.

Using an incorrect filter name.

The filter read-replica-source-db-instance-identifier expects the source instance identifier to list its replicas.

4fill in blank

hard

Fill both blanks to configure a read replica with Multi-AZ deployment and a specific DB instance class.

AWS

aws rds create-db-instance-read-replica --db-instance-identifier myreadreplica --source-db-instance-identifier mydbinstance --multi-az [1] --db-instance-class [2]

Drag options to blanks, or click blank then click option'

Atrue

Bfalse

Cdb.m5.large

Ddb.t3.micro

Attempts:

3 left

💡 Hint

Common Mistakes

Setting multi-az to false when high availability is needed.

Choosing a very small instance class that may not handle load.

Setting --multi-az to true enables high availability. The --db-instance-class defines the instance size; here, db.m5.large is a common choice for performance.

5fill in blank

hard

Fill all three blanks to create a read replica with encryption enabled, in a specific availability zone, and with a custom port.

AWS

aws rds create-db-instance-read-replica --db-instance-identifier myreadreplica --source-db-instance-identifier mydbinstance --storage-encrypted [1] --availability-zone [2] --port [3]

Drag options to blanks, or click blank then click option'

Atrue

Bus-east-1a

C5432

Dfalse

Attempts:

3 left

💡 Hint

Common Mistakes

Disabling encryption when it is required.

Using an invalid availability zone name.

Setting the port to a non-standard number.

Encryption is enabled by setting --storage-encrypted to true. The availability zone specifies where the replica runs, and the port defines the database listening port.