Storage Flashcards
What service can use use to query S3 using SQL syntax
Athena
What analytics service allows you to process data streams in real time with SQL or Apache Flink without having to learn new programming languages or processing frameworks.
Kenesis data analytics
What analytics service provides Scalable and durable real-time data streaming service that can continuously capture gigabytes of data per second from hundreds of thousands of sources.
Kenesis Data Streams
What analytics service is best for ETL
Glue
What analytics service is best for analysing large datasets for monthly roll-ups
Redshift
How many DB Engines can be used with RDS
- SQLServer, Postgres, Oracle, MySql, MariaDB & Aurora
RDS Multi-AZ is best for DR or Performance Improvments?
DR
RDS Read Replicas are best for DR or Performance Improvments?
Performance Improvments for read heavy workloads.
What DB Engines can you use with Aurora?
Mysql & postgresql
Aurora stores replicas in how many AZ’s
3
What AWS DB is best for NoSQL DB’s
DynamoDB
How can DyanamoDB read performance be improved
DynamoDB Accelerator (DAX)
What service can you use if you need a MySQL Database but for very intermittent workloads
Aurora Serverless
Aurora is best for OLAP or OLTP transactions?
OLTP
What Service provides NoSQL DB with ACID?
DynamoDB Transactions