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
What AWS DB is best for MongoDB migrations
Document DB
What service can be used for MongoDB migrations to DocumentDB
AWS DMS
What service is best for apache cassandra, big data, nosql
Keyspaces
AWS’s Graph DB is called…
Neptune
AWS’s Ledger DB is called
Quantum Ledger DB
AWS DB for analysing timeseries data
Timestream
S3 Max single file size
5TB
What are the 3 “at-rest” encryption options for S3
SSE-S3, SSE-KMS & SSE-C
How can you structure S3 buckets to improve performance
Spread across folders
How can you improve S3 upload performance
Multi part uploads
How can you improve S3 download performance
Byte Range Fetches
What AWS Services are event notification destinations for S3 buckets
SQS, Lambda, SNS
How can you improve the performance of DynamoDB during peak loads by dynamically adjusting provisioned throughput capacity on your behalf, in response to actual traffic patterns
DynamoDB Autoscaling
