AWS RDS Flashcards
What are the RDS database types?
There are six: SQL Server Oracle MySQL PostgreSQL MariaDB Amazon Aurora
Can a DynamoDB can be the basis of an RDS instance?
No. It isn’t a valid type.
What kind of workloads is RDS used for?
OLTP - Online Transaction Processing
RDS is great for processing lots of small transactions, like customer orders, banking transaction, payments and booking systems.
Is RDS suitable for OLAP workloads?
No. You should use Redshift for data warehousing and OLAP tasks, like analyzing large amounts of data, reporting and sales forecasting.
What are some advantages of using RDS?
- You can have an RDS instance up and running in minutes.
- Allows multi-AZ.
- Built-in failover capacity.
- Automated backups.
You avoid a manual install in your own data center which could take 8 days or longer using older, traditional methods.
Does AWS RDS handle replication for you?
Yes. AWS handles the RDS replication for you. When you write to your production database, this write will automatically synchronize to the standby database.
In RDS, can you read from the standby database?
No. The standby database is only used for replication and failover if the primary database becomes not available.
What RDS types can be configured as Multi-AZ?
SQL Server Oracle MySQL PostgreSQL MariaDB
NOTE: Amazon Aurora is automatically configured as multi-AZ and cannot be configured as a single AZ.
What RDS types cannot be configured as single AZ?
Amazon Aurora is automatically configured as multi-AZ and cannot be configured as a single AZ.
RDS will _____ _____ to the standby during a failure so database operations can resume quickly without administrative intervention.
RDS will AUTOMATICALLY FAILOVER to the standby during a failure so database operations can resume quickly without administrative intervention.
While the primary database is active, can you connect to the standby instance?
No. Multi-AZ is for discover recovery, not for improving performance, so you cannot connect to the standby when the primary database is active.
What is a Read Replica?
A read replica is a read-only copy of your primary RDS database.
What can you use to improve read performance in RDS?
Read Replicas
This service is great for read-heavy workloads and takes the load off your primary RDS database.
Read Replicas
True or False: You can use a multi-AZ setup in RDS to improve read performance of your database.
False. Multi-AZ setup in RDS is only for disaster recover. You would use read replicas to improve read performance.
Can a read replica be promoted to be their own database?
Yes.
Can replication proceed between an RDS instance and a read replica when the read replica has been promoted?
No, when a read replica is promoted, replication is broken.
When would you consider promoting a read replica?
If you wanted to do a massive analytic process against your database and didn’t want to impact the performance of the RDS instance.
True or False: You can use read replicas for disaster recovery.
False. Read replicas are used primarily for scaling, NOT disaster recovery.
True or False: You can deploy a read replica on an RDS instance that doesn’t have automated backups.
False. Automatic backups must be enabled in order to deploy a read replica.
What is an exact copy of your production database in Another Availability zone that cannot be read?
Multi-AZ
What is a read-only copy of your primary database in the same AZ, cross-AZ or cross-region?
Read Replica
This optional setup in RDS is used for disaster recovery.
Multi-AZ
This optional setup in RDS is used for increasing or scaling read performance.
Read Replica
