SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ90

Data Storage and Processing

An Architect must define a storage solution for data tables that meets the following requirements:

  1. Supports using Time Travel across the tables.
  2. Meets Atomicity, Consistency, Isolation, and Durability (ACID) compliance requirements.
  3. Uses a table format that supports multiple query engines.

Which solution satisfies these requirements?

Explanation

Apache Iceberg is an open table format that supports ACID transactions and snapshot-based table history. Snowflake-managed Apache Iceberg tables support Time Travel, and the open Iceberg format enables access from compatible external query engines, satisfying interoperability requirements.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!