SNOW-CAD Platform Features and Integration Practice Question
Which TWO approaches are valid for importing data from an external database into ServiceNow on a recurring basis? (Choose two.)
⚠ Common exam trap
Test-takers frequently confuse 'importing from an external database' with any external data integration, but the question specifically requires direct database import, which mandates JDBC and a MID Server, not REST APIs or email-based methods.
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
✓
Set up a MID Server to run a scheduled transform map from an external SQL query.
A MID Server can execute a scheduled SQL query against an external database and then run a transform map to map the retrieved data into ServiceNow tables. This approach is a standard pattern for recurring data imports using the MID Server's JDBC capabilities combined with scheduled import sets.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Set up a MID Server to run a scheduled transform map from an external SQL query.
Why this is correct
MID Server can execute SQL queries and transform data into ServiceNow.
- ✗
Use a REST API with a periodic flow that calls an external endpoint.
Why it's wrong here
This requires the external system to expose a REST API; not universally available.
- ✗
Write a business rule that triggers on an external event via web service.
Why it's wrong here
Business rules execute on ServiceNow events, not external triggers.
- ✗
Use an email inbound action to parse CSV attachments from the external system.
Why it's wrong here
Email is not reliable for recurring scheduled imports.
- ✓
Configure a JDBC data source and scheduled import set.
Why this is correct
JDBC data source integrates with external databases via MID Server.
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.