Databases & Analytics

Question 1

What service is a managed relational database service for MySQL, PostgreSQL, MariaDB, Oracle BYOL, or SQL Server?

Answer 1

AWS RDS

Question 2

Which service is an AWS proprietary fully managed relational database engine that’s compatible with MySQL and PostgreSQL?

Answer 2

Amazon Aurora

Question 3

What is a read replica?

Answer 3

Replications of a database that can only be read but not written to, writing back only to the main DB, spreading out the read workload.

Question 4

What is a Multi-AZ replication?

Answer 4

Read replicas are located in another, singular AZ in case of failure.

Question 5

What is Multi-Region replication?

Answer 5

Read replicas are located in multiple Regions and write back, cross-region to main DB.

Question 6

What service provides in-memory caching of relational databases like RDS?

Answer 6

ElastiCache

Question 7

What service provides a fully managed, Highly Available NoSQL database (not relational) with replication across 3 AZ?

Answer 7

DynamoDB

Question 8

Which service is a fully managed in-memory cache for DynamoDB?

Answer 8

DynamoDB Accelerator (DAX)

Question 9

What service makes DynamoDB accessible with low-latency in multiple regions?

Answer 9

DynamoDB - Global Tables

Question 10

What service provides OLAP data warehousing?

Answer 10

AWS Redshift

Question 11

What AWS service is used for easily running and scaling Hadoop, Apache Spark, Hive, Presto, and other big data workloads?

Answer 11

AWS EMR

Question 12

What is a query service AWS provides to perform analytics on S3 data and data lakes?

Answer 12

Amazon Athena

Question 13

What business intelligence tools provides modern interactive dashboards, paginated reports, embedded analytics, and natural language queries for data and big data?

Answer 13

Amazon QuickSight

Question 14

Amazon’s MongoDB - NoSQL, native JSON document database service.

Answer 14

DocumentDB

Question 15

What is AWS’ fully managed graph database service?

Answer 15

AWS Neptune

Question 16

What service is used for recording financial transactions, is fully managed, centralized, and immutable?

Answer 16

QLDP (Quantum Ledger Database)

Question 17

What service allows for the building of applications where multiple parties can execute transactions, and is decentralized?

Answer 17

Managed Blockchain

Question 18

Which service is a serverless data integration service that makes it easier to discover, prepare, move, and integrate data from multiple sources for analytics, machine learning (ML), and application development?

Answer 18

AWS Glue