AWS Certified Solutions Architect Associate Database Study Guide

Get Started. It's Free
or sign up with your email address
AWS Certified Solutions Architect Associate Database Study Guide by Mind Map: AWS Certified Solutions Architect Associate Database Study Guide

1. Relational

1.1. RDS

1.1.1. Database Engines Aurora MySQL Edition PostgreSQL Edition 1 day free Automatic Backup 6-way replication across three Availability Zones PostgreSQL MySQL Storage Engines MariaDB Oracle Database SQL Server

1.1.2. Instances Examples db.m5.xlarge db.r5.large db.t2.small Maximum of 40 Instances

1.1.3. Storage Elastic Block Store (EBS) Autoscaling capable Magnetic

1.1.4. Multi-AZ Automatic Failover to Standby Instance

1.1.5. Read Replicas Horizontal Scaling

1.1.6. Backups Automatic Backup 35 day Maximum Retention Period Point-in-time Recovery Database Snapshot Stored indefinitely until explicit deletion

1.1.7. Monitoring performance Management console Metrics IOPS Latency Throughput Que Depth CloudWatch Enhanced Monitoring - Paid Option

1.2. Redshift

1.2.1. Data Warehouse Combine multiple data sources into one - EMR, DynamoDB, or any SSH-enabled host. ETL (Extract, Transform, Load) Amazon Glue AWS Data Pipeline Build your own ETL Pipeline Third-party cloud ETL Service SQL Queries Save Results to S3

1.2.2. Single AZ Deployments Deploys in clusters Up to 128 nodes Concurrency Scaling

1.2.3. Maintains 3 copies of your data Original & Replica on compute nodes Automatic Backup on Amazon S3 1 day retention (Default) 35 day maximum retention Free backup storage equal to your total Redshift storage

1.2.4. Disaster Recovery Asynchronously replicate your snapshots to S3 in another region

1.2.5. Redshift Spectrum Query files in S3 without having to load the data into Redshift tables. Able to run multiple clusters accessing the same data for different use cases.

1.2.6. Metrics - Free of charge AWS Management Console Amazon Cloudwatch

1.2.7. Security Encryption at Rest AES-256 Supports S3 (SSE-KMS) Hardware Security Module (HSM) via Client/Server Certificates Encryption in Transit SSL

2. Non-Relational

2.1. DynamoDB

2.1.1. Database Format NoSQL Key-value Document

2.1.2. Serverless Access via API AWS SDK REST - GET/PUT, etc Access via Console

2.1.3. Capacity Modes Provisioned read/write Use Cases Free Tier Eligible Automatic Scaling Option On-demand Use Cases Pay only for what you use

2.1.4. Synchronously replicates data across three AZs in a Region

2.1.5. Read Consistency Eventually consistent reads (Default) Best Read Performance Strongly consistent reads option Use case: App needs to read an update within 1 second

2.1.6. Encryption at Rest AWS Key Management Service (AWS KMS) Customer Master Key (CMK)

2.1.7. Access Control Web Identity Federation Facebook Google Login with Amazon

2.1.8. Optional paid features Continuous backup (Point-in-time Recovery) Takes continuous backups for the preceding 35 days On-demand backup Takes snapshot backups at specified points in time Restore from backup Restores a table to a specific snapshot or time Global tables Replicates data to create a multiregion, multimaster table DynamoDB Accelerator (DAX) Reduces latency through in-memory cache DynamoDB Streams Provides a time-ordered sequence of item-level changes on a table Data transfer out Transfers data to other AWS regions

3. In-memory

3.1. Elasticache

3.1.1. Caching Engines Redis Multi-AZ with Auto-Failover Back up & Restore Capable Single Cluster mode Multi-Cluster mode Security Disaster Recovery Memcached Up to 20 nodes Intended to speed up dynamic web applications

3.1.2. Pricing Free tier 750 hours per month On-demand nodes Resources you consume by hour Reserved Nodes 1 or 3 year term Discounted hourly usage rate

3.1.3. Use Cases Read-Heavy Application Workloads Social networking Gaming Media Sharing Q&A Portals Compute-Intensive Worloads Recommendation Engine

3.1.4. Free CloudWatch Monitoring

4. Graph

4.1. Neptune

4.1.1. Graph Models Property Graph Query Language W3C's RDF Query Language

4.1.2. Use Cases Applications that work with highly connected datasets Recommendation engines Fraud detection Knowledge graphs Drug discovery Network security

4.1.3. Features Fully managed graph database service High Available Read Replicas Point-in-Time Recovery Continuous Backups to Amazon S3 Replication across AZs Encryption at Rest