RDS

Question 1

What events would cause RDS to initiate a failover to the standby DB in a Multi-AZ deployment?

Answer 1

• Loss of availability in primary AZ
• Loss of network connectivity to primary
• Compute unit failure on primary
• Storage failure on primary

Question 2

Read Replicas utilize __________ synchronization.

Answer 2

Asynchronous

Question 3

Can DB Snapshots or automated backups be taken of Read Replicas?

Answer 3

No.

Question 4

The user-defined period of time during which your DB instance is backed up is called the __________.

Answer 4

Preferred backup window

Question 5

RDS for MySQL, MariaDB, and PostgreSQL allow you to create up to __________ Read Replicas for a given source DB instance.

Answer 5

5

Question 6

Can I encrypt connections between my application and my DB instance using SSL?

Answer 6

Yes, if you’re using MySQL, MariaDB, SQL Server, PostgreSQL, or Oracle.

Question 7

True or False: Automatic backups need not be enabled on a DB instance before I can create Read Replicas.

Answer 7

False.

You cannot create Read Replicas without enabling automated backups on the primary.

Question 8

Is an RDS DB instance available during a backup window?

Answer 8

Yes, but during the backup window, storage I/O may be briefly suspended while the backup process initializes. You may experience a period of elevated latency.

Question 9

Which relational database engines does Amazon RDS support?

Answer 9

• Aurora
• MySQL
• MariaDB
• Oracle
• SQL Server
• PostgreSQL

Question 10

True or False: DB Snapshots are deleted when you delete the DB instance.

Answer 10

False.

DB Snapshots persist after you delete the DB instance. Automated backups are automatically deleted though.

Question 11

When is RDS magnetic storage useful?

Answer 11

For small database workloads where data is accessed less frequently. Not recommended for Production DB instances!

Question 12

True or False: Automated backups are enabled by default.

Answer 12

True.

Question 13

By default, customers are allowed to have up to a total of __________ RDS DB instances.

Answer 13

40

Question 14

Maintenance windows are __________ minutes in duration.

Answer 14

30

Question 15

__________ provides access to over 50 CPU, memory, file system, and disk I/O metrics.

Answer 15

Enhanced Monitoring

Question 16

Multi-AZ deployments utilize __________ synchronization.

Answer 16

Synchronous

Question 17

True or False: Users will experience I/O suspension for Multi-AZ DB deployments during a backup window.

Answer 17

False.

Backups are taken from the standby DB instance.

Question 18

When should you choose to use the RDS General Purpose (SSD) storage option?

Answer 18

For database workloads with moderate I/O requirements.

Question 19

Aurora allows you to create up to __________ Read Replicas for a given DB Cluster.

Answer 19

15

Question 20

When should you choose to use the RDS Provisioned IOPS (SSD) storage option?

Answer 20

For high-performance OLTP workloads.

Question 21

Read Replicas are supported by which RDS RDBMSs?

Answer 21

• Aurora
• MySQL
• MariaDB
• PostgreSQL

Question 22

Can I promote my Read Replica into a “standalone” DB instance?

Answer 22

Yes.

Question 23

True or False: RDS supports cross-region Read Replicas.

Answer 23

True.

Question 24

What is a maintenance window?

Answer 24

Your opportunity to control when DB instance modifications and software patching occur.

Question 25

The automatic backup retention period is set to __________ by default.

Answer 25

7 days

Question 26

The maximum automatic backup retention period is __________.

Answer 26

35 days

Question 27

True or False: When you perform a restore operation to a point in time or from a DB Snapshot, a new DB instance is created with a new endpoint.

Answer 27

True.

Question 28

True or False: You can use Multi-AZ and Read Replicas in conjunction.

Answer 28

True.