Databases Flashcards

1
Q

Databases

RDS Supports 6 engines, what are they?

A

SQL Server, Postgres, Oracle, MySQL, MariaDB & Aurora

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

Databases

RDS Multi-AZ is used to improve….

performance, scalability, availability…

A

Availability

Used for DR only,

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

Databases

RDS Read Replicas are used to improve

performance, scalability, availability…

A

Performance & Scaling

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

Databases

Aurora can use one of two DB engines

what are they?

A

MySql & Postgres

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

Databases

What RDS Service is good for intermittent workloads?

A

Aurora Serverless

An on demand DB Service and automatically boots and shuts down.

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

Databases

Which DB service supports non-relational DB’s

A

DynamoDB

has both eventual & strongly consistent modes of opperation

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

Databases

What service can be used to improve the performance of DynamoDB

A

DynamoDB Accelerator (DAX)

uses an in memory cache

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

Databases

What service can ensure ACID operations in DynamoDB

A

DynamoDB Transactions

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

Databases

What service provides and FIFO stream of DynamoDB table changes

A

DynamoDB Streams

changes stores for 24hrs

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

Databases

Fully managed, multi master, multi region DynamoDB instance with sub second latancy

A

DynamoDB Global Tables

Streams must be enabled first

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

Databases

AWS Service for MongoDB databases

A

DocumentDB

migrations via DMS

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

Databases

Big Data, NoSQL DB for distributed computing using Cassandra

A

Keyspaces

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

Databases

AWS Managed Graph DB

A

Neptune

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

Databases

AWS managed Ledger DB

A

AWS QLDB

immutable to ensure history

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

Databases

What DB can be used to ensure history of changes is preserved

A

AWS QLDB

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

Databases

fully managed DB optimised for analysing timeseries data

A

TimeStream

17
Q

Databases

Whats the best option for creating a multi-region DR solution for an RDS database

A

Create a cross-region read replica of your database

18
Q

Databases

Whats the best option for creating a highly available RDS database within a single region

A

Enable Multi AZ