Question 40
A data architect recommends this approach: Apply a defined schema with data type validation before loading records. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for Schema enforcement. Invalid values are detected instead of silently corrupting typed fields.
Incorrect Answers
The other situation is better matched to Treat the video streams as unstructured data and store searchable metadata independently. The audiovisual payload is not inherently a relational collection of typed fields.
The other situation is better matched to Treat XML as a semi-structured hierarchical format. Tags identify fields while nested and optional elements describe variable structures.
The other situation is better matched to Treat the export as structured data with a documented tabular schema. Known field types and names enable predictable validation and SQL-style processing.