Databases Flashcards
1
Q
Why databases?
A
- structure data, build indexes, relationships, optimized for a purpose
2
Q
Amazon RDS
A
- Relational Database Service
- SQL as query language
3
Q
Amazon Aurora
A
- PostgreSQL and MySQL are supported
- 3-5x performance improvement to the above
4
Q
Amazon Aurora Serverless
A
- Automated database instantiation and
auto-scaling based on actual usage - PostgreSQL and MySQL are supported
5
Q
RDS Deployments: Read Replicas
A
- Scale the read workload
- up to 15 Read Replicas
6
Q
RDS Deployments: Multi-AZ
A
- Failover in case of AZ outage (high availability)
- only have 1 other AZ as failover
7
Q
RDS Deployments: Multi-Region
A
- Read Replicas
- Disaster recovery, Local performance
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
9
Q
DynamoDB
A
- NoSQL database
- Single-digit millisecond latency – low latency retrieval
- key/value database
10
Q
DynamoDB Accelerator and Global Tables
A
- Accelerator = 10x performance improvement
- Global Tables = accessible with low latency in multiple-regions (Active-Active replication)
11
Q
Redshift
A
- based on PostgreSQL, but not for OLTP
- OLAP = online analytical processing
12
Q
Redshift Serverless
A
- Use cases: Reporting, dashboarding applications, real-time analytics
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
14
Q
Amazon Athena
A
- Serverless query service to analyze data stored in Amazon S3
15
Q
Amazon QuickSight
A
- Serverless machine learning-powered business intelligence service to create interactive dashboards
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