Databases 101 Flashcards

1
Q

5 Types of Database Services

A
RDS
DynamoDB
Elasticache
Redshift
DMS (database migration service)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

6 OLTP Relational Database Types

A
(SMO-PAM)
SQL
MySQL
Oracle
PostgreSQL
Aurora
MariaDB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Non-relational databases

A

DynamoDB (No SQL)

document-oriented databases

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

Non relational database components

A

Collection (like a table)
Document (like a row)
Key-Value Pairs (fields in table)

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

Data Warehousing

A

used for BI
Cognos, SQL Reporting Services, Oracle hyperion
used for large data sets

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

OLTP

Online Transaction Processing

A

Transactional process
Queries pull up record sets
Includes Relational Database Types

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

OLAP

Online Analytics Processing

A

Queries pull up large number of records
Redshift
ie net profit calculations for regions

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

Which 2 caching engines does Elasticache support?

A

Memached

Redis

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

Which 2 caching engines does Elasticache support?

A

Memcached

Redis

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

DMS

Database Migration Services

A

Lets you migrate your production to AWS

Manages complexities like data type transformation, compression.

Lets you convert source database (ie Oracle) to different type (ie Aurora MySQL) in AWS.

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

DMS

Database Migration Services

A

Lets you migrate your production to AWS

Manages complexities like data type transformation, compression.

Lets you convert source database (ie Oracle) to different type (ie Aurora MySQL) in AWS.

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

TCP Port for MySQL / Aurora

Popular exam question for troubleshooting access - make sure it’s allowed in security groups

A

TCP 3306

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

What is Elasticache?

A

in-memory caching

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

What is multi-AZ?

A

EC2 instances behind ELB point to RDS instance in one AZ. That RDS instance is automatically synchronized to another AZ

Failover performed automatically

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

How many copies of your data does Aurora keep?

A

6

2 copies in 3 AZ’s

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

DynamoDB vs RDS scaling comparison

A

DynamoDB has push button scaling

RDS has to scale via a bigger instance or read replica

17
Q

DynamoDB key points

A

stored on SSD
spread over 3 geographic areas

eventual consistent reads (default)
strongly consistent reads (for being available under 1 second)

18
Q

Redshift

A

data warehousing

single node 160Gb

multi node (leader and compute nodes) up to 128

19
Q

Is redshift a relational database?

A

yes, even though olap and data warehousing