Databases and Analytics

Question 1

Scale workload of database by making up to five read-only copies; data only writes to main database

Answer 1

Read replicas

Question 2

Deployment configuration where a failover database is created in a different AZ; if main db fails, failover database takes over

Answer 2

Multi-AZ

Question 3

Deployment configuration that creates a read replica in a separate region; writes only to main database; high availability and better for regional users

Answer 3

Multi-Region

Question 4

Managed in-memory database used typically for caching read-intensive workloads

Answer 4

Elasticache

Question 5

Distributed key/value serverless database; can be replicated across three AZs for low latency retrieval

Answer 5

DynamoDB

Question 6

An in memory database for DynamoDB used to cache frequently read objects

Answer 6

DynamoDB Accelerator

Question 7

Table that can be accessed from multiple regions that has low latency

Answer 7

DynamoDB Global Tables

Question 8

AWS Postgres-based database useful for OLAP (analytics and data warehousing); integrates with Quicksight and Tableau

Answer 8

Redshift

Question 9

AWS service used to create Hadoop clusters to handle big data

Answer 9

ElasticMap Reduce

Question 10

Serverless query service to query structures S3 objects (JSON, csv, parquet, etc)

Answer 10

Athena

Question 11

Serverless ML-powered business intelligence service to create interactive dashboards

Answer 11

Quicksight

Question 12

AWS implementation of MongoDB that allows you to store, query, and index JSON data

Answer 12

DocumentDB

Question 13

Fully managed graph database used for highly connected datasets (e.g. social networks, recommendation engines)

Answer 13

Neptune

Question 14

Immutable blockchain ledger used for financial transactions

Answer 14

Quantum Ledger Database (QLDB)

Question 15

AWS blockchain service compatible with Hyperledger and Ethereum frameworks

Answer 15

Managed Blockchain

Question 16

Managed ETL service

Answer 16

Glue

Question 17

Service used to migrate databases to AWS; source database remains available during migration

Answer 17

Database Migration Service (DMS)

Question 18

AWS hosted database service

Answer 18

Relational Database Service (RDS)

Question 19

Proprietary AWS relational database service optimized for cloud usage

Answer 19

Aurora

Question 20

True or False: The main purpose of a Read Replica RDS design is for enhanced availability

Answer 20

False - it is for improved scalability

Question 21

True or False: The main purpose of a Multi-AZ RDS deployment is for high availability

Answer 21

True

Question 22

What are the two main purposes of a Multi-Region RDS deployment?

Answer 22

Disaster Recovery
Local Performance