Snowflake Updated SOL-C01 Exam Questions and Answers by mari

Standard permanent tables in Snowflake have a default1-day Time Travel retention period. During this period, users may query historical data, restore dropped tables, or clone past states. Higher editions allow extending this period up to 90 days. Temporary and transient tables have 0-day retention by default.

====================================================

In Snowflake’s Secure Data Sharing model, the accountsharingdata is known as thedata provider. Providers create shares that include selected objects (tables, views, secure views, etc.) and grant access to consumer accounts.

Adata consumerreceives the shared data.Data readeranddata administratorare not defined terms in Snowflake’s sharing architecture.

==================

ADatabaseis the highest logical container for schemas and their objects in Snowflake.

Hierarchy:

Account → Database → Schema → Tables, Views, Stages, etc.

Schemas organize objects within a database; tables and views do not contain objects.

====================================================

Unstructured data such as PDF files, images, and other binary documents is stored in stages in Snowflake. These stages may be internal stages, which Snowflake manages directly, or external stages, which reference external cloud storage such as Amazon S3, Azure Blob Storage, or Google Cloud Storage. Stages are the designed mechanism for storing and accessing unstructured files so that they can be processed with functions like PARSE_DOCUMENT or accessed via directory tables.

External tables are used to query structured or semi-structured data (for example, Parquet or JSON) stored in external locations, not to store raw unstructured binary content. The Cloud Services layer coordinates metadata, security, and query services; it does not store user data. Tables with a single VARCHAR column might be used as an improvised approach for small text blobs, but this is not the native or recommended method for managing unstructured data at scale.

==================