Databases

Question 1

Why databases?

Answer 1

• structure data, build indexes, relationships, optimized for a purpose

Question 2

Amazon RDS

Answer 2

• Relational Database Service
• SQL as query language

Question 3

Amazon Aurora

Answer 3

• PostgreSQL and MySQL are supported
• 3-5x performance improvement to the above

Question 4

Amazon Aurora Serverless

Answer 4

• Automated database instantiation and
  auto-scaling based on actual usage
• PostgreSQL and MySQL are supported

Question 5

RDS Deployments: Read Replicas

Answer 5

• Scale the read workload
• up to 15 Read Replicas

Question 6

RDS Deployments: Multi-AZ

Answer 6

• Failover in case of AZ outage (high availability)
• only have 1 other AZ as failover

Question 7

RDS Deployments: Multi-Region

Answer 7

• Read Replicas
• Disaster recovery, Local performance

Question 8

Amazon ElastiCache

Answer 8

• managed Redis or Memcached
• in-memory databases with high performance, low latency
• reduce load off databases for read intensive workloads

Question 9

DynamoDB

Answer 9

• NoSQL database
• Single-digit millisecond latency – low latency retrieval
• key/value database

Question 10

DynamoDB Accelerator and Global Tables

Answer 10

• Accelerator = 10x performance improvement
• Global Tables = accessible with low latency in multiple-regions (Active-Active replication)

Question 11

Redshift

Answer 11

• based on PostgreSQL, but not for OLTP
• OLAP = online analytical processing

Question 12

Redshift Serverless

Answer 12

• Use cases: Reporting, dashboarding applications, real-time analytics

Question 13

Amazon EMR

Answer 13

• Elastic MapReduce
• Hadoop clusters (Big Data) to analyze and process vast amount of data
• made of hundreds of EC2 instances
  Use cases: data processing, machine learning, web indexing, big data

Question 14

Amazon Athena

Answer 14

• Serverless query service to analyze data stored in Amazon S3

Question 15

Amazon QuickSight

Answer 15

• Serverless machine learning-powered business intelligence service to create interactive dashboards

Question 16

DocumentDB

Answer 16

• like MongoDB

Question 17

Amazon Neptune

Answer 17

• Fully managed graph database
• popular graph dataset = social network

Question 18

Amazon Timestream

Answer 18

• Fully managed, fast, scalable, serverless time series database

Question 19

Amazon QLDB

Answer 19

• Quantum Ledger Database
• for recording financial transactions
• Immutable and review history

Question 20

Amazon Managed Blockchain

Answer 20

• execute transactions without the need for a trusted, central authority

Question 21

AWS Glue

Answer 21

• Managed extract, transform, and load (ETL) service (is severless)

Question 22

DMS – Database Migration Service

Answer 22

• Quickly and securely migrate databases
  to AWS, resilient, self healing