CAD practice question 25 of 35
What is the purpose of the coalesce field when importing data?
Full set: 264 questionsIn an import set field map, marking one or more fields as “Coalesce” tells ServiceNow to treat the combination of those field values as a unique key. During transform, the platform compares incoming rows against existing records on that key: if a match exists, the record is updated; if no match exists, a new record is inserted. Thus, the coalesce setting’s sole purpose is to determine whether each incoming row already has a corresponding record or represents a new one.
A. Inserts occur only when no coalesce match is found; a match triggers an update, not an insert.
C. Reverses the logic—the existing record is updated when a match is found, not when one is absent.
D. Coalesce does not merge duplicates across the table; it simply decides update vs. insert during the transform run.
1. ServiceNow Product Documentation → “Import Set Field Map - Coalesce” (Tokyo release), docs.servicenow.com → Now Platform > System Import Sets > Define Field Maps, paragraph 3: “The platform uses coalesce fields to determine if a record exists. If a match is found, the existing record is updated; otherwise, a new record is inserted.”
2. ServiceNow System Administration Courseware, Module “Data Management,” section “Using Coalesce,” p. 18 (Madrid+), explains coalesce as the unique key to decide update vs. insert.
3. ServiceNow Developer Site, Article “Importing Data with Transform Maps,” step 5: “Select Coalesce to have the transform map search for existing records… update on match, insert on no match.”
Keep practicing
Take the free CAD practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other CAD practice questions
- Question 1Which options are strategies for debugging client-side scripts? Choose 2 answers
- Question 2Which of the following is a good practice for adding instructions to a form?
- Question 3Identify characteristic(s) of a Record Producer. Choose 3 answers
- Question 4Exportitem table is extended from Item table with the additional column of ItemCountry ad…
- Question 5Which one of the following is the fastest way to create and configure a Record Producer?
- Question 6On what part of the ServiceNow instance, would you find the option to Impersonate User?
