Question 440
For a regulated healthcare organization, this issue must not recur: An engineer sets JSON FILE FORMAT to CSV and loads a nested event record into a one-column raw table. Which review control fits best?
Explanation
Correct Answer
Validate representative nested arrays, nulls and malformed JSON before production loads. This reduces recurrence of: Semi-structured JSON files require compatible parsing rather than CSV delimiter interpretation. The verification should demonstrate: A test nested event retains its structured attributes after COPY and can be queried with path expressions.
Incorrect Answers
Test schema drift and reordered source files before each upstream release. That safeguard is aimed at ANOTHER risk: An operations analyst assumes COPY INTO will map reordered source columns correctly solely because target columns have matching names. It is less targeted than the control for: Semi-structured JSON files require compatible parsing rather than CSV delimiter interpretation.
Audit cloud trust relationships and allowed stage prefixes before onboarding new data. That safeguard is aimed at ANOTHER risk: A data lake S3 bucket is accessed using embedded access keys in a COPY script shared with contractors. It is less targeted than the control for: Semi-structured JSON files require compatible parsing rather than CSV delimiter interpretation.
Include role attribution in connector acceptance tests and audits. That safeguard is aimed at ANOTHER risk: A partner uses an ODBC reporting connector with a role that changes silently after an administrator modifies user defaults. It is less targeted than the control for: Semi-structured JSON files require compatible parsing rather than CSV delimiter interpretation.