DEA-C02 Storage and Data Protection — All Questions With Answers

ALTER TABLE sales_data SET DATA_RETENTION_TIME_IN_DAYS = 5;
-- Later, the user executes:
DROP TABLE sales_data;
-- Then, the user executes:
UNDROP TABLE sales_data;

{
  "cluster_by_keys" : "LINEAR(C1, C2)",
  "total_partition_count" : 1500,
  "total_constant_partition_count" : 100,
  "average_overlaps" : 12.5,
  "average_depth" : 8.4,
  "partition_depth_histogram" : { ... }
}

SELECT 
  TABLE_NAME, 
  TABLE_TYPE, 
  IS_TRANSIENT, 
  RETENTION_TIME 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_NAME = 'SENSITIVE_LOGS';