Databses

Question 1

Athena

Answer 1

Athena is an interactive query service which enables you to analyse and query data located in S3, using standard SQL.

1. Serverless, nothing to provision, pay per query / per TB scanned
2. No need to set up complex Extract/Transform/Load (ETL) processes
3. Works directly with data stored in S3
    4. Pay per query or per TB scanned.

Question 2

Athena uses

Answer 2

• Used for:
		○ Query log files (ELB/S3 access logs)
		○ Generate business reports on S3 data
		○ Analyze AWS cost and usage reports
		○ Run queries on click-stream data

Question 3

EMR

Answer 3

Amazon EMR is a web service that makes it easy to process large amounts of data efficiently.
• With ERM can run petabyte-scale analysis at