Free Snowflake SnowPro-Core Actual Exam Questions - Question 3 Discussion

Probably A. Directory tables sound like they’re meant for organizing files or unstructured data given the name. The others (permanent, transient, temporary) seem more about how long the data sticks around rather than what kind of data they hold. So if the question is about supporting unstructured data specifically, directory tables might be the best fit since they could be designed to work with files or blobs directly. The rest are more general-purpose table types that can contain unstructured data but aren’t necessarily specialized for it.

It’s C. Temporary tables can store unstructured data just like permanent ones, but they’re session-scoped and disappear after use. So the key difference isn’t data type support, but lifetime.

Makes sense that transient tables (B) also handle unstructured data since they support all data types, just with different retention policies than permanent ones.

D imo, permanent tables are the default choice for storing unstructured data using VARIANT columns, since transient and temporary tables focus more on data retention than data type support.

It’s definitely not A since “Directory” isn’t actually a Snowflake table type. Between B, C, and D, temporary and transient tables are more about data lifecycle, not structure. Unstructured data like JSON or XML typically lives in permanent tables because they’re designed for long-term storage and querying. So D fits best since permanent tables with VARIANT columns handle unstructured data reliably.

B imo, unstructured data can be in transient tables too, not just permanent ones.

It’s D. Snowflake stores unstructured data like JSON or XML right in permanent tables using VARIANT, OBJECT, or ARRAY data types. The other table types mostly refer to data lifespan or session use, not the data format itself. “Directory” isn’t an official table type in Snowflake as far as I know, so that option seems off. Permanent tables give you full functionality for querying and managing unstructured data alongside structured rows.

It’s A because transient, temporary, and permanent tables deal with structured data storage duration, not specifically unstructured data. Directory tables are the ones meant for files and unstructured formats.

A. Directory tables are meant to handle unstructured data like files, while the others focus more on how long data lives or session scope. That’s why A fits best here.

It’s A for sure. Snowflake's Directory table is designed to hold unstructured data like files and blobs. The other options (Transient, Temporary, Permanent) are more about data retention and aren’t specifically about unstructured data. Transient and Temporary just determine how long data sticks around; they don’t handle unstructured formats explicitly. So A stands out here as the real fit for unstructured stuff.