This week covered analytics data stores (Redshift, Athena, DynamoDB, RDS/Aurora) and workload-based store selection. Today we integrate core points and check "workload-to-store mapping" and comparison points frequent on exams.
Service Model Billing Optimal Workload
Redshift columnar MPP provisioning/RA3 large aggregation, complex join DW
Redshift external S3 scan volume query S3 large history without load
Spectrum
Athena serverless scan volume (TB) S3 ad-hoc, intermittent SQL
DynamoDB NoSQL KV throughput/on-demand key-based ms lookup, high concurrency
RDS/Aurora row OLTP instance normalized tran