Databases Flashcards

1
Q

Aurora Data is held in __ replicas, across __ AZ

A

6, 3

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

Aurora: Auto scaling of storage from __GB to __TB

A

Auto scaling of storage from 10GB to 64 TB

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

Aurora: allows for up to how many read replicas?

A

15

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

DynamoDB can only query on

A

primary key, sort key,

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

What is the purpose of Athena?

A

Used to query data in S3

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

Athena output results where?

A

S3

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

Athena pay per ..?

A

Query

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

Athena is secured through?

A

IAM

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

Redshift is used for OLTP?

A

False - OLAP

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

Redshift is row based storage?

A

False - Columnar

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

Redshift: Up to how many nodes and space per node?

A

Up to 128 and 160GB space per node

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

Use this when performing Analytics / BI / Data Warehousing

A

Redshift

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

Neptune is what?

A

Fully managed graph database.

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

Neptune Reliability?

A

Multi-AZ, clustering

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

ElasticSearch give you the ability to do what with DynamoDB/

A

With ElasticSearch, you can search any field, even partially matches

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