Analytics / App Integration / Database / Storage Flashcards
Amazon Athena
Query service that analyzes semi-structured and structured data (CSV, JSON, etc) from S3 using standard SQL queries. Is a serverless service and pay only for the queries. Is integrated aout-of-the-box with Amazon Glue data catalog.
Amazon EMR stands for:
Elastic Map Reduce.
Amazon Kinesis 4 versions
Video Strams, Data Streams, Firehose and Data Analytics
Sources from Kinesis Video Streams are:
Smartphines, Security Cams, Webcams, Cars, Drones, and Industrial Sources.
Whats can be done with Kinesis Data Streams
Collect large and process streams of records in REAL TIME.
What is the DIFF between Data Streams and Firehose?
Firehose is ONLY used to deliver data to another AWS services such as S3, Redshift, OpenSearch, Splunk, etc. It can Also TRANSFORM data befor delivering it.
Which LANGUAGE does Kinesis Data Analitycs supports
SQL
What service Amazon OpenSearch Services replaces?
ElasticSearch
What is Amazon QuickSight?
Its a BI service. Can build dashboards, connect data and its a managed service. Something similar to PowerBI or Tableau
What is Amazon AppFlow used for?
Transfer data from SaaS into AWS. Sources can be Saleforce, Slack, Zendesk and many more.
Whats service does Amazon EventBridge replaces?
Amazon CloudWatch Events
What is the AWS event bus?
Amazon EventBridge (CloudWatch Events)
What is the EventBridge workflow?
Recieves an EVENT > applies a RULE > trigger and action to a TARGET.
Which engines does RDS supports?
MariaDB, SQL Server, MySQL, Oracle and PostgreSQL
Top differences between Aurora and RDS
RDS have a 99.95 SLA, but AURORA hava 99.99
RDS supports up to 5 recplicas, while AURORA up to 15
RDS does NOT support automatically failover, while AURORA does
When is recommended to use AURORA Serverless
Variable workloads,
Multi-tenant apps,
New Apps,
Mixed-use Apps,
Capacity planning,
Development and testing
What service can you use to MIGRATE a NoSQL database?
AWS Database Migration Service
Whats is the AWS implementation of MongoDB?
DocumentDB
What is the caching service for DynamoDB
DynamoDB Accelerator (DAX
Whats the diff between DocumentDB and DynamoDB
DocumentDB is the “middleground” between Mongo and Dynamo, both are Managed Services.
What engines does Amazon ElastiCache supports?
Redis and Memcached
Whats is MemoryDB used for?
Both in-memory performance and Multi-AZ durability, MemoryDB can be used as a high-performance primary database for your microservices applications, eliminating the need to separately manage both a cache and durable database.
What is AWS redshift used for?
Data warehouse
What service is used to centralize the backup management across AWS?
AWS Backups