APICS Certified Supply Chain Professional (CSCP) — Question 182

A data engineer has realized that they made a mistake when making a daily update to a table. They need to use Delta time travel to restore the table to a version that is 3 days old. However, when the data engineer attempts to time travel to the older version, they are unable to restore the data because the data files have been deleted.
Which of the following explains why the data files are no longer present?

Answer options

• A. The VACUUM command was run on the table
• B. The TIME TRAVEL command was run on the table
• C. The DELETE HISTORY command was run on the table
• D. The OPTIMIZE command was nun on the table
• E. The HISTORY command was run on the table

Correct answer: A

Explanation

The correct answer is A because the VACUUM command permanently removes older versions of data files that are no longer needed, which is why the data engineer cannot restore the table. The other options do not directly cause the deletion of data files; for instance, TIME TRAVEL allows access to older versions without deletion, and the HISTORY command merely shows the past actions without affecting data retention.