Timedora
Free Online Flashcard Deck

2 Amazon RDS in Practice Free Online FlashCards

Study 2 Amazon RDS in Practice with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.

12 cards
01
Front

What does Amazon RDS manage, and what remains your responsibility?

Back

Amazon RDS is a managed service for running relational database engines; AWS operates much of the underlying infrastructure, while you remain responsible for choices such as schema design and access controls.

02
Front

When is RDS a better fit than DynamoDB?

Back

Choose RDS when an application needs a relational model, SQL, transactions, joins, and a supported engine. Consider DynamoDB for key-value or document access patterns rather than arbitrary relational joins.

03
Front

What is the role of a Multi-AZ DB instance standby?

Back

A Multi-AZ DB instance maintains a standby in another Availability Zone for high availability and failover. That standby does not serve application reads.

04
Front

What instances make up a Multi-AZ DB cluster?

Back

A Multi-AZ DB cluster has one writer and two reader instances across three Availability Zones, providing high availability with additional read capacity.

05
Front

Why is a read replica not equivalent to a Multi-AZ standby?

Back

Read replicas use asynchronous replication, so they can lag. They can scale reads or provide a replica in another Region, but they are not a substitute for a synchronous high-availability standby.

06
Front

What is a core network-security practice for production RDS?

Back

Keep production databases private, place them in an appropriate DB subnet group, and allow database traffic only from the application or approved administrative sources through security-group rules.

07
Front

What do database privileges control versus IAM policies?

Back

Use database users and privileges to control access to data, and IAM policies to control who can manage RDS resources.

08
Front

How can RDS data be protected at rest and in transit?

Back

Enable encryption at rest when creating the DB instance, and configure clients to use TLS to encrypt connections in transit.

09
Front

What is the main trade-off of adding a database index?

Back

Indexes can speed up reads, but consume storage and may increase the cost of inserts, updates, and deletes. Add them to address observed workloads, not speculatively.

10
Front

How should you verify that an index improves a query?

Back

Inspect query plans and actual workload behavior to determine whether an index improves performance; do not assume it helps just because it exists.

11
Front

What is the maximum automated-backup retention for an RDS DB instance?

Back

Automated backups support point-in-time recovery within the configured retention period. For DB instances, retention can be up to 35 days; setting it to zero disables automated backups.

12
Front

What happens to the DB instance when you restore a manual snapshot?

Back

Restoring a manual DB snapshot creates a new DB instance. Recovery also requires checking the restored database and directing the application to its endpoint.