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