Databases

Question 1

What are the RDS Database types?

Answer 1

1) SQL Server
2) Oracle
3) MySQL
4) PostgreSQL
5) MariaDB
6) Amazon Aurora

Question 2

What workloads is RDS used for?

Answer 2

OLTP (Online Transaction Processing)

A transactional or OLTP (online transaction processing) workload is a workload typically identified by a database receiving both requests for data and multiple changes to this data from a number of users over time where these modifications are called transactions.

Question 3

What workloads is Redshift best for?

Answer 3

OLAP (Online Analytical Processing)

OLAP systems retrieve and manipulate data through complex queries and scans, organizing the data into different multidimensional views or reports for in-depth analysis.

Question 4

What is a Read Replica?

Answer 4

Is a read only copy of your database

Question 5

Can a read replica be in a separate AZ or region?

Answer 5

Yes

Question 6

Can you use a Read Replica for disaster recovery?

Answer 6

No

Question 7

Can you upgrade a Read Replica do be its own database?

Answer 7

Yes

Question 8

When you upgrade a Read Replica database to its own database does it still get replication from the original database?

Answer 8

No

Question 9

Do Read replicas require automatic backup?

Answer 9

Yes

Question 10

What is the max number of read replicas you can have per Database instance?

Answer 10

5

Question 11

Can you use a Multi-AZ backup DB as a read replica?

Answer 11

No, the database is only a copy of the main one and on standby if there is a failure from the first one.

Question 12

What is Amazon Aurora?

Answer 12

A MySQL and Postgres compatible relational database engine

Question 13

How much better performance does Aurora have over MySQL

Answer 13

5x

Question 14

How much better performance does Aurora have over Postgres?

Answer 14

3x

Question 15

Whats the starting size of an Aurora DB?

Answer 15

10gb

Question 16

What size increments does aurora scale in?

Answer 16

10gb

Question 17

What is the max size of Aurora storage autoscaling?

Answer 17

128TB

Question 18

What is the max scale of compute resources for Aurora?

Answer 18

96vCPUs and 768 GB of memory

Question 19

How many copies of your data are there in total with Aurora by default?

Answer 19

6
2 in every availability zone with a minimum of 3 availability zones

Question 20

Can you share Aurora snapshots across accounts?

Answer 20

Yes

Question 21

What are the three types of replicas available to Aurora?

Answer 21

Aurora, Mysql, Postgress

Question 22

Is automatic failover available for all Aurora replica types?

Answer 22

No, only Aurora Replicas and not Mysql and Postgres

Question 23

Does Aurora have automated snapshots?

Answer 23

Yes

Question 24

Is Dynomo DB Data stored on HDD or SSD?

Answer 24

SSD

Question 25

How many geographically distinct data centers is Dynamo DB data spread across?

Answer 25

3

Question 26

By default what read type does Dynamo DB have?

Answer 26

Eventually consistent reads

Question 27

Can you have strongly consistent reads configured in Dynamo DB?

Answer 27

Yes

Question 28

What is eventually consistent reads?

Answer 28

Consistency across all copies of data is usually reached within a second. Repeating a read after a short time should return the updated data. best for read performance

Question 29

What is strongly consistent reads?

Answer 29

A strongly consistent read returns a result that reflects all writes that received a successful response prior to the read

Question 30

What does ACID stand for?

Answer 30

Atomicity, Consistency, Isolation, and Durability

Question 31

If Dynamo DB has ACID Requirements what do you need to configure?

Answer 31

DynamoDB Transactions

Question 32

What does ACID basically mean?

Answer 32

All-or-Nothing transactions.

Question 33

Is Point-in-time-recover (PITR) Enabled by default for Dynamo DB?

Answer 33

No

Question 34

What is the latest restorable time for a PITR in DynamoDB?

Answer 34

5 minutes

Question 35

How far back can you go in a PITR for DynamoDB?

Answer 35

35 days

Question 36

What does PITR protect from?

Answer 36

Accidental writes or deletes

Question 37

What do DynamoDB Global tables do?

Answer 37

It gives multi master multi region replication.

Question 38

Do you need to enable dynamoDB streams for global tables to work?

Answer 38

Yes

Question 39

How long is Replication latency for DynamoDB Global Tables?

Answer 39

Under 1 second

Question 40

What is Amazon DocumentDB?

Answer 40

A way of running MongoDB workloads on an AWS environment.

Question 41

What is Cassandra?

Answer 41

A distributed database that uses noSQL

Question 42

What is Amazon Keyspaces?

Answer 42

Allows you to run your Cassandra services on AWS that managed by AWS

Question 43

What is a Graph Database?

Answer 43

A database that stores nodes and relationships instead of tables or documents

Question 44

What is Amazon Neptune?

Answer 44

AWS's Graph database offering

Question 45

What is Amazon Neptune?

Answer 45

AWS's Graph database offering

Question 46

What is a Ledger DB?

Answer 46

NoSQL Database that is immutable, transparent, and a cryptographically verified transaction log that is owned by one authority. You can not update a record in a ledger database. instead, an update adds a new record to the database.

Question 47

What is QLDB?

Answer 47

Quantum Ledger Database Amazons way of doing a ledger database.

Question 48

What is time-series data?

Answer 48

Datapoints logged over time

Question 49

What is Amazon TImestream?

Answer 49

AWS's timeseries DB solution