DP-900 Describe core data concepts Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  CSV → JPEG → JSON

  Why it's wrong here

  CSV placed first is appropriate, but listing JPEG before JSON misclassifies a semi-structured format as less structured than an unstructured binary image. JSON retains discoverable field names and hierarchical organization, making it substantially more structured than JPEG, whose visual content is encoded as pixels rather than data attributes. The correct sequence should shift JSON into the second position, immediately after CSV.

  When this WOULD be correct

  If the question asked to order from least to most structured, then JPEG (unstructured) → JSON (semi-structured) → CSV (structured) would be correct, making A the right choice.

• ✗

  JSON → CSV → JPEG

  Why it's wrong here

  Here the semi-structured JSON is placed ahead of CSV, even though CSV's fixed, uniform columns and explicit schema make it strictly more structured than JSON's flexible key-value records. Reversing CSV and JSON would fix the relative ordering at the front of the sequence; JPEG is correctly last since it is unstructured. The error is therefore not about the image, but about failing to recognize that tabular data carries a stronger schema guarantee than nested JSON objects.

  When this WOULD be correct

  If the question asked for data types from least to most structured, or if the JSON file contained only flat key-value pairs with no nesting and the CSV had inconsistent columns, then JSON could be considered more structured than CSV.

• ✓

  CSV → JSON → JPEG

  Why this is correct

  CSV is the most structured because it enforces a tabular schema—every row has the same ordered columns and each field is a scalar value. JSON is semi-structured: it uses named key-value pairs and can nest arrays/objects, but no fixed schema is required and structure can vary per record. JPEG is unstructured: its binary encoding represents compressed pixel data, not queryable fields or relationships. Ordering them most-to-least structured therefore must place CSV first, JSON second, and JPEG last.

• ✗

  JPEG → JSON → CSV

  Why it's wrong here

  This sequence inverts the structural hierarchy by beginning with JPEG, an unstructured binary format that lacks separable data fields, and ending with CSV, the only format with a strict row-and-column schema. JSON's key-value pairs sit between the two in structure, but it is wrongly placed second. To order from most to least structured, the sequence must start with CSV and end with JPEG; as written, it ranks the least structured format as the most.

  When this WOULD be correct

  If the question asked to order data types from least to most structured, then D (JPEG → JSON → CSV) would be correct, as JPEG is unstructured, JSON semi-structured, and CSV structured.

Option-by-option analysis

Why each answer is right or wrong

Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.

Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”

Go deeper

Related to this question