File types and lifespan: Among common file categories in data processing, which type generally has the shortest life?

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:

  • Master files hold long-lived reference or status data (e.g., customers, inventory).
  • Transaction files capture operational events for posting and audit.
  • Work files are temporary intermediates supporting a job or program step.


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:

Identify the functional purpose of each file type. Assess whether the file must persist across jobs and audit periods. Conclude that temporary work files have the shortest lifespan. Select “Work file.”


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

No comments yet. Be the first to comment!
Join Discussion