AWS Database General Flashcards by Keith Tobin

Q

I require full/unlimited control over the database, it is a relational SQL DB, what is my best option?

A

Use an EC2 instance as RDS does not give you full control?

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

I have a well-formed and structured relational database, what are my options, do not need full control?

A

RDS

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

I have massive amounts of data and I need to analyze the data, what is my best option?>

A

RedShift

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

I need to store some session data, what is my best option?

A

ElasticCache

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is OLTP and give and example?

A

Online transactional processing, RDS, MySQL, etc.

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is OLAP and give example?

A

Online analytics processing , rdshift

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

What is OLAP and give example?

A

Online analytics processing, RedShift

How well did you know this?

1

Not at all

2

3

4

5

Perfectly