Databases - Databases 101

Question 1

RDS Types

Answer 1

SQL Server, Oracle, MySQL Server, PostgreSQL, Aurora, MariaDB

Question 2

What is Elasticache?

Answer 2

Web service that makes it easy to deploy, operate, and scale an in-memory cache in the cloud

Question 3

In-memory caching engines that Elasticache supports:

Answer 3

Memcached, Redis

Question 4

Use case for Elasticache

Answer 4

If web app constantly requests the top 10 products, cache that information in Elasticache

Question 5

DMS

Answer 5

allows you to migrate your production database to AWS

Question 6

One migration starts…

Answer 6

AWS manages complexities of the migration processes like data type transformation, compression, and parallel transfer, while ensuring that data changes to the source database that occur during the migration process are automatically replicated to the target

Question 7

Purpose of the AWS schema conversion tool

Answer 7

automatically converts the source DB schema and a majority of the custom code, including views, stored procedures, and functions, to a format compatible with the target DB.

Question 8

RDS is used for

Answer 8

OLTP

Question 9

DynamoDB used for

Answer 9

NoSQL

Question 10

RedShift used for

Answer 10

OLAP