SnowPro Advanced: Architect — Question 144

An Architect needs to define a storage solution for data tables with the following requirements:

1. Has the ability to use Time Travel across the tables.
2. Follows Atomicity, Consistency, Isolation, and Durability (ACID) compliance requirements.
3. The table format supports various query engines.

Which solution meets these requirements?

Answer options

• A. External table with a materialized view
• B. External table with a public Amazon S3 storage-compatible format
• C. Snowflake permanent table format using Enterprise edition
• D. Snowflake Apache Iceberg tables in a non-external format

Correct answer: D

Explanation

The correct answer, D, is appropriate because Snowflake Apache Iceberg tables provide Time Travel capabilities, maintain ACID compliance, and support various query engines. The other options do not fully meet the requirements: A lacks direct Time Travel capability, B does not ensure ACID properties, and C is limited to the Snowflake permanent table without the advanced features of Iceberg.