Database

Question 1

Aurora

Answer 1

Relational database (MySQL and PostgreSQL)
Fast and scalable.
Allows replicas for read scaling within and across Regions.
Offers automated backups.

Question 2

Relational
Read scaling across Regions.
Automated backups.

Answer 2

Aurora

Question 3

DynamoDB

Answer 3

NoSQL (non-relational) database

Question 4

DocumentDB

Answer 4

NoSQL database
Supports document data structures.

Question 5

Serverless querying of data in Amazon S3 using SQL-like parameters

Answer 5

Athena

Question 6

Uses SQL to analyze structured data in data warehouses.

Answer 6

Redshift

Question 7

Redshift

Answer 7

Data Analysis
Warehouses
SQL
OLAP

Question 8

Amazon RDS

Answer 8

RDS is typically used as an online transaction processing (OLTP) database rather than an OLAP database.
Relational database (SQL)
data is structured and well-formed
Migrating existing applications

Question 9

Relational database (SQL)
OLTP
data is structured and well-formed
Migrating existing applications

Answer 9

Amazon RDS

Question 10

Binary large objects (BLOBs)
Static websites

Answer 10

S3

Question 11

Name/value pair data
Unpredictable data structure
No-SQL

Answer 11

DynamoDB

Question 12

Allows full control over instance and database.
Use when preferred DB not available under RDS.

Answer 12

Database on EC2

Question 13

in-memory db caching
improves performance for read requests
placed in front of database

Answer 13

ElastiCache

Question 14

ElastiCache

Answer 14

in-memory db caching
improves performance for read requests
placed in front of database

Question 15

a data warehouse that is used for performing analytics on data

Answer 15

RedShift

Question 16

Which DB solution would you use when migrating an application to the cloud?

Answer 16

Custom DB hosted on EC2

Question 17

sub-millisecond latency
used for real-time applications
open-source, widely compatible

Answer 17

Elasticache

Question 18

a cloud big data / hadoop platform that can be queried using SQL

Answer 18

EMR

Question 19

A company is interested in moving its on-premises NoSQL database into the AWS Cloud.

Which AWS service should the company use to replace their existing database?

Answer 19

DynamoDB

Question 20

What is the difference between QLDB and Managed Blockchain?

Answer 20

Unlike managed blockchain, QLDB is CENTRALIZED financial ledger while Managed Blockchain is DE-CENTRALIZED.

Question 21

DB for Ethereum and Hyperledger.

Answer 21

Managed blockchain

Question 22

managed ledger database that provides transparent, immutable, and cryptographically verifiable transactions

Answer 22

QLDB

Question 23

EMR

Answer 23

big data
hadoop framework
queried using SQL

Question 24

Which two benefits can a company gain by deploying a relational database on Amazon RDS instead of Amazon EC2?

Answer 24

Automated backups.

Software Patching.

Question 25

Aurora

Answer 25

relational database (SQL)
extremely fast and scales up to 128 TB.
Can deploy replicas for read scaling within and across Regions.
Automated backups.

Question 26

relational database (SQL)
“Cloud-optimized” allowing better performance
Can deploy replicas for read scaling within and across Regions.
Automated backups.

Answer 26

Aurora