CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data engineering team is setting up a new data processing pipeline. They receive data from an external vendor in a format that consists of simple rows of text, where each value is separated by a comma. There are no complex nested structures or metadata within the file; it's purely tabular data. Which file format are they most likely receiving?
- ACSV
- BXML
- CJSON
- DYAML
Show answer & explanationAnswer & explanation
Correct answer: A. CSV
CSV (Comma Separated Values) is a widely used file format for tabular data, where each line represents a row and values within that row are separated by a delimiter, most commonly a comma. This perfectly matches the description of simple, comma-separated, tabular data without nested structures.
Why the other options are wrong
- B. XML uses tags to define elements and attributes, making it more verbose and structured for hierarchical data, not simple tabular data.
- C. JSON supports nested structures and is more complex than simple comma-separated tabular data.
- D. YAML is a human-friendly data serialization standard, often used for configuration, that supports hierarchical data, not typically simple comma-separated tables.
CSV (Comma Separated Values)
A plain-text file format that stores tabular data (numbers and text) in a structured way. Each line in the file is a data record, and each record consists of one or more fields, separated by commas.
- Simple, plain-text format.
- Used for tabular data (rows and columns).
- Values are separated by a delimiter (usually a comma).
- Does not support nested structures or complex data types easily.
Memory trick: CSV is like a 'C'ommon 'S'preadsheet 'V'iew in plain text.