AWS Databases

Question 1

What AWS Service should you use when you require Full control over instance and database, or
Preferred DB not available under RDS

Answer 1

Database on EC2

Question 2

What AWS Service should you use when you require traditional relational database for OLTP or
Your data is well-formed and structured
Existing applications requiring RDBMS

Answer 2

Amazon RDS

Question 3

What AWS Service should you use when you have Name/value pair data, Unpredictable data structure,
In-memory performance with persistence,
High I/O needs, or
Require dynamic scaling

Answer 3

Amazon Dynamo DB

Question 4

What AWS Service is most appropriate for:
Data warehouse for large volumes of aggregated data, or
Primarily OLAP workloads

Answer 4

Amazon Redshift

Question 5

What AWS service is most appropriate for:
Fast temporary storage for small amounts of data, and/or
Highly volatile data (non-persistent)

Answer 5

Amazon ElastiCache

Question 6

What AWS service is most appropriate for:
Binary large objects (BLOBs), and/or
Static websites

Answer 6

Amazon S3

Question 7

What are Relational Databases also known as?

Answer 7

Structured Query Language (SQL) databases

Question 8

What are non-relational dabases also known as?

Answer 8

Non-Sql databases

Question 9

True or False? RDS is an Online Transaction Processing (OLTP) type of database.

Answer 9

True

Question 10

What are the 6 database engines that Amazon RDS associates with?

Answer 10

1) My Sql Server
2) Oracle
3) MariaDB
4) PostGres Sql
5) Amazon Aurora
6) Sql Server

Question 11

RDS services include what?

Answer 11

1) Security and patching of the DB Instance
2) Automated backup for the DB Instance
3) Software Updates for the DB Instance
4) Easy scaling for storage and compute
5) Multi-AZ option with synchronous replication
6) Automatic failover for Multi-AZ option
7) Read replicas option for read-heavy workloads