ServiceNowServiceNow
CAD · Question #89
CAD Question #89: Real Exam Question with Answer & Explanation
The correct answer is B: To determine if a record matches an existing record or is a new record. The coalesce field in data imports is used to determine if an incoming record matches an existing record in the target table, guiding whether to update or insert.
Submitted by saadiq_pk· Apr 18, 2026Integrating with Other Applications
Question
What is the purpose of the coalesce field when importing data?
Options
- AWhen a match is found, a new record is inserted
- BTo determine if a record matches an existing record or is a new record
- CIf a match is not found, the existing record is updated
- DTo identify and merge duplicate records
Explanation
The coalesce field in data imports is used to determine if an incoming record matches an existing record in the target table, guiding whether to update or insert.
Common mistakes.
- A. If a match is found using a coalesce field, the existing record is updated, not a new record inserted.
- C. If a match is not found based on the coalesce field, a new record is inserted into the target table, rather than updating an existing one.
- D. While coalescing helps prevent duplicates, its primary purpose is record identification for update/insert logic, not a general 'merge duplicate records' function, which often implies a separate de-duplication process.
Concept tested. Data import coalesce function
Topics
#Import Sets#Coalesce#Data Import#Record Matching
Community Discussion
No community discussion yet for this question.