Objective and core distinction
Data is recorded information about entities, events or observations. A representation gives that information an organization. Structured data follows a defined schema, commonly typed columns in rows. Semi-structured records have an organization but may allow different properties or nested collections. Unstructured content, such as an audio recording, does not itself follow that same tabular attribute schema. Classify the representation in front of you rather than the subject it describes. A table about songs and the song recording can have different structures. Also distinguish a missing value from a missing column:nullable values do not erase a declared table schema. Your objective is to justify a classification from explicit features and to check what an alternative representation preserves.
Worked example
Fictional teaching case:a neighbourhood history project has an audio interview, a fixed catalogue row with InterviewId and RecordingDate, and a document containing a variable collection of speaker annotations. Begin by separating the three objects. The audio carries the spoken content; the catalogue gives a stable set of attributes; the annotation document groups properties and collections that can vary between interviews. They may share an identifier without sharing a representation. Suppose the project exports only the catalogue row. That export preserves the catalogue facts but does not preserve the interview itself or every annotation. Check the conclusion by listing which information can still be recovered from each object. Do not treat a link to content as though it contains the content.
Changed condition and misconception
Now the project gives every annotation the same required columns in a relational table. That new representation has a defined schema even if some optional values are NULL. The earlier document representation does not force every later copy to remain semi-structured. Conversely, putting a recording filename into a spreadsheet does not make the recording’s internal content a table. Representation and storage product are separate questions. JSON can express hierarchical objects and collections, but a file extension alone does not tell you whether an application imposes a fixed schema. Inspect the actual contract and values before making the classification.
Transfer check
Try this:a biodiversity club stores a sound clip, a CSV with a fixed header describing clips, and a separate set of variable nested observations. Which two statements would you make before recommending an export? Check basis:first identify the structure and purpose of each representation; then identify which facts and associations the receiving application must retain. A flat summary may be useful without being a complete substitute for the source. Explain one fact that an export would lose, and one schema fact that would remain. Use the four linked formal tasks afterward; their job is to test a new case, not repeat this project’s answer.
Try it, then explain it.
Complete a short set without looking at the example. After each answer, explain which evidence or rule supports your decision and why the alternatives do not fit.
Sources & authorship
Original OpenExam explanations and examples. References support the concepts; they are not the source of copied questions. Independent educator review is pending.
Identify data formats - Training | Microsoft LearnExplore file storage - Training | Microsoft LearnUnderstand relational data - Training | Microsoft Learn