Courseiva
Reporting, SLA and ImportshardMultiple ChoiceObjective-mapped

SNOW-CSA Reporting, SLA and Imports Practice Question

Exhibit

Refer to the exhibit.

Error log:
2024-03-15 14:32:10 (source) Import Set: sys_import_set_2c9a3b1e6f7a8d
2024-03-15 14:32:10 Transform: sys_transform_map_8d7e6f5a4b3c2d
2024-03-15 14:32:10 Target table: incident
2024-03-15 14:32:10 Field mapping: short_description <- co-paste(short_description, ' - ', caller_id)
2024-03-15 14:32:10 Error: Field 'caller_id' not found in source table
2024-03-15 14:32:10 Transform aborted.

A transform map for importing incidents uses a co-paste field mapping for 'short_description' that references the source field 'caller_id'. The import fails with the error shown. What is the most likely cause?

⚠ Common exam trap

A common mix-up: candidates confuse 'source field' (from the import set) with 'target field' (on the destination table), leading them to incorrectly blame the target table's schema or field permissions instead of recognizing the import set column absence.

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 import set does not contain a column named 'caller_id'

The error indicates that the transform map is trying to reference a source field named 'caller_id' via a co-paste field mapping, but the import set table does not contain a column with that name. Co-paste mappings combine source fields from the import set row, so if 'caller_id' is missing from the import set columns, the transform engine cannot find the data and fails. Option B correctly identifies that the import set lacks the required column.

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 'caller_id' field in the target table is read-only

    Why it's wrong here

    Read-only fields would cause a different error.

  • The import set does not contain a column named 'caller_id'

    Why this is correct

    The error indicates the source table lacks the field.

  • The target table 'incident' does not have a 'caller_id' field

    Why it's wrong here

    The error references 'source table', not target.

  • The co-paste function cannot combine more than two fields

    Why it's wrong here

    Co-paste can combine multiple fields.

About these practice questions

One of 504 original SNOW-CSA practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This SNOW-CSA practice question is part of Courseiva's free ServiceNow certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SNOW-CSA exam.