RDS

Question 1

Relational Databases in AWS

Answer 1

Oracle
SQL Server
MySql Server
Postgresql
Maria DB
Aurora

Question 2

Two key features of RDS

Answer 2

Multi-AZ for disaster recovery

Read Replicas for Performance

Question 3

Non RDS in AWS

Answer 3

Dynamo (NOSQL)

Question 4

Datawarehousing in AWS

Answer 4

Redshift is for business intelligence and data warehousing solution of AWS. (OLAP)

Question 5

Elastic Cache

Answer 5

In memory cache in the cloud,,Improves performance of web applications by allowing to retrieve infromation from a fast , managed,in-memory caches, instaed of relying entirely on slower disk-based databases.

Elastic cache supports two open source in-memory caching engines:
Mem-cached
Redis

Question 6

Manage your database user credentials through AWS IAM users and Roles

Answer 6

Enable IAM db Authentication

Question 7

Types of RDS backup

Answer 7

Automated Backup

Database snapshots

Question 8

Automated Backup in RDS

Answer 8

Automated backups allows you to recover your dtaabse to apoint in time within a rentention period.. The retention period can be between 0-35 days. Automated backups will take a full daily snapshot and also will store transaction logs through out the day.. So when you do a recovery , AWS will first choose the moset recent daily back up, and then apply transaction logs relevant to that day.

This allows you to do a point in time reccovery down to a second with in the retention period.

Automated backups are enabled by default and backups are stored in S3. and you get a free storage space equal to the size of your database.

Backups are taken within a specified window .. During the backup window , storage i/o may be suspended while your data is being backed up an dyou maay experience elevated latency.

Question 9

Database snapshots in RDS

Answer 9

initiated manually. They are stored even after you delete. you delete your original RDS instance unlike automated backups

Question 10

Restoring Backups

Answer 10

Whenever you restore either Automated backups or manual snapshot, the restored version of the database will be a new RDS instance with a new DNS endpoint.

Question 11

Encryption AT Rest

Answer 11

Encryption AT Rest is supported for MySQL, Oracle, SQL Server, PostGresql, MariaDB and Aurora.

Encryption is done using AWS Key Management Service (Kms) service.

Once your RDS instance is en

Question 12

Encryption AT Rest

Answer 12

Encryption AT Rest is supported for MySQL, Oracle, SQL Server, PostGresql, MariaDB and Aurora.

Encryption is done using AWS Key Management Service (Kms) service.

Once your RDS instance is encrypted, the data stored at rest in underlying storage are encrypted , as are its automated backups, read replicas and snapshots.

Question 13

Read Replicas

Answer 13

must have automated backups turned on in order to deploy a read replica.

You can have up to 5 read replica copies of any database

You can have read replicas of read replicas

Each read replica will ahve a DNS endpoint

You can have read replicas that have multi A-z

you can read replicas of multi-AZ source databses

Read replicas can be promoted to be their own database and this breaks replication

You can have a read replica in a second region

Question 14

Rebooting with Failover

Answer 14

You can failover a RDS instance in to a different availability zone by rebooting with failover