AIF-C01 Fundamentals of AI and ML Practice Question
An ML engineer wants to store training data in a format optimized for linear data scanning and columnar access in SageMaker. Which format is most appropriate?
⚠ Common exam trap
AWS often tests the misconception that CSV is the most efficient format for training data, but Parquet's columnar storage and compression provide superior performance for linear scanning and columnar access in distributed ML pipelines.
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
✓
Parquet
Parquet is a columnar storage format optimized for both linear data scanning and columnar access, making it ideal for training data in SageMaker. It reduces I/O by storing data by columns rather than rows, enabling efficient retrieval of specific features during model training.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
JSON
Why it's wrong here
JSON is row-oriented and stores each record as a nested text object, so reading a single column requires parsing every record, defeating columnar access. It suits semi-structured or sparse data exchange. Columnar formats such as Parquet or RecordIO-Protobuf give the linear scanning and column access required.
- ✗
Image (JPEG/PNG)
Why it's wrong here
JPEG and PNG store pixel arrays for image data, not tabular records with named columns, so columnar access and linear scanning of features are impossible. They are correct for computer vision training sets. Tabular training data optimised for columnar reads needs a format such as Parquet.
- ✓
Parquet
Why this is correct
Parquet is a columnar format, so SageMaker reads only the columns a query needs and scans them linearly, cutting I/O versus row-based formats. This matches the stated requirement for columnar access and efficient linear scanning of training data.
- ✗
CSV
Why it's wrong here
CSV is row-oriented plain text, so reading a single column still scans every row and requires parsing, defeating columnar access. Parquet stores data columnar with compression and predicate pushdown, which is what linear scanning and column-selective reads in SageMaker training require.
Go deeper
Related to this question
About these practice questions
One of 862 original AIF-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 →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This AIF-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 AIF-C01 exam.