CompTIA Data+ (DA0-002)Data Concepts and EnvironmentsMedium
A data engineering team is migrating a legacy system's configuration files. These files contain hierarchical key-value pairs, often with nested structures, and need to be easily readable and modifiable by both humans and machines. The team wants a format that is well-supported by web APIs and modern programming languages for data interchange. Which file format is the most appropriate choice?
- ASQL
- BCSV
- CXML
- DJSON
Show answer & explanationAnswer & explanation
Correct answer: D. JSON
JSON (JavaScript Object Notation) is a lightweight, human-readable format for data interchange that supports hierarchical key-value pairs and nested structures. It is widely adopted by web APIs and programming languages.
Why the other options are wrong
- A. SQL is a language for managing and querying relational databases, not a file format for data interchange.
- B. CSV is for tabular data and does not support hierarchical or nested structures.
- C. XML supports hierarchical data but is often considered more verbose and less lightweight than JSON for modern web APIs.
JSON (JavaScript Object Notation)
A lightweight data-interchange format that is easy for humans to read and write and easy for machines to parse and generate.
- Based on key-value pairs and ordered lists of values (arrays).
- Supports nested structures, making it suitable for complex, hierarchical data.
- Widely used for web APIs and configuration files due to its simplicity and broad language support.
Memory trick: Think of data interchange formats as universal languages for computers to talk to each other, some more verbose, some more direct.