Databases

Question 1

What are DBs used for?

Answer 1

To stored structured data in AWS

Question 2

What are relational db’s used for?

Answer 2

• Related data with SQL queries

- Can be scaled up

Question 3

What are NoSql DB’s used for?

Answer 3

• Flexible schemas
• data not related between tables
• Flexibility, scalability, very high performance
• Can be scaled out <== Key
• JSON data storage

Question 4

What are AWS Managed Databases?

Answer 4

• Very useful because the DB infrastructure is handled by AWS (Backups, Operations, Upgrades, Monitoring, Alerts)
• Multi AZ for disaster recovery
• Replicas, Dashboards
• If you install a DB on EC2, you have to do all this

Question 5

What is AWS RDS?

Answer 5

• Relational Database Service
• AWS Managed
• Performance is better than a customer-managed database instance.
• Read replicas for increased performance / horizontal scaling - can be multi-region
• Multi-AZ for high availability - replicate to another AZ
• Can choose from PostgreSQL, MySQL, Oracle, SQL Server, Aurora
• Cannot SSH to DB instance

Question 6

What is Amazon Aurora?

Answer 6

• Proprietary AWS RDS
• Cloud optimized
• can auto-grow as data grows
• no free tier

Question 7

What is ElastiCache?

Answer 7

• In memory DB
• High performance
• Reduce load on databases by handing certain requests
• AWS managed

Question 8

What is DynamoDB?

Answer 8

• AWS managed NOSQL DB
• Server-less
• Scalable to massive workloads
• Extremely low-latency retrieval - fast
• DynamoDB Accelerator: Super Fast
• Low cost

Question 9

What is RedShift?

Answer 9

• OLAP (On line Analytical Processing)
• Analytics and Data Warehousing
• Columnar data store
• Can store huge amounts of data
• SQL queries, dashboards

Question 10

What is EMR?

Answer 10

• AWS Elastic Map Reduce
• Hadoop clusters - hundreds of EC2 instances
• Process vast amounts of data
• Use: data processing, machine learning, big data

Question 11

What is Athena?

Answer 11

• Server-less db to query S3 data

- Use: one-time SQL queries, S3 log analytics

Question 12

What is AWS Glue?

Answer 12

• Serverless
• ETL : extract, transform, load service
• Data Catalog of datasets
• Prepare and transform data for analytics
• Data-wrangling - data from different sources (S3, RDS)

Question 13

What is DMS?

Answer 13

• Data Migration Service
• Migrate data from 1 DB to another
• Homogeneous - same to same (oracle to Oracle)
• Heterogeneous - from one to another (SQL server to Aurora)

Question 14

What is AWS Quicksight?

Answer 14

• Create dashboard for analytics

- Integrates with RDS, Aurora, Redshift….

Question 15

What is DocumentDB?

Answer 15

• a no-sql database

- based on MongoDB

Question 16

What is Amazon Neptune?

Answer 16

• managed graph database

Question 17

What is QLDB?

Answer 17

• Quantum Ledger Database (financial transactions/ledger)
• review history of all changes made to data
• 1 organization
• not decentralized, only 1 database - this is different from blockchain

Question 18

What is AWS Managed Blockchain?

Answer 18

• blockchain: HyperLedger Fabric, Ethereum
• decentralized
• multi-organinzation?