An investigator queries S3 data only a few times per month.
Avoid an always-running warehouse and pay for the data scanned by each query.
Which data store is most appropriate?
Use Amazon Athena for serverless, pay-per-scan SQL over data stored in S3.
Detailed explanation
A key-value design and full migration are not suitable for arbitrary analytical SQL.
A key-value design and full migration are not suitable for arbitrary analytical SQL.
Infrequent queries still incur cluster capacity and operational costs.
Infrequent queries still incur cluster capacity and operational costs.
Athena queries S3 without a continuously running cluster and suits occasional analysis.
Athena queries S3 without a continuously running cluster and suits occasional analysis.
A queue can trigger processing but is not a historical SQL analytics store.
A queue can trigger processing but is not a historical SQL analytics store.
Check official documentation
Compare the following points with the official documentation.
Amazon AthenaのS3、料金、パーティション、ワークグループの公式説明を確認する。
What to confirm
アドホック分析と常時ウェアハウス、キーDB、キューの違いを説明できる。
Key points
- Athena
- S3
- Ad hoc query
- Scan cost
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Pay-per-scan
Columnar formats and partition predicates reduce bytes scanned and query cost.
Warehouse versus serverless
Frequency, concurrency, latency, and management needs determine whether a persistent warehouse is justified.