Databases in AWS Flashcards

1
Q

What is Amazon RDS?

A

A managed relational database service that is compatible with many of the most used database engines, such as MySQL, PostgreSQL, Oracle etc.

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

How do manual and automatic backups work with RDS?

A

Automated backups enable point-in-time-restore capability, but expire after 35 days.
Manual backups are kept for longer than this and thus can be used for longer term recovery.

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

What two engines is Aurora compatible with?

A

PostgreSQL and MySQL

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

When is the serverless version of Aurora appropriate?

A

For intermittent or unpredictable workloads

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

What is the strength of Aurora’s storage set up?

A

Data is stored in 6 replicas across 3 AZs, making it highly available and self-healing

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

What is the fastest way to make a new Aurora cluster from an existing one?

A

Cloning - faster than restoring a snapshot

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

What is ElastiCache?

A

A managed Redis/Memcached database service that utilises an in-memory store to deliver queries with sub-ms latency

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

What is one downside/serious consideration associated with using ElastiCache?

A

It will probably require modifications to your application’s code

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

What is an example of a use case for ElastiCache?

A

Key/value store, frequent reads (but not often written), cache results for DB queries, store session data for websites

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

What high availability feature does DynamoDB have as default?

A

Multi-AZ deployment

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

What is DynamoDB?

A

Proprietary AWS noSQL database that is useful for databases where you need a flexible or evolving schema

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

What are the two DynamoDB backup options?

A

Automated or manual.
Automated

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

How is security, authorisation and authentication handled for DynamoDB?

A

Through IAM

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

What is DocumentDB specialised for? Does it use SQL?

A

JSON data
No, DocumentDB is a NoSQL database service

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

What is Neptune?

A

A fully managed, highly available graph database.

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

What is Amazon Keyspaces?

A

A fully managed Apache Cassandra distributed database.

17
Q

What query language is used to query an Amazon Keyspace database?

A

Cassandra Query Language

18
Q

What is QLDB? What does this stand for?

A

A ledger of financial transactions that are immutable and cryptographically verifiable

19
Q

What would a QLDB be used for?

A

Reviewing the history of all the changes made to application data over time

20
Q

What is the difference between QLDB and Amazon Managed Blockchain?

A

QLDB has no decentralisation component in accordance with financial regulations

21
Q

What is Amazon Timestream?

A

A fully managed time series database with built-in analytics functions