What mechanism in watsonx.data/Iceberg would you configure to automatically remove data older than 90 days from a table?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Data retention in an Iceberg-based lakehouse is typically implemented with COS lifecycle rules (delete files older than N days) combined with Iceberg snapshot retention policies (expire_snapshots) to remove stale metadata.
Full explanation below image
Full Explanation
Data retention in an Iceberg-based lakehouse is typically implemented with COS lifecycle rules (delete files older than N days) combined with Iceberg snapshot retention policies (expire_snapshots) to remove stale metadata. The incorrect options ("An Apache Hive table property specifying max_rows", "A Presto scheduled job that runs DELETE queries on a cron schedule", "An IAM policy that expires data access tokens after 90 days") are distractors that don't fully capture the concept described.