Deck 2

Question 1

Relational Databases - OLTP

Answer 1

Mysql
SQL
Postgres
Oracle
Aurora

Question 2

Non-Relational - NoSQL

Answer 2

MongoDB

DynamoDB

Question 3

Data Warehousing - OLAP (Online Analytics)

Answer 3

Redshift

Question 4

Elasticache

Answer 4

Redis

Memcache

Question 5

Difference between DynamoDB and MongoDB

Answer 5

DynamoDB cannot have embedded data structures

Question 6

The max backup retention period for a database

Answer 6

35 days

Question 7

Amazon DB that is associated with OLTP

Answer 7

RDS

Question 8

NoSQL AmazonDB

Answer 8

DynamoDB

Question 9

Amazon OLAP DB (Analytics)

Answer 9

Redshift

Question 10

In memory caching DB

Answer 10

Memcached

Question 11

What can done with RDS database online

Answer 11

Add storage
Update the instance class
password

Question 12

What happens when you restore a DB

Answer 12

A new DB is created

Question 13

Limitation of a SQL instance

Answer 13

Cannot be resized with out exporting and importing to another DB

Question 14

Is there a default database with a SQL instance

Answer 14

No

Question 15

New Amazon MySQL compatible database

Answer 15

Aurora

Question 16

Aurora DB size and CPU and Memory

Answer 16

DB starts at 10GB increments to 64TB
Up to 32 vCPUs
Up to 244GB RAM

Question 17

Running copies of an Aurora DB and in how many AZ

Answer 17

2 copies with a minimum of 3 AZs for 6 total copies

Question 18

How many copies of an Aurora DB can be lost without affecting writes

Answer 18

2

Question 19

Aurora can lose how many copies and still be read only?

Answer 19

3

Question 20

DynamoDB data availability zones

Answer 20

Stored in 3 different geographically located data centers. This is automatic and unchangeable unlike RDS.

Question 21

DynamoDB consistency options

Answer 21

Eventually consistent reads (default)

Strong consistent reads

Question 22

DynamoDB storage and other limitations

Answer 22

Based on SSD

Cannot have nested key value pairs like MongoDB

Question 23

Massively parallel process (MPP) data warehouse services

Answer 23

Redshift

Question 24

Columnar data storage

Answer 24

Redshift

Question 25

Redshift configuration

Answer 25

Starts with a single node (160GB)
Multi-node comprised of:
-Leader node (Client connection manager and receives queries)
-Compute node (stores data & performs quieries and computations). Up to 128 nodes.

Question 26

Max size of provisioned IOPS drive for MySQL and Oracle RDS databases

Answer 26

6TB (minimum of 100GB)

Question 27

What happens to the I/O operations while you take a database snapshot?

Answer 27

I/O operations to the database are suspended for the duration of the snapshot

Question 28

Maximum provisioned IOPS capacity on an Oracle and MySQL RDS instance (using provisioned IOPS)

Answer 28

30,000

Question 29

Can reserved instances be moved from one region to another?

Answer 29

No

Question 30

Max RDS SQL Express DB size

Answer 30

10GB

Question 31

Can I “force” a failover for any RDS instance that has Multi-AZ configured?

Answer 31

Yes

Question 32

AWS support plans

Answer 32

Basic (included)
Developer - $49/month
Business - $100/month
Enterprise - Starts at $15k/month

Question 33

Support plan critical response times

Answer 33

Basic - N/A

Developer -

Question 34

Can reserved instances be moved to another AZ?

Answer 34

yes