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

Maybe D fits here too because transient tables are used for temporary data but with some persistence, and they might store metadata related to files staged for loading. Directory tables do track file metadata, but I wonder if transient tables hold file-level info when data is staged before final loading. Since external tables are about querying external data and temporary tables don’t persist beyond the session, D could make sense if the question targets file metadata stored temporarily but beyond session scope. Not totally sure though, but it’s worth considering given how transient tables man

It’s A. Directory tables are designed to track file-level metadata specifically for files in stages, which fits the question well. External tables mainly deal with querying external data but don’t store this kind of metadata internally. Temporary and transient tables are about table lifespan, not file metadata. So, if the focus is on metadata storage per file in a stage, directory tables make more sense here.

Option A makes the most sense since directory tables are designed to keep track of file metadata inside stages, unlike external tables which focus on external data sources.

A Directory tables sound like they should store file metadata, fits the question better.

A imo, directory tables sound like they could be related to storing file metadata given the name, but they’re not really a standard Snowflake table type. That leaves external tables as the best fit here.

Amit V. imo, besides the points about transient and temporary tables not relating to file metadata, external tables (B) explicitly deal with referencing data outside Snowflake, which includes storing file-level metadata. Directory isn’t really a Snowflake table type, so A can be dropped for sure. This leaves B as the only logical choice that fits the question’s focus on file-level metadata in stages.

B External tables are designed to reference external data files and store metadata about those files, so they fit better than temporary or transient tables, which focus on data lifecycle inside Snowflake.

Amit V. imo, D doesn’t fit since transient tables are about data lifespan, not file metadata. External tables (B) really seem to be the only ones linked directly to file-level info in stages.

It’s B since external tables track metadata for files in external stages.

Actually, Snowflake doesn’t list “Directory” as a table type, so A is probably out.

Got me thinking about the term "directory" here since it sounds like it deals with file info directly. So I'd say A. Directory.

Wait, they say stage-does that mean external stages only or all stages?