Launching an RDS instance in AWS - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the database engine when launching an RDS instance.

AWS

aws rds create-db-instance --db-instance-identifier mydb --db-instance-class db.t2.micro --engine [1] --allocated-storage 20

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

Amysql

Bdocker

Cnginx

Dlambda

Attempts:

3 left

💡 Hint

Common Mistakes

Using unsupported engine names like 'docker' or 'nginx'.

Leaving the engine parameter empty.

The --engine parameter specifies the database engine type. For RDS, valid engines include mysql, postgres, etc. Here, mysql is correct.

2fill in blank

medium

Complete the code to specify the instance class for the RDS instance.

AWS

aws rds create-db-instance --db-instance-identifier mydb --db-instance-class [1] --engine mysql --allocated-storage 20

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

Adb.large

Bdb.t2.micro

Cec2.micro

Dlambda.small

Attempts:

3 left

💡 Hint

Common Mistakes

Using EC2 instance types instead of RDS instance classes.

Choosing instance classes that do not start with 'db.'.

The --db-instance-class parameter defines the compute and memory capacity of the RDS instance. db.t2.micro is a valid small instance class for RDS.

3fill in blank

hard

Fix the error in the command to enable public accessibility for the RDS instance.

AWS

aws rds create-db-instance --db-instance-identifier mydb --db-instance-class db.t2.micro --engine mysql --allocated-storage 20 --publicly-accessible [1]

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

Aenable

Bon

Cyes

Dtrue

Attempts:

3 left

💡 Hint

Common Mistakes

Using non-boolean words like 'enable' or 'yes' instead of 'true'.

Omitting the parameter value.

The --publicly-accessible parameter expects a boolean value: true or false. Using 'true' enables public access.

4fill in blank

hard

Fill both blanks to specify the master username and password for the RDS instance.

AWS

aws rds create-db-instance --db-instance-identifier mydb --db-instance-class db.t2.micro --engine mysql --allocated-storage 20 --master-username [1] --master-user-password [2]

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

Aadmin

Bpassword123

Croot

D123456

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping username and password values.

Using insecure or empty passwords.

The --master-username sets the admin username, commonly 'admin'. The --master-user-password sets the password, here 'password123' as an example.

5fill in blank

hard

Fill all three blanks to create an RDS instance with a specific storage type, multi-AZ deployment, and backup retention period.

AWS

aws rds create-db-instance --db-instance-identifier mydb --db-instance-class db.t2.micro --engine mysql --allocated-storage 20 --storage-type [1] --multi-az [2] --backup-retention-period [3]

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

Agp2

Btrue

C7

Dstandard

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'gp2' instead of 'standard' when 'standard' is required.

Setting 'multi-az' to a non-boolean value.

Using invalid backup retention values like zero or negative numbers.

The --storage-type can be 'standard' for magnetic storage. --multi-az expects a boolean like 'true' to enable high availability. --backup-retention-period is the number of days to keep backups, here 7 days.

Practice

1. What is the main purpose of launching an Amazon RDS instance?

easy

A. To set up a virtual private network

B. To manually configure hardware for a database

C. To create a managed cloud database quickly

D. To write application code for database access

Solution

1. Step 1: Understand RDS service purpose

   Amazon RDS is a managed service that simplifies database setup and management.

2. Step 2: Identify the main benefit

   It allows quick creation of cloud databases without manual hardware setup.

3. Final Answer:

   To create a managed cloud database quickly -> Option C

4. Quick Check:

   RDS = managed cloud database creation [OK]

Hint: RDS means managed database, not manual hardware setup [OK]

Common Mistakes:

• Confusing RDS with manual server setup
• Thinking RDS is for network configuration
• Assuming RDS is for writing application code

2. Which of the following is a required parameter when launching an RDS instance using AWS Console?

easy

A. Database engine type (e.g., MySQL, PostgreSQL)

B. Operating system version of the server

C. IP address of the client machine

D. Number of application users

Solution

1. Step 1: Identify launch parameters for RDS

   When launching RDS, you must choose the database engine type like MySQL or PostgreSQL.

2. Step 2: Exclude unrelated parameters

   Operating system, client IP, or app users are not required inputs for RDS launch.

3. Final Answer:

   Database engine type (e.g., MySQL, PostgreSQL) -> Option A

4. Quick Check:

   Engine type is mandatory for RDS launch [OK]

Hint: Pick the database engine type, not unrelated details [OK]

Common Mistakes:

• Confusing OS version with database engine
• Providing client IP instead of DB settings
• Thinking user count is a launch parameter

3. Consider this AWS CLI command snippet to launch an RDS instance:

aws rds create-db-instance --db-instance-identifier mydb --db-instance-class db.t3.micro --engine mysql --master-username admin --master-user-password Pass1234 --allocated-storage 20

What will be the allocated storage size of the created RDS instance?

medium

A. Not specified, default used

B. 10 GB

C. 100 GB

D. 20 GB

Solution

1. Step 1: Locate storage parameter in command

   The parameter --allocated-storage 20 sets storage size to 20 GB.

2. Step 2: Confirm no other storage size overrides

   No other storage size is specified, so 20 GB is used.

3. Final Answer:

   20 GB -> Option D

4. Quick Check:

   Allocated storage = 20 GB [OK]

Hint: Look for --allocated-storage value in command [OK]

Common Mistakes:

• Assuming default storage without checking parameter
• Confusing instance class with storage size
• Ignoring the explicit storage size given

4. You tried launching an RDS instance but got an error: "InvalidParameterCombination: Storage size must be at least 20 GB for db.t3.micro". Your command was:

aws rds create-db-instance --db-instance-identifier testdb --db-instance-class db.t3.micro --engine postgres --master-username admin --master-user-password Pass1234 --allocated-storage 10

What is the cause of the error?

medium

A. Allocated storage size is below the minimum for the instance class

B. Master username is invalid

C. Engine type postgres is not supported

D. DB instance identifier is missing

Solution

1. Step 1: Analyze error message details

   The error says storage must be at least 20 GB for db.t3.micro, but 10 GB was given.

2. Step 2: Check command parameters

   The command uses --allocated-storage 10, which is too small for this instance class.

3. Final Answer:

   Allocated storage size is below the minimum for the instance class -> Option A

4. Quick Check:

   Storage size too small causes error [OK]

Hint: Check minimum storage size for instance class [OK]

Common Mistakes:

• Ignoring minimum storage requirements
• Blaming username or engine type incorrectly
• Missing required parameters in command

5. You want to launch an RDS instance with automatic backups enabled and a backup retention period of 7 days. Which configuration option should you set during launch to achieve this?

hard

A. Set MultiAZ to true

B. Set BackupRetentionPeriod to 7 and enable automatic backups

C. Set StorageEncrypted to true

D. Set PubliclyAccessible to true

Solution

1. Step 1: Identify backup settings for RDS

   Automatic backups require enabling backups and setting the retention period.

2. Step 2: Match configuration options

   BackupRetentionPeriod controls how many days backups are kept; enabling backups is necessary.

3. Step 3: Exclude unrelated options

   MultiAZ is for high availability, StorageEncrypted for encryption, and PubliclyAccessible for network access.

4. Final Answer:

   Set BackupRetentionPeriod to 7 and enable automatic backups -> Option B

5. Quick Check:

   BackupRetentionPeriod = 7 enables 7-day backups [OK]

Hint: BackupRetentionPeriod sets days for automatic backups [OK]

Common Mistakes:

• Confusing backup with MultiAZ or encryption settings
• Not enabling backups explicitly
• Setting unrelated network options