SNOW-CAD Integrating and managing application data Practice Question
An import set loads data from a CSV file into the staging table successfully, but the transform map does not run. The import set rows show status 'loaded'. What is the most likely cause?
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 map is set to inactive
The transform map is set to inactive, which prevents it from running. Option A is incorrect because the import set table is not empty; rows have been loaded. Option C is incorrect because incomplete field mapping would cause transform errors but not prevent the map from running. Option D is incorrect because a misspelled target table name would likely cause a different issue, such as rows not being created, but the map would still attempt to run.
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 import set table is empty
Why it's wrong here
The rows are loaded, so the import set table is not empty.
- ✓
The transform map is set to inactive
Why this is correct
An inactive transform map does not execute even if data is loaded.
- ✗
The field mapping between source and target fields is incomplete
Why it's wrong here
Incomplete mapping would cause transformation errors but not prevent execution.
- ✗
The transform map's target table name is misspelled
Why it's wrong here
A wrong target table would cause errors during transform, but the transform would still attempt to run.
Go deeper
Related to this question
About these practice questions
One of 481 original SNOW-CAD 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 →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SNOW-CAD 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-CAD exam.