SAA-C03 Q326 · Analytics

Question

A company’s reporting system delivers hundreds of .csv files to an Amazon S3 bucket each day. The company must convert these files to Apache Parquet format and must store the files in a transformed data bucket. Which solution will meet these requirements with the LEAST development effort?

Accepted Answer

**Option B: AWS Glue crawler + ETL job** meets all requirements with the least development effort:

1. **AWS Glue Crawler** automatically discovers the schema of the CSV files in S3 — no manual schema definition needed. It populates the AWS Glue Data Catalog with table metadata.

2. **AWS Glue ETL Job** provides a fully managed, serverless environment for data transformation. Converting CSV to Parquet is a **built-in capability** — you simply specify the output format as Parquet in the job configuration.

3. **Least development effort** is the critical requirement here:
   - Glue can auto-generate the ETL script (Python/Scala) via the visual editor or console
   - No infrastructure to provision, manage, or scale
   - No custom code needed for the CSV-to-Parquet conversion — this is a nativ

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips