Question 80
A supplier sends mixed CSV and nested JSON under one directory, and automatic schema inference changes unpredictably. Which change most directly addresses the operational problem?
Explanation
Correct Answer
Split source streams by format and enforce explicit parsing and schema contracts. This is the most directly relevant remediation because format-specific decoders cannot safely infer a single stable structure from mixed files. A concrete acceptance check is: Both inputs produce separately validated canonical bronze records. To reduce recurrence: Keep per-source landing zones and schema versioning.
Incorrect Answers
Unreviewed source DDL can invalidate a maintained ingestion schema. Here the important technical distinction is that format-specific decoders cannot safely infer a single stable structure from mixed files.
Nontransactional file writes can expose partial output when a batch crashes. That consideration does not remove the current constraint: format-specific decoders cannot safely infer a single stable structure from mixed files.
Direct cloud object credentials grant broader storage access than the intended shared table contract. In this situation, format-specific decoders cannot safely infer a single stable structure from mixed files.