Table of Contents
Question
Which Snowflake table is an implicit object layered on a stage, where the stage can be either internal or external?
A. Directory table
B. Temporary table
C. Transient table
D. A table with a materialized view
Answer
A. Directory table
Explanation
The correct answer is A. Directory table.
A directory table is a Snowflake table that is an implicit object layered on a stage, where the stage can be either internal or external. A directory table allows querying the metadata and contents of the files in the stage using standard SQL statements.
A stage is a named location where data files are stored for loading into or unloading from Snowflake tables. A stage can be either internal or external, depending on where the data files are located. An internal stage is a stage that is managed by Snowflake and uses Snowflake’s cloud storage service. An external stage is a stage that references an external location, such as an Amazon S3 bucket, a Microsoft Azure container, or a Google Cloud Storage bucket.
A directory table is created automatically when a stage is created, and it has the same name as the stage. A directory table has a predefined schema that includes columns such as name, size, type, md5, and metadata for each file in the stage. A directory table can be queried like any other Snowflake table, using SELECT, JOIN, WHERE, GROUP BY, and other SQL clauses.
The other options are incorrect because:
- B. Temporary table. This is false because a temporary table is not an implicit object layered on a stage, but rather an explicit object created by the user. A temporary table is a table that exists only for the duration of the user session that created it, and it is automatically dropped when the session ends. A temporary table does not depend on any stage, and it can store any data that the user inserts into it.
- C. Transient table. This is false because a transient table is not an implicit object layered on a stage, but rather an explicit object created by the user. A transient table is a table that persists until it is explicitly dropped by the user, but it does not have the same data protection and failover guarantees as a permanent table. A transient table does not depend on any stage, and it can store any data that the user inserts into it.
- D. A table with a materialized view. This is false because a table with a materialized view is not an implicit object layered on a stage, but rather an explicit object created by the user. A materialized view is a precomputed result set that is derived from one or more base tables using a query expression. A materialized view can improve query performance by storing and refreshing the query results periodically, rather than executing the query every time. A materialized view does not depend on any stage, and it can reference any base table that the user defines in the query expression.
Snowflake SnowPro Core certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core exam and earn Snowflake SnowPro Core certification.