Section 9: Databases and Analytics

Question 1

What language do Relational Databases use?

Answer 1

SQL

Question 2

What are NoSQL Databases?

Answer 2

Non-relational Databases

Question 3

Benefits of NoSQL Databases

Answer 3

• Flexibility: easy to evolve data model
• Scalability: designed to scale-out by using distributed clusters
• High-performance: optimized for a specific data model
• Highly functional: types optimized for the data model

Question 4

AWS RDS is

Answer 4

Relational Database Service that allows you to create databases in the cloud that are managed by AWS

Question 5

Amazon Aurora is

Answer 5

An AWS cloud optimized database service

Question 6

Aurora is (more/less) expensive than RDS but (more/less) efficient

Answer 6

Aurora is more expensive than RDS but more efficient

Question 7

What is Amazon Aurora Servrerless?

Answer 7

Automated database instantiation and auto-scaling based on actual usage

Question 8

Read Replica RDS Deployment

Answer 8

Scale the read workload of your DB
* Can create up to 15 Read Replicas
* Data is only written to the main DB

Question 9

Multi-AZ RDS Deployment

Answer 9

• Failover in case of AZ outage (high availability)
• Data is only read/written to the main database
• Can only have 1 other AZ as failover

Question 10

Multi-Region RDS deployment

Answer 10

• Disaster recovery in case of region issue
• Local performance for global reads
• Replication cost

Question 11

What is Amazon ElasticCache?

Answer 11

AWS managed in-memory databases with high performance, low latency that helps reduce load off databases for read intensive workloads

Question 12

DynamoDB

Answer 12

• Fully Managed Highly available with replication across 3 AZ
• NoSQL database - not a relational database
• Scales to massive workloads, distributed “serverless” database
• Millions of requests per seconds, trillions of row, 100s of TB of storage
• Fast and consistent in performance
• Single-digit millisecond latency – low latency retrieval
• Integrated with IAM for security, authorization and administration
• Low cost and auto scaling capabilities
• Standard & Infrequent Access (IA) Table Class

Question 13

DynamoDB Accelerator - DAX

Answer 13

Fully Managed in-memory cache for DynamoDB only

Question 14

DynamoDB – Global Tables

Answer 14

• Make a DynamoDB table accessible with low latency in multiple-regions
• Active-Active replication (read/write to any AWS Region)

Question 15

Redshift

Answer 15

*OLAP
*Columnar Storage
*Massively Parallel Query Execution (MPP)
*SQL
*Data Warehouse
*BI tools intergration

Question 16

Redshift Serverles

Answer 16

• Automatically provisions and scales data warehouse underlying capacity
• Run analytics workloads without managing data warehouse infrastructure
• Pay only for what you use (save costs)
• Use cases: Reporting, dashboarding applications, real-time analytics…

Question 17

Elastic MapReduce (EMR)

Answer 17

*helps creating Hadoop clusters (Big Data) to analyze and process
vast amount of data
* Auto-scaling and integrated with Spot instances
* Use cases: data processing, machine learning, web indexing, big
data…

Question 18

Athena

Answer 18

• Serverless query service to analyze data stored in Amazon S3
• Uses standard SQL language to query the files
• Exam Tip: analyze data in S3 using serverless SQL, use Athena

Question 19

QuickSight

Answer 19

• Serverless machine learning-powered business intelligence service to
  create interactive dashboards
• Fast, automatically scalable, embeddable, with per-session pricing
• Use cases: Business analytics, Building visualizations, Perform ad-hoc analysis, Get business insights using data

Question 20

DocumentDB

Answer 20

*The MongoDB of AWS
*NoSQL
*used to store, query, and index JSON data
* Fully Managed, highly available with replication across 3 AZ
*Automatically scales

Question 21

Amazon Neptune

Answer 21

• Fully managed graph database
• Highly available across 3 AZ, with up to 15 read replicas * Build and run applications working with highly connected
  datasets – optimized for these complex and hard queries
• Great for knowledge graphs (Wikipedia), fraud detection, recommendation engines, social networking

Question 22

Amazon Timestram

Answer 22

• Fully managed, fast, scalable, serverless time series database
• Automatically scales up/down to adjust
  capacity
• Store and analyze trillions of events per day * 1000s times faster & 1/10th the cost of relational databases
• Built-in time series analytics functions (helps you identify patterns in your data in near real-time)

Question 23

Quantum Ledger Database

Answer 23

• Fully Managed, Serverless, High available, Replication across 3 AZ
• Used to review history of all the changes made to your 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 regulation rules

Question 24

Amazon Managed Blockchain

Answer 24

• Amazon Managed Blockchain is a managed service to jJoin public blockchain networks or create your own scalable private network
• Compatible with the frameworks Hyperledger Fabric & Ethereum

Question 25

AWS Glue

Answer 25

• Managed extract, transform, and load (ETL) service
• Useful to prepare and transform data for analytics
• Fully serverless service
• can be used by Athena, Redshift, EMR

Question 26

Database Migration Service (DMS)

Answer 26

• Quickly and securely migrate databases
  to AWS, resilient, self healing
• The source database remains available
  during the migration
  *Supports homogenous and heterogenous migrations