Describe ways to represent data
- Structured data has a schema of typed columns defined before loading, and the database enforces it on write, so a row whose value has the wrong type is rejected.
- Semi-structured data such as JSON or XML labels every value with a key or tag, so records can differ, nest arrays and gain fields without any schema change.
- Unstructured data such as images, audio, video and free text has no internal fields and becomes queryable only after a service extracts metadata into a new dataset.
- Graph data stores entities as vertices and relationships as edges with properties, so questions that follow several hops of relationships run as traversals instead of joins.
- The representation decides the store: Azure SQL Database for structured rows, Cosmos DB for JSON, Blob Storage for files and the Gremlin API for graphs.