Analytics
Amazon Athena
Serverless interactive SQL query service for data in Amazon S3 and supported data sources.
Key points
- Queries data without provisioning a database server.
- DVA-C02 requires only narrow data-query recognition because no numbered skill names Athena.
Best-known use cases
- Ad hoc SQL over S3 objects.
What candidates often confuse it with
- Athena queries data in place; OpenSearch Service provides indexed search and analytics.
Key takeaway
Recognize Athena as serverless SQL over S3, not as the default application transaction store.
Related services
- Amazon S3
- Amazon OpenSearch Service
Relevant exam tasks
- D1.3 — Use data stores in application development
- 1.3.9 — Use specialized data stores based on access patterns (for example, Amazon OpenSearch Service)