Why managed databases matter in AWS - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a managed database instance in AWS.

AWS

resource "aws_db_instance" "mydb" {
  allocated_storage = 20
  engine           = "mysql"
  instance_class   = "[1]"
  db_name          = "mydatabase"
  username         = "admin"
  password         = "password123"
  parameter_group_name = "default.mysql5.7"
}

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

Adb.m5.large

Bt2.micro

Cdb.t2.micro

Dm5.large

Attempts:

3 left

💡 Hint

Common Mistakes

Using instance types without the 'db.' prefix.

Choosing instance classes that don't exist in RDS.

The instance_class must specify a valid AWS RDS instance type like db.m5.large for managed databases.

2fill in blank

medium

Complete the code to enable automatic backups for the managed database.

AWS

resource "aws_db_instance" "mydb" {
  allocated_storage    = 20
  engine              = "mysql"
  instance_class      = "db.m5.large"
  db_name             = "mydatabase"
  username            = "admin"
  password            = "password123"
  backup_retention_period = [1]
}

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

A0

B30

C-1

D7

Attempts:

3 left

💡 Hint

Common Mistakes

Setting backup retention to 0 disables backups.

Using negative numbers is invalid.

The backup_retention_period sets how many days backups are kept. Setting it to 7 enables automatic backups for one week.

3fill in blank

hard

Fix the error in the code to enable Multi-AZ deployment for high availability.

AWS

resource "aws_db_instance" "mydb" {
  allocated_storage    = 20
  engine              = "mysql"
  instance_class      = "db.m5.large"
  db_name             = "mydatabase"
  username            = "admin"
  password            = "password123"
  multi_az            = [1]
}

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

A"false"

B"true"

Ctrue

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around boolean values causes errors.

Using numbers instead of booleans is invalid.

The multi_az attribute expects a boolean value true or false, not a string.

4fill in blank

hard

Fill both blanks to configure the database to be publicly accessible and set the storage type.

AWS

resource "aws_db_instance" "mydb" {
  allocated_storage    = 20
  engine              = "mysql"
  instance_class      = "db.m5.large"
  publicly_accessible = [1]
  storage_type        = "[2]"
  username            = "admin"
  password            = "password123"
}

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

Atrue

Bfalse

Cgp2

Dstandard

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'false' for public access when external access is needed.

Choosing 'standard' storage which is slower.

Setting publicly_accessible to true allows access from outside the VPC. The storage_type gp2 is a common SSD storage type for better performance.

5fill in blank

hard

Fill all three blanks to configure the database with encryption, backup window, and maintenance window.

AWS

resource "aws_db_instance" "mydb" {
  allocated_storage       = 20
  engine                 = "mysql"
  instance_class         = "db.m5.large"
  storage_encrypted      = [1]
  backup_window          = "[2]"
  maintenance_window     = "[3]"
  username               = "admin"
  password               = "password123"
}

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

Atrue

B03:00-04:00

Csun:05:00-sun:06:00

Dfalse

Attempts:

3 left

💡 Hint

Common Mistakes

Using false for encryption when security is required.

Incorrect time format for windows causes errors.

Enabling storage_encrypted with true secures data at rest. The backup_window and maintenance_window specify times in UTC when backups and maintenance occur, respectively.