README.md

Databases

The AWS DB platforms most suitable for online transaction processing are _____ and _____

RDS and DynamoDB

In RDS when using multiple availability zones, can you use the secondary database as an independent read node?

No

The maximum RDS backup retention period is _____ days.

35 Days

In order to see free memory in RDS metrics, you need to enable _____

Enhanced monitoring

Does installing patches require taking an RDS instance offline?

Yes

In elasticache you can snapshot only ___ engine clusters.

Redis

In a Multi-AZ deployment, Amazon RDS automatically switches to the standby replica if your primary DB Instance has failed by changing the ______ DNS record of the main DB Instance to point to the standby DB Instance.

CNAME

If you modify a DB Instance or the DB parameter group associated with the instance, when do the changes take effect?

After reboot

The AWS service best suited for non relational databases is _____

DynamoDB

Amazon's Elasticache uses the _____ and _____ engines.

Redis & Memcached

Is DynamoDB data automatically replicated across multiple availability zones?

Yes

Are RDS read replicas synchronous or asynchronous?

Asynchronous

Can you initiate a manual reboot with failover in RDS?

Yes

To rebuild and index in RDS without affecting performance, you could do it on a _____ and then promote it to _____

read replica primary

What's the limit on the amount of data DynamoDB can store?

None

Does Redshift automatically scale up to meet demand?

No

Can RedShift load data from DynamoDB?

Yes

When reading data from Amazon DynamoDB, can users specify whether they want the read to be eventually consistent or strongly consistent?

Yes

Can you have provisioned IOPS for your RDS database?

Yes

Manually created DB Snapshots are _____ after the DB Instance is deleted.

retained

The AWS service used for Business Intelligence Tools/Data Warehousing is _____

Redshift

When doing online transaction processing in RDS, you could use _____ over standard storage.

provisoned IOPS 

When do changes to the RDS backup window take effect?

Immediately

Does DynamoDB scale and is fault tolerant automatically?

Yes

RedShift is for _____ big data.

Data warehousing

In RDS, can you change the disk type without any downtime?

Yes - if multi-AZ.

Can you promote an RDS read replica to a primary instance?

Yes

Does RDS supports MySQL clustering?

No

With Redis Elasticache you can have up to __ read replicas in different AZ's

5

Using _____ for your web application cache can reduce the load on your database and web servers.

Elasticache 

Are standby RDS instances in the same Region as the primary?

Yes

Is a standby RDS instance in the same Availability Zone as the primary?

No

AWS service health can be chcked at https://_____.aws.amazon.com

https://status.aws.amazon.com

How does AWS RDS fail-over?

Route 53 changes the DNS

Can RedShift load data from S3?

Yes

Can you create RDS read replicas for read-heavy applications?

Yes

Are DynamoDB costs, among other things, based on in/out data transfer per month?

Yes

In the event of a cache node failure, the Elasticache cluster remains available, but _____ may be reduced until the new cache node is populated.

performance

RDS DB snapshots and automated backups are stored in _____

S3

Does RDS automatically backup daily?

Yes

Can RDS tolerate an Availability Zone failure?

Yes if deployed Multi-AZ.

Does Multi-AZ RDS make the database more available during maintenance tasks?

Yes

Are DynamoDB costs, among other things, based on provisioned throughput capacity?

Yes

What AWS services can you use to store session data?

RDS, DynamoDB & Elasticache.

Which AWS services could you use to cache database queries?

CloudFront Amazon Elastic Cloud

Are DynamoDB costs, among other things, based on the Indexed Data Storage?

Yes