Section 21: Databases in AWS

Question 1

A web service that makes it easier to set up, operate, and scale a relational database in the AWS Cloud. It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

Answer 1

Amazon RDS

Question 2

This service is a fully managed relational database engine that’s compatible with MySQL and PostgreSQL

Answer 2

Amazon Aurora

Question 3

How long does storage replication take across regions when using Aurora Global?

Answer 3

Less than one second

Question 4

Service that can be described as a fully managed, in-memory caching service supporting flexible, real-time use cases. (i.e. fully managed Redis or Memcached)

Answer 4

ElastiCache

Question 5

True/False - Using ElastiCache requires changes to your application code

Answer 5

True

Question 6

A fully managed, serverless, key-value NoSQL database designed to run high-performance applications at any scale

Answer 6

Amazon DynamoDB

Question 7

What are the two backup options available for DynamoDB?

Answer 7

Automated backups with PITR
On-Demand backups

Question 8

What is the maximum object size for an object in Amazon S3?

Answer 8

5 TB

Question 9

A fully managed native JSON document database that makes it easy and cost effective to operate critical document workloads at virtually any scale without managing infrastructure (i.e. managed MongoDB)

Answer 9

DocumentDB

Question 10

A fully managed database service built for the cloud that makes it easier to build and run graph applications

Answer 10

Neptune

Question 11

A scalable, highly available, and managed Apache Cassandra–compatible database service

Answer 11

Amazon Keyspaces

Question 12

A fully managed ledger database that provides a transparent, immutable, and cryptographically verifiable transaction log owned by a central trusted authority

Answer 12

Amazon Quantum Ledger Database

Question 13

A fast, scalable, and serverless time-series database service that makes it easier to store and analyze trillions of events per day up to 1,000 times faster

Answer 13

Amazon Timestream

Question 14

What RDS service can you use if you want to operate an Oracle database on the cloud and have access to customize the database server host and operating system?

Answer 14

RDS Custom for Oracle

Question 15

True/False: ElastiCache supports IAM Authorization

Answer 15

False - You have to use the cache’s authorization methods

Question 16

True/False: ElastiCache for Redis is not HIPAA eligible

Answer 16

False - ElastiCache for Redis features Online Cluster Resizing, supports encryption, and is HIPAA eligible, and PCI DSS compliant

Question 17

True/False: DynamoDB Accelerator (DAX) supports SQL query caching

Answer 17

False

Question 18

What are the two purposes for using Aurora replicas?

Answer 18

Scale read operations
Increase availability in case a cluster becomes unavailable

Question 19

This feature of RDS detects that you are running out of free database space and automatically scales up your storage

Answer 19

Storage autoscaling

Question 20

ElasticCache can be used to significantly improve latency and through put for ____-heavy application workloads as well as _____-intensive workloads

Answer 20

read; compute

Question 21

True/False: All DynamoDB tables are encrypted by default

Answer 21

True - all DynamoDB tables are encrypted under an AWS owned customer master key (CMK)

Question 22

What is the main feature of Elasticache for Memcached that Elasticache for Redis does not offer?

Answer 22

Multithreaded architecture

Question 23

What Aurora database feature can you use if you need to create copies of the database?

Answer 23

Cloning

Question 24

Which is the only AWS database type that supports database cloning?

Answer 24

Aurora

Question 25

True/False: Running a database level upgrade for an RDS DB instance with Multi-AZ deployment causes downtime because both the primary and standby database instances are upgraded at the same time.

Answer 25

True