SNOW-CAD Integrating and managing application data Practice Question
A company uses a scheduled import from an external database to update the user table nightly. Recently, the import has been failing with a timeout error after 30 minutes. The import set contains 50,000 records. What should the administrator do to resolve this issue?
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
✓
Split the import into multiple smaller batches.
The best course of action because splitting the import into smaller batches reduces the processing time per batch and avoids timeout, addressing the root cause.
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 transform map to skip unnecessary fields.
Why it's wrong here
Skipping fields may reduce processing time slightly but not enough to avoid timeout with 50k records.
- ✓
Split the import into multiple smaller batches.
Why this is correct
Smaller batches each complete within the timeout, and the total processing remains feasible.
- ✗
Increase the timeout value in the scheduled import configuration.
Why it's wrong here
Increasing timeout only delays the failure; the underlying issue of large data volume remains.
- ✗
Upgrade the instance to a larger size.
Why it's wrong here
Upgrading the instance size increases compute and memory resources, but the timeout error occurs because the scheduled import operation exceeds the 30-minute system-level execution limit for a single import set run, regardless of instance tier. This option is tempting because larger instances do improve performance for sustained high-throughput processing, and would be correct if the failure were due to resource exhaustion (e.g., CPU or memory pressure) rather than a hard timeout on import duration.
Visual reference
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.