Question 490
A ServiceNow administrator finds: A vendor spreadsheet is loaded straight into the CMDB without checking required columns or reference values. The intended correction must preserve access controls, business process consistency and the supported platform configuration. Which administrative change most directly addresses this specific failure?
Explanation
Correct Answer
The decisive detail is: A vendor spreadsheet is loaded straight into the CMDB without checking required columns or reference values. The appropriate control is: Stage imported records into an appropriately configured import set with validated encoding, data source, column mapping and rollback plan. It addresses the risk that importing directly into production business records without staging can corrupt authoritative data or expose malformed content. Check effectiveness with: A sample source file loads into the intended staging table with expected rows and no unintended target changes before transform.
Incorrect Answers
Table extension and inherited task fields: An inherited field change can unintentionally affect multiple child tables or create incompatible workflow assumptions. That mechanism alone cannot establish Data sources import sets and staged ingestion for this question.
Transform maps field mappings and coalescing: Incorrect coalesce keys or skipped field mappings can overwrite unrelated records or multiply business identities. Here the decisive check is Data sources import sets and staged ingestion, not that separate capability.
Transform error handling and import remediation: A successful file upload does not mean transformations passed or that target relationships and mandatory values are correct. The observed issue still requires Data sources import sets and staged ingestion; the proposed alternative tests another control.