Answer: Permanent Tables, Materialized Views

According to Snowflake documentation and the community consensus, Fail-safe protection is available for Permanent Tables (A) and Materialized Views (D). Permanent tables explicitly have Fail-safe as documented, and Materialized Views, being persistent objects that store pre-computed query results, also receive Fail-safe protection. Temporary Tables (B) and Transient Tables (E) do not have Fail-safe as they are designed for short-term data. External Tables (C) are not protected by Fail-safe since they reference external files and do not store data within Snowflake's managed storage.

Author: LeetQuiz Editorial Team