A data analyst needs to compare current sales figures with sales as they appeared 30 days ago. Which Iceberg feature enables this comparison?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Iceberg time travel allows querying a table's state at any past point: SELECT * FROM table FOR SYSTEM_TIME AS OF TIMESTAMP '...' — the engine resolves the appropriate historical snapshot without any data duplication.
Full explanation below image
Full Explanation
Iceberg time travel allows querying a table's state at any past point: SELECT * FROM table FOR SYSTEM_TIME AS OF TIMESTAMP '...' — the engine resolves the appropriate historical snapshot without any data duplication. The incorrect options ("Schema evolution — adding new columns with historical default values", "Partition evolution — changing the partition scheme to include historical date buckets", "Compaction — merging old snapshot files into a single current-state file") are distractors that don't fully capture the concept described.