Database & Analytics

Question 1

Amazon Aurora

Answer 1

• AWS proprietary DB
• Supports PostgreSQL and MySQL
• AWS cloud optimized
• Storage automatically grows in increments of 10GB, up to 128 TB
• Cost 20% more than RDS, but is more efficient

Question 2

Amazon Aurora Serverless

Answer 2

• AWS proprietary DB
• Least management overhead
• PostgreSQL and MySQL
• No capacity planning needed
• Pay per second, can be more cost-effective
• Infrequent, intermittent or unpredictable workloads

Question 3

ElastiCache

Answer 3

• Managed Redis or Memcached DB
• In memory DB with high performance, and low latency
• Reduce load of DB for read intensive workloads

Question 4

DynamoDB

Answer 4

• Fully managed
• Replication across 3 AZ
• NoSQL DB - Not relational
• Distributed serverless database
• Single-digit millisecond latency
• Standard & Infrequent Access (IA) Table Class

Question 5

DynamoDB Accelerator - DAX

Answer 5

• Fully Managed in-memory cache for DynamoDB
• 10x performance improvement microsecond latency
• Only for and integrated with DynamoDB
• NoSQL

Question 6

DynamoDB - Global Tables

Answer 6

• Make DynamoDB table accessible with low latency in multiple regions
• Read/write in any region
• Active/Active replication

Question 7

Redshift DB

Answer 7

• PostgreSQL
• Not for OLTP (online transaction processing)
• Used for OLAP - online analytical processing (analytics and data warehousing)
• Columnar storage
• Massively Parallel Query Execution (MPP), highly available
• BI integration (AWS Quicksight or Tableau)

Question 8

Redshift DB Serverless

Answer 8

Not for OLTP/Used for OLAP
* Auto provision and scale
* Pay for what you use (storage and compute during analysis)
* Use case: reporting, dashboarding applications, real-time analytics

Question 9

Amazon EMR Elastic MapReduce

Answer 9

• Create Hadoop Cluster (Big Data)
• Clusters can hundreds of EC2 instances
• Use cases: data processing, machine learning, indexing, big data

Question 10

Amazon Athena

Answer 10

• Serverless query service
• Perform analytics against S3 objects
• Serverless SQL
• Pricing: $5 per TB scanned

Question 11

QuickSight

Answer 11

• Serverless
• machine learning-powered
• business intelligence
• Go to tool for BI

Question 12

Document DB

Answer 12

• NoSQL Database based on MongoDB
• Full Managed, highly available with replication across 3 AZ
• Auto grow in 10GB increments
• Auto-scales to workloads with millions of requests per second

Question 13

Amazon Neptune

Answer 13

• Fully managed graph database
• Dataset would be a social network
• Highly available across 3 AZ,
• Up to 15 read replicas
• Use case: knowledge graphs (Wikipedia), fraud detection, recommendation engines, social networking

Question 14

Amazon Timestream

Answer 14

• Fully managed, fast, scalable, serverless
• time series database
• Store and analyze trillions of events per day
• 1000x faster and 1/10th cost of relation DB

Question 15

Amazon QLDB (Quantum Ledger Database)

Answer 15

• Record financial transactions
• Fully managed, serverless, high available, replication across 3 AZ
• Review history of all changes made to you application data over time
• Immutable system: no entry can be removed or modified (Cryptographically verifiable)
• Difference with Amazon Managed Blockchain: no decentralization component, in accordance with financial regulations

Question 16

Amazon Manage Blockchain

Answer 16

• Multiple parties can execute transactions *without the need for a trusted, central authority”
• Managed service
• Join public blockchain networks

Question 17

AWS Glue ETL

Answer 17

• Manage extract, transform, and load (ETL) service
• Prep and transform data for analytics
• Fully serverless

Question 18

DMS - Database Migration Service

Answer 18

• Quickly and securely migrate db to AWS, resilient, self healing
• Source DB remains available during migration
• Supports Homogenous and Heterogeneous migrations