SNOW-CAD Integrating and managing application data Practice Question
Which TWO are best practices when implementing data integrations using ServiceNow import sets?
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
✓
Schedule the import to run during off-peak hours
Options A and D are correct. A: Scheduling imports during off-peak hours minimizes impact on system performance and user experience. D: Using coalesce in the transform map on a unique field prevents duplicate records by matching existing records based on that field. B is incorrect because REST API is an alternative integration method, not a performance improvement over import sets. C is incorrect because update sets are used to move configurations between instances, not to manage import set configurations. E is incorrect because while staging tables are commonly used, they are not always required for all data sources.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Schedule the import to run during off-peak hours
Why this is correct
Scheduling minimizes impact on system performance.
- ✗
Use REST API instead of import sets for better performance
Why it's wrong here
REST API is an alternative, not a best practice for import sets specifically.
- ✗
Use update sets to manage import set configurations
Why it's wrong here
Update sets are for application configuration versioning, not specifically for import sets.
- ✓
Use coalesque in the transform map to avoid duplicates
Why this is correct
Coalescing ensures existing records are updated instead of duplicated.
- ✗
Always use a staging table for all data sources
Why it's wrong here
Staging tables are not necessary for all data sources (e.g., real-time web services).
Go deeper
Related to this question
About these practice questions
Courseiva writes every SNOW-CAD question from scratch — 481 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. 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.