SNOW-CAD Platform Features and Integration Practice Question
A ServiceNow instance needs to synchronize data with an external SQL database nightly. Which integration method is most appropriate?
⚠ Common exam trap
Many candidates assume REST APIs are the universal integration method, but for direct SQL database synchronization, JDBC via a MID Server is the native and most efficient approach, while REST would require an additional middleware layer that the external database likely does not provide.
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
✓
Use a MID Server with a JDBC data source.
A MID Server with a JDBC data source is the most appropriate method for nightly batch synchronization with an external SQL database because JDBC provides a direct, efficient, and secure database-level connection without requiring the external database to expose a web service or API. The MID Server acts as a secure proxy, allowing the ServiceNow instance to execute SQL queries against the external database over a persistent, encrypted connection, which is ideal for scheduled bulk data transfers.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a REST API exposed by the external database.
Why it's wrong here
Many databases do not expose a REST API; requires custom development.
- ✓
Use a MID Server with a JDBC data source.
Why this is correct
JDBC provides direct database connectivity through the MID Server.
- ✗
Use a SOAP web service with a MID Server.
Why it's wrong here
SOAP would require a web service interface on the database side, which is uncommon.
- ✗
Use an email-based integration to send CSV files.
Why it's wrong here
Email is not reliable for scheduled large data sync.
Go deeper
Related to this question
About these practice questions
This SNOW-CAD question is part of Courseiva's 481-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.