SNOW-CSA Reporting, SLA and Imports Practice Question
A company imports employee data from an HR system weekly. The import set table always retains the data from previous imports, causing storage issues. The administrator wants to automatically delete the import set rows after a successful transform to free up space. Which configuration should be made?
⚠ Common exam trap
The trap here is that candidates may over-engineer a solution by choosing a scheduled job or business rule, not realizing that ServiceNow provides a simple, built-in checkbox on the transform map to handle automatic cleanup after transform.
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
✓
Select the 'Cleanup after transform' checkbox on the transform map.
Selecting the 'Cleanup after transform' checkbox on the transform map instructs the platform to automatically delete the import set rows from the staging table once the transform has completed successfully. This directly addresses the storage issue caused by retaining all historical import data, without requiring manual or scheduled cleanup.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Select the 'Cleanup after transform' checkbox on the transform map.
Why this is correct
This native option automatically deletes import set rows after a successful transform.
- ✗
Create a scheduled job to delete old import set rows.
Why it's wrong here
This is a manual workaround and less efficient than the built-in option.
- ✗
Set a retention policy on the import set table.
Why it's wrong here
Import set tables do not have a built-in retention policy configuration.
- ✗
Use a business rule to delete the import set row after transform.
Why it's wrong here
A business rule is not the designated mechanism for automatically deleting import set rows after a successful transform. This specific cleanup is handled by a dedicated setting within the import process itself, such as a data retention policy or an "on complete" script on the transform map, which is purpose-built for managing the import set table's lifecycle. It is tempting because business rules automate actions based on record events; they are effective for manipulating individual record data, enforcing policies, or triggering workflows *during* or *after* record operations, for instance, updating a related record or validating data on the staging table before transformation.
Go deeper
Related to this question
About these practice questions
Courseiva writes every SNOW-CSA question from scratch — 504 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-CSA 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-CSA exam.