Databases Flashcards

1
Q

Why databases?

A
  • structure data, build indexes, relationships, optimized for a purpose
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Amazon RDS

A
  • Relational Database Service
  • SQL as query language
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Amazon Aurora

A
  • PostgreSQL and MySQL are supported
  • 3-5x performance improvement to the above
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Amazon Aurora Serverless

A
  • Automated database instantiation and
    auto-scaling based on actual usage
  • PostgreSQL and MySQL are supported
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

RDS Deployments: Read Replicas

A
  • Scale the read workload
  • up to 15 Read Replicas
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

RDS Deployments: Multi-AZ

A
  • Failover in case of AZ outage (high availability)
  • only have 1 other AZ as failover
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

RDS Deployments: Multi-Region

A
  • Read Replicas
  • Disaster recovery, Local performance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Amazon ElastiCache

A
  • managed Redis or Memcached
  • in-memory databases with high performance, low latency
  • reduce load off databases for read intensive workloads
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

DynamoDB

A
  • NoSQL database
  • Single-digit millisecond latency – low latency retrieval
  • key/value database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

DynamoDB Accelerator and Global Tables

A
  • Accelerator = 10x performance improvement
  • Global Tables = accessible with low latency in multiple-regions (Active-Active replication)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Redshift

A
  • based on PostgreSQL, but not for OLTP
  • OLAP = online analytical processing
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Redshift Serverless

A
  • Use cases: Reporting, dashboarding applications, real-time analytics
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Amazon EMR

A
  • 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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Amazon Athena

A
  • Serverless query service to analyze data stored in Amazon S3
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Amazon QuickSight

A
  • Serverless machine learning-powered business intelligence service to create interactive dashboards
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

DocumentDB

A
  • like MongoDB
17
Q

Amazon Neptune

A
  • Fully managed graph database
  • popular graph dataset = social network
18
Q

Amazon Timestream

A
  • Fully managed, fast, scalable, serverless time series database
19
Q

Amazon QLDB

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

Amazon Managed Blockchain

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

AWS Glue

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

DMS – Database Migration Service

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