Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

AWS > Databases > Flashcards

Databases Flashcards

1
Q

Databased

A

Structured
Enables efficiency with query and searching through the data

Defined relationships

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Relational Database

A

Like excel spreadsheets.

Links between them

Can use SQL to perform queries or lookups

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

NoSQL databases

A

Non relational databases.

Built for specific purpose with specific data model in mind.

Flexible Schema / Shape.

Benefit is flexibility. Easy to make it evolve.

Scalable with distributed servers.

High performance

Highly functional

Examples:

Key- Value

Graph Database

In-memory

Search databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

NoSQL- data example

A

JSON format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

JSON

A

JavaScript Object Notation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

JSON

A

Common way to describe data.
Data can be nested
Fields can change over time.
Support for new types (arrays etc)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Databases Shared Responsibility Model

A

AWS offers use to manage different databases
Benefits include:
Quick provisioning
High availability
Vertical and horizontal scaling
Automated backup and restore, operations and upgrades
Operating System Patching is handled by AWS
Monitoring and Alerting

If run on EC2 instance, you need to handle resiliency, backup, patching, high availability, fault tolerance, scaling, etc.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

RDS

A

Relational Database Service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

RDS Overview

A

Relational Database
Managed DB
Uses SQL

Create databases in cloud that are managed by AWS
Postgres
MySQL
MariaDB
Oracle
Microsoft SQL Server
IDM DB2
Aurora

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

DB

A

database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

RDS vs EC2

A

managed vs not
Automated provisioning and patching
continuous backups and restore
monitoring dashboards
read replicas
multi AZ setup for DR (disaster recovery)
Scaling capability
Storage backed by EBS

CANNOT SSH into your instances

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

RDS Solution Architecture

A

Elastic Load Balancer -> EC2 Instances <—> Amazon RDS

Run as managed Service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Amazon Aurora

A

Proprietary to AWS
supports PostgreSQL and MySQL

Cloud optimized

Storages grows automatically in increments of 10gb up to 128 TB

20% more efficient than RDS

Not in free tier

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

AWS Aurora Serverless

A

Automated database instantiation and auto-scaling based on actual use.

PostgreSQL and MySQL are both supported

No capacity planning needed

Least management overhead

Pay per second, can be more cost effective

Use cases: good for infrequent intermittent or unpredictable workload

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

RDS Deployment

A

Read Replicas
Multi-AZ
Multi-Region

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Read Replicas

A

Up to 15 read replicas

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Multi-AZ

A

Failover in case of AZ outage (high availability)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Multi-Region

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Elastic Cache

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Managed Redis

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Memcached

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Dynamo DB

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Dynamo DB Global Tables

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

Redshift

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

EMR Overview

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

Athena Overview

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q
A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q
A
36
Q

Quicksight overview

A
37
Q
A
38
Q
A
39
Q

DocumentDB overview

A
40
Q
A
41
Q
A
42
Q

Neptune Overview

A
43
Q
A
44
Q
A
45
Q

Timestream Overview

A
46
Q
A
47
Q
A
48
Q

QLDB Overview

A
49
Q
A
50
Q
A
51
Q
A
51
Q

Managed Blockchain

A
52
Q
A
53
Q
A
54
Q

Glue Overview

A
55
Q
A
56
Q
A
57
Q

DMS Overview

A
58
Q
A
59
Q

Relational Database - OLTP

A

RDS & Aurorara (SQL)

60
Q

In-memory Database

A

ElasticCache

61
Q

Key/Value Database

A

DynamoDB(serverless) & DAX (cache for DynamoDB)

62
Q

Multi-AZ vs Read Replicas vs Multi-Region

A
63
Q

Warehouse - OLAP

A

Redshift (SQL)

64
Q

OLAP

A

online analytical processing

65
Q

Hadoop Cluster

A

EMR

66
Q

Athena

A

Query data on Amazon S3 (serverless & SQL)

67
Q

Quicksight

A

dashboards on your database (serverless)

68
Q

DocumentDB

A

Aurora for MongoDB (JSON- NoSQL database)

69
Q

MongoDB

A
70
Q

QLDB

A
71
Q

Amazon QLDB

A

Financial Transaction Ledger
Immutable journal, cryptographically verifiable

72
Q

Amazon Managed Blockchain

A

Managed Hyperledger Fabric and Ethereum blockchains

73
Q

Glue

A

Managed ETL (Extract Transform Load) and Data Catalog Service

74
Q

ETL

A
75
Q

Data Catalog Service

A
76
Q

Managed Hyperledger Fabric

A
77
Q

Database Migration

A

DMS
Database Migration Service

78
Q

Neptune

A

Graph Database

79
Q

Graph Database

A
80
Q

Timestream

A

Time-series database

81
Q

Time-series database

A
82
Q

OLTP

A
83
Q

What does in memory database mean?

A
84
Q

What does key/value database mean?

A
85
Q

What is a Hadoop Cluster

A
86
Q

What is Hadoop?

A

AWS (17 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions