RDS Flashcards Preview

AWS FAQs > RDS > Flashcards

Flashcards in RDS Deck (28):
1

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

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

2

Read Replicas utilize __________ synchronization.

Asynchronous

3

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

No.

4

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

Preferred backup window

5

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

5

6

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

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

7

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

False.

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

8

Is an RDS DB instance available during a backup window?

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.

9

Which relational database engines does Amazon RDS support?

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

10

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

False.

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

11

When is RDS magnetic storage useful?

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

12

True or False:  Automated backups are enabled by default.

True.

13

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

40

14

Maintenance windows are __________ minutes in duration.

30

15

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

Enhanced Monitoring

16

Multi-AZ deployments utilize __________ synchronization.

Synchronous

17

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

False.

Backups are taken from the standby DB instance.

18

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

For database workloads with moderate I/O requirements.

19

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

15

20

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

For high-performance OLTP workloads.

21

Read Replicas are supported by which RDS RDBMSs?

  • Aurora
  • MySQL
  • MariaDB
  • PostgreSQL

22

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

Yes.

23

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

True.

24

What is a maintenance window?

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

25

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

7 days

26

The maximum automatic backup retention period is __________.

35 days

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.

True.

28

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

True.