The correct answer is B. Hybrid .
A hybrid table is Snowflake’s table type designed for transactional workloads. Hybrid tables support row-level operations and are optimized for low-latency, high-concurrency transactional access patterns.
Why B is correct:
Hybrid tables are intended for transactional and operational workloads, such as applications that require fast point lookups, inserts, updates, and deletes.
Why the other options are incorrect:
A. Event tables store event and log data generated by Snowflake features such as Snowpark logging and tracing.
C. Dynamic tables are used for automated data transformation pipelines. They are not optimized for transactional workloads.
D. Permanent tables are the standard Snowflake table type for persistent analytical storage, but they are not specifically optimized for transactional workloads like hybrid tables.
Official Snowflake documentation reference:
Snowflake documentation describes hybrid tables as Snowflake tables optimized for transactional workloads that require low-latency reads and writes.
[Reference: Snowflake Documentation — Hybrid tables; Snowflake Documentation — Table types; SnowPro Core Study Guide — SQL and Snowflake Objects., ========================]
