Match each AWS data analytics service to its primary function.
Drag a concept onto its matching description — or click a concept then click the description.
Serverless SQL query on S3
Business intelligence and dashboards
Data lake setup and access control
Real-time SQL on streaming data
Query data in S3 from Redshift
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Amazon Athena: Query data in Amazon S3 using standard SQL
The correct matches are: Amazon Athena for serverless SQL querying on S3, Amazon Redshift for data warehousing, Amazon EMR for big data processing, and Amazon Kinesis for real-time streaming. Common confusions include swapping the roles of Athena and Redshift.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Amazon Athena: Query data in Amazon S3 using standard SQL
Why this is correct
Athena is an interactive query service that allows you to analyze data directly in S3 using SQL, without managing infrastructure.
Amazon Redshift: Fully managed data warehouse for analytics
Why this is correct
Redshift is a petabyte-scale data warehouse service designed for running complex analytical queries on structured and semi-structured data.
Amazon EMR: Process large datasets using Apache Hadoop and Spark
Why this is correct
EMR is a managed big data platform that simplifies running distributed frameworks like Hadoop, Spark, and HBase for large-scale data processing.
Amazon Kinesis: Real-time streaming data ingestion and processing
Why this is correct
Kinesis is a set of services for real-time data streaming, including data ingestion, processing, and analysis as it arrives.
Amazon Athena: Fully managed data warehouse
Why it's wrong here
Incorrect — this describes Amazon Redshift, not Athena. Athena is a serverless query service, not a data warehouse.
Amazon Redshift: Query data in S3 using SQL
Why it's wrong here
Incorrect — this describes Amazon Athena, not Redshift. Redshift is a data warehouse that stores data locally, though it can query external data via Redshift Spectrum.
Quick reference
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
Go deeper
About these practice questions
One of 1,321 original DEA-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DEA-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C01 exam.