A bank's Apache Iceberg table receives small batches of transaction files every five minutes, and each commit adds more small data files and more snapshots. Athena queries have slowed, and storage costs keep growing because old files are never removed.
The bank must keep the time-travel history it needs for audits, which covers the last 90 days, and it wants the table maintained with Athena rather than by hand.
Which TWO actions meet these requirements? (Choose two.)
Choose two answers.
AA. Run OPTIMIZE on the table on a schedule, which rewrites many small data files into fewer, larger files.
BB. Delete the old data files in the table's S3 prefix with a lifecycle rule that expires objects after 30 days, which removes the files without any Iceberg command.
CC. Turn off snapshots for the table, so that each commit replaces the previous state and the old files are removed immediately.
DD. Run VACUUM on the table on a schedule, which expires old snapshots past the retention window and removes files that no snapshot references.
EE. Convert the table to CSV files every week so that the snapshots are not needed, and drop the Iceberg metadata.
Show the answer and explanation
Answers: A, D
A. Right: Correct. OPTIMIZE rewrites small data files into larger ones, which reduces the file count that queries must open. It keeps the table's data and history intact while improving query speed. Learn more: Optimizing Iceberg tables (opens in a new tab)
B. Wrong: Deleting data files outside Iceberg removes files the table's snapshots still reference, which corrupts the table and breaks time travel. Lifecycle rules work on objects, not on Iceberg snapshots.
C. Wrong: Iceberg snapshots are the mechanism for time travel, and the audit requirement needs them. Removing them would break the 90-day history the bank must keep.
D. Right: Correct. VACUUM expires snapshots older than the table's vacuum_max_snapshot_age_seconds setting and removes files that are no longer part of the table state. Setting that age to 90 days keeps the audit history while storage stops growing. Learn more: Optimizing Iceberg tables (opens in a new tab)
E. Wrong: CSV drops the table format's time travel and schema history, which the audit requirement needs. The option trades the audit history for simpler files, so it fails a stated requirement.
Explanation
Iceberg tables need periodic maintenance. OPTIMIZE compacts small files so queries open fewer objects, and VACUUM expires old snapshots outside the retention window and deletes files that nothing references. Deleting files outside Iceberg, disabling snapshots and converting to CSV each break the audit history or the table itself.
Want more on Open table formats and Apache Iceberg? The 5 full-length practice sets have 10 more Open table formats and Apache Iceberg questions, 325 in all, none of them in the free exam. One payment of $14.99, no subscription. See the practice sets →