Difficulty: Easy
Correct Answer: Work file
Explanation:
Introduction / Context:
Different file types serve different purposes in data processing. Understanding their typical lifespans helps with storage planning, backup strategies, and governance. Some files are permanent system assets, while others are ephemeral artifacts created during processing and discarded soon after use.
Given Data / Assumptions:
Concept / Approach:
A work file (also called a scratch or temporary file) is created during processing to hold intermediate results such as sorted subsets, joins, or checkpoints. Its lifespan is confined to the job/step that created it; once the process completes, the file is deleted or overwritten. By contrast, master and program files are persistent, and transaction files are retained at least until posting, reconciliation, and audit requirements are met.
Step-by-Step Solution:
Verification / Alternative check:
Job-control scripts and ETL pipelines routinely mark work areas as temporary, excluded from backup retention policies beyond the job window.
Why Other Options Are Wrong:
Master and program files are durable assets; transaction files require retention for posting and audit trails.
Common Pitfalls:
Accidentally persisting large work files, causing storage bloat; failing to encrypt temporary files holding sensitive data.
Final Answer:
Work file
Discussion & Comments