Day 12: RDS

Amazon RDS supports the following databases, EXCEPT:

• MongoDB
• MySQL
• MariaDB
• SQL Server
• Postgresql

You're planning for a new solution that requires a MySQL database that must be available even in case of a disaster in one of the AZs. What should you use?

• Create Read Replicas
• Enable Encryption
• Enable Multi AZ
• Take Snapshots

We have an RDS database that struggles to keep up with the demand of requests from our website. Our million users mostly read news, and we don't post news very often. Which solution is adapted to this problem?

• Create Read Replicas
• Enable Encryption
• Enable Multi AZ
• Take Snapshots

You have set up read replicas on your RDS database, but users are complaining that upon updating their social media posts, they do not see their updated posts right away. What is a possible cause for this?

• Your application have bugs
• Read Replicas are asynchronous
• You should setup Multi AZ instead
• Cooldown period in ASG

Applications must update the connection string to leverage ___

• Read Replicas
• Encryption
• Multi AZ
• Snapshots

An analytics application is currently performing its queries against your main production RDS database. These queries run at any time of the day and slow down the RDS database which impacts your users' experience. What should you do to improve the users' experience?

• Setup Read Replica
• Setup Multi AZ
• Run analytics at night

Your company has a production Node.js application that is using RDS MySQL 5.6 as its database. A new application programmed in Java will perform some heavy analytics workload to create a dashboard on a regular hourly basis. What is the most cost-effective solution you can implement to minimize disruption for the main application?

• Enable Multi AZ and run analytics on the standby database
• Create a Read Replica in different AZ and run analytics on the replica database
• Create a Read Replica in different AZ and run analytics on the source database

You would like to create a disaster recovery strategy for your RDS PostgreSQL database so that in case of a regional outage the database can be quickly made available for both read and write workloads in another AWS Region. The DR database must be highly available. What do you recommend?

• Enable Multi_region on the main database
• Create a Read Replica in same region and enable Multi-AZ on the main database
• Create a Read Replica in same region and enable Multi-AZ on the replica
• Create a Read Replica in different region and enable Multi-AZ on the replica

Read Replica is ___ and Multi-AZ is ___

• asynchronous, synchronous
• asynchronous, asynchronous
• synchronous, asynchronous
• synchronous, synchronous

How do you encrypt an unencrypted RDS DB instance?

• Do it straight from Console, select RDS DB instance, choose Actions then Encrypt using KMS
• Do it straight from Console, safter stopping the RDS DB instance
• You can only do it through CLI
• You can only do it through CLI