Working with Data →easyMultiple ChoiceObjective-mapped

SNOW-CAD Working with Data Practice Question

Exhibit

{
  "import_set": "ISET001",
  "staging_table": "u_cmdb_ci_computer_staging",
  "target_table": "cmdb_ci_computer",
  "field_map": [
    {"source": "u_name", "target": "name"},
    {"source": "u_serial_number", "target": "serial_number"},
    {"source": "u_model_id", "target": "model_id", "coalesce": true}
  ]
}

Refer to the exhibit. A transform map configuration is shown. What will happen if the source data has a 'u_model_id' value that matches an existing record in the 'cmdb_ci_model' table?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The transform will automatically set the model_id reference to the existing model record.

When coalesce is set to true on a reference field like 'model_id', the transform engine uses the source value (u_model_id) to look up an existing record in the referenced table (cmdb_ci_model). If a matching record is found, the transform sets the reference field to that existing record without creating a new one. Option A is incorrect because coalesce does not ignore the field; it actively searches for a matching record. Option B is incorrect because coalesce does not create new records; it only matches existing ones. Option D is incorrect because the transform does not skip the record; it proceeds with the transformation, setting the reference to the existing model.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
The transform will ignore the field because it is already mapped.
Why it's wrong here
Coalesce actively looks up the reference.
✗
The transform will create a new model record with the given value.
Why it's wrong here
Coalesce only matches existing records; it does not insert.
✓
The transform will automatically set the model_id reference to the existing model record.
Why this is correct
Coalesce uses the source value to match a record in the referenced table and sets the reference.
✗
The transform will skip the record because the model already exists.
Why it's wrong here
Coalesce does not skip records; it maps the reference.

Go deeper

SNOW-CAD Working with Data Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question