CLF-C02 Cloud Technology and Services Practice Question
Which AWS service provides a fully managed extract, transform, and load (ETL) service that automatically discovers data schemas and generates ETL code?
⚠ Common exam trap
Candidates often confuse AWS Glue's automatic schema discovery and code generation with Amazon EMR's manual big data processing, or they mistake Kinesis Data Firehose's streaming ingestion for ETL capabilities, leading them to overlook Glue's unique serverless ETL features.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
AWS Glue
AWS Glue is a fully managed ETL service that automatically discovers data schemas using its crawler component and generates ETL code via its code generation engine. It integrates with the AWS Glue Data Catalog to store metadata and provides a serverless Spark environment to run ETL jobs without manual infrastructure management.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Amazon EMR
Why it's wrong here
Amazon EMR is a managed cluster platform for big data frameworks such as Spark and Hadoop, but it does not include a schema crawler, Data Catalog, or ETL code generator. You must write your own Spark/Hive code and provision clusters, so while it can perform ETL, it requires significant manual effort for schema discovery and job generation that AWS Glue provides automatically.
- ✗
Amazon Kinesis Data Firehose
Why it's wrong here
Amazon Kinesis Data Firehose is a real-time streaming ingestion service that delivers data to destinations like S3, Redshift, and OpenSearch. It can invoke Lambda functions for simple transformations such as compression or field conversion, but it does not infer schemas, build a data catalog, or generate complex ETL logic. Therefore, it is not designed for the schema discovery and auto-code-generation scenario posed in the question.
- ✓
AWS Glue
Why this is correct
AWS Glue is a serverless data integration service that runs Crawlers to discover source data schemas and populate the Glue Data Catalog, creating a central metadata repository. Using Glue Studio, you can visually build ETL workflows and automatically generate PySpark or Scala scripts, eliminating manual coding overhead. This exact combination of automatic schema discovery, central catalog, and ETL code generation makes Glue the correct answer.
- ✗
AWS Data Pipeline
Why it's wrong here
AWS Data Pipeline is a legacy workflow orchestration service that moves data between sources and destinations using scheduled pipeline definitions written in JSON. It focuses on scheduling and dependency management rather than data understanding, so it cannot automatically discover schemas or generate transformations. You must manually define every activity, schema, and mapping, which does not meet the requirement for automated ETL development.
Quick reference
Cloud Service Model Comparison
| Model | You Manage | Provider Manages | Examples |
|---|---|---|---|
| IaaS | OS, runtime, apps, data | Hardware, hypervisor, networking | EC2, Azure VMs, GCP Compute Engine |
| PaaS | Apps and data | OS, runtime, middleware, hardware | Elastic Beanstalk, Azure App Service |
| SaaS | Data and settings only | Everything else | Microsoft 365, Salesforce, Workday |
| FaaS / Serverless | Function code only | Infra, scaling, runtime | Lambda, Azure Functions, Cloud Run |
| CaaS | Containers and apps | Kubernetes, OS, hardware | EKS, AKS, GKE |
Go deeper
Related to this question
About these practice questions
Courseiva writes every CLF-C02 question from scratch — 993 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This CLF-C02 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 CLF-C02 exam.