Databases

Question 1

What 6 relational databases are available with AWS RDS?

Answer 1

SQL server, PostregreSQL, Oracle, MariaDB, MySQL, Aurora

Question 2

What does OLTP stand for?

Answer 2

Online transaction processing

Question 3

What is OLTP?

Answer 3

OLTP is the processing of data from transactions in real time

Question 4

What does OLAP stand for?

Answer 4

Online analytical processing

Question 5

What is OLAP?

Answer 5

OLAP is the processing of complex queries to analyze historical data

Question 6

What does Multi-AZ RDS do?

Answer 6

Creates an exact copy of production database in another AZ

Question 7

What is a read replica?

Answer 7

a read-only copy of your database

Question 8

Can read replicas be cross region?

Answer 8

Yes

Question 9

Why don’t read replicas have its own DNS end point?

Answer 9

It does

Question 10

Can read replicas be promoted to their own databases?

Answer 10

Yes

Question 11

What specific setting is required for read replicas to be enabled?

Answer 11

Automatic backup

Question 12

How many read replicas can you have per database?

Answer 12

5

Question 13

What is Amazon Aurora?

Answer 13

a MySQL and PostgreSQL compatible relational database engine that combines the speed and agility of high end commercial databases with the simplicity and cost effectiveness of open source databases

Question 14

How much space does Aurora start with?

Answer 14

10 GB

Question 15

How many copies are of your data are guaranteed with Aurora? How is this composed?

Answer 15

6 copies. 2 copies in 3 AZ

Question 16

Is the Aurora database self-healing?

Answer 16

Yes

Question 17

In what platforms can you have replicas?

Answer 17

Aurora, MySQL, PostgreSQL

Question 18

Are backups automated for Aurora?

Answer 18

Yes

Question 19

How much do backups impact Aurora database performance?

Answer 19

Not at all

Question 20

What is Aurora serverless?

Answer 20

An on-demand auto scaling configuration for the MySQL and PostgreSQL compatible editions of Aurora.

Question 21

What are the benefits of Aurora Serverless DB Cluster?

Answer 21

An Aurora DB cluster automatically starts up, shuts down, and scales capacity up or down based on your applications needs

Question 22

What are Aurora serverless use cases?

Answer 22

When you need a relatively simple, cost effective option for infrequent or unpredictable workloads

Question 23

Can you share your Aurora snapshots with other accounts?

Answer 23

Yes

Question 24

Are automated backups default for Aurora?

Answer 24

Yes

Question 25

What is DynamoDB?

Answer 25

A fast and flexible NoSQL database service

Question 26

What data models does DynamoDB support?

Answer 26

document and key-value data models

Question 27

Is DynamoDB fully managed?

Answer 27

Yes

Question 28

What are some examples where DynamoDB would be a great fit?

Answer 28

Mobile, web, gaming, ad-tech, IoT

Question 28

What is the latency for DynamoDB?

Answer 28

Single digit millisecond

Question 29

What storage service type does DynamoDB use?

Answer 29

SSD

Question 30

Where is DynamoDB spread across?

Answer 30

3 geographically distinct data centers

Question 31

Is strongly consistent reads or eventually consistent reads default?

Answer 31

eventually consistent

Question 32

What is DAX?

Answer 32

DynamoDB Accelerator is a fully managed, highly available, in-memeory cache service for DynamoDB

Question 33

By what factor does DAX improve DynamoDB?

Answer 33

10x

Question 34

How is pricing structured for DynamoDB?

Answer 34

Pay per request

Question 35

What is the encryption type at rest for DynamoDB?

Answer 35

KMS

Question 36

What does ACID stand for?

Answer 36

ATOMIC, Consistent, isolated, durable

Question 37

What does atomic in ACID mean?

Answer 37

All changes to data must be successful or no changes at all

Question 38

What offering makes DynamoDB ACID?

Answer 38

DynamoDB transactions

Question 39

What is DynamoDB Backups?

Answer 39

An on demand backup and restore service

Question 40

What does DynamoDB Global Tables give you?

Answer 40

Manger multi master multi regional replication

Question 41

What needs to be enabled for DynamoDB global tables?

Answer 41

DynamoDB streams

Question 42

What is MongoDB?

Answer 42

A document database that allows for scalability and flexibility with your data as well as robust querying and indexing features

Question 43

What is Amazon DocumentDB?

Answer 43

Allows you to run MongoDB on the AWS cloud. It’s a managed database service that scales with your workloads and safely and durably stores your database information

Question 44

What is the advantage of AmazonDB over MongoDB?

Answer 44

Get rid of operational overheads like cluster management software, configuring backups, monitoring workloads

Question 45

What is Cassandra?

Answer 45

A distributed database (ie it runs on many machines) that uses NoSQL

Question 46

When is Cassandra typically used?

Answer 46

For big data solutions

Question 47

What is Amazon keyspaces?

Answer 47

Amazons Apache Cassandra database service. Allows you to run Cassandra workloads on AWS.

Question 48

What is the advantage of AWS keyspaces over Cassandra?

Answer 48

It is fully managed database. No need to worry about managing servers, software patching, etc.

Question 49

Is Amazon keyspaces serverless?

Answer 49

Yes

Question 50

What is Amazons graph database service?

Answer 50

Neptune

Question 51

What is a ledger database?

Answer 51

It is a NoSQL database that is immutable, transparent, and has a cryptographically verifiable transaction log that is owned by one authority

Question 52

What is Amazon Quantum Ledger Database?

Answer 52

QLDB is a fully managed ledger database that provides a transparent immutable and cryptographically verifiable transition log

Question 53

What is Amazon timestream?

Answer 53

A fully managed database service for time series data

Question 54

Is RDS suitable for OLAP or OLTP?

Answer 54

OLTP

Question 55

What are read replicas meant to improve?

Answer 55

Scaling (improves read performance) not distasteful recovery

Question 56

What is DynamoDB PITR?

Answer 56

Point in time recovery protects against accidental writes or deletes. Can restore any point in the last 35 days

Question 57

What are the 4 ways you can scale an RDS in AWS?

Answer 57

Vertical scaling, scaling storage, creating read replicas, aurora serverless

Question 58

What is the big thing you should be wary of when scaling storage?

Answer 58

it cant't be scaled back down