Snowflake SnowPro Associate: Platform Certification SOL-C01 Exam Questions

Page: 1 / 14
Total 214 questions
Question 1

What is the SHOW GRANTS SQL command primarily used for?



Answer : B

SHOW GRANTS lists privileges assigned to roles, users, objects, or shares. It is essential for permissions auditing and RBAC management.

SHOW USERS lists users, not privileges.

Warehouse usage is in ACCOUNT_USAGE views.

Load history is retrieved via COPY_HISTORY or LOAD_HISTORY.


Question 2

What is the primary purpose of Snowflake's Cloning feature?



Answer : B

Snowflake's Cloning feature provides the ability to create azero-copyclone of tables, schemas, or entire databases. This means that the cloned object references the same underlying micro-partition data as the original, so no duplicate storage costs are incurred upon creation. Instead, Snowflake uses metadata pointers to reference the existing data. If changes occur in the original or cloned objects, Snowflake performs copy-on-write operations to maintain isolation while still optimizing storage. This cloning mechanism is extremely valuable for development, testing environments, analytics validation, and troubleshooting historical states. It is not a real-time backup tool; backup and restore are handled through Time Travel and Fail-safe. Cloning does not grant or manage permissions nor copy the entire Snowflake account; it works solely at the database, schema, and table object levels.

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


Question 3

Where is unstructured data stored in Snowflake?



Answer : B

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.

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


Question 4

What is the purpose of assigning roles to users in Snowflake?



Answer : A

Snowflake uses a Role-Based Access Control (RBAC) model, whererolesare the containers of privileges. Assigning roles to users ensures that permissions on database objects (such as tables, schemas, warehouses, and functions) are enforced consistently and securely. Users do not receive privileges directly; instead, privileges are granted to roles, and roles are assigned to users.

This enables scalable, auditable, and manageable access control.

Roles do not determine tasks, do not affect query optimization, and do not govern which data types a user may query---permissions are object-based, not datatype-based.

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


Question 5

Which option can be used to specify the delimiter for a CSV file in the COPY INTO

command?



Answer : C

The correct Snowflake parameter for defining a CSV delimiter during data loading is FIELD_DELIMITER. This option can be set within a named file format or specified inline in a COPY INTO command, such as FIELD_DELIMITER = ',' for comma-separated files or FIELD_DELIMITER = '\t' for tab-delimited data. Snowflake does not recognize DELIMITER, SEPARATOR, or COLUMN_DELIMITER as valid parameters. FIELD_DELIMITER ensures that Snowflake accurately splits each row into separate fields based on the chosen delimiter. Without the right delimiter definition, the COPY INTO operation would treat entire rows as a single string, causing misalignment with the table structure. FIELD_DELIMITER is essential when handling CSV or TSV files, particularly when ingesting data from external systems, cloud storage, or partner feeds. Snowflake's flexibility with file formatting---combined with parallel loading and automatic error-handling---makes COPY INTO an optimized solution for structured data ingestion.

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


Question 6

How is the initial activation of the Snowflake Data Exchange feature, which is necessary for establishing private exchanges, typically accomplished?



Answer : B

The Data Exchange feature is not automatically enabled for all Snowflake accounts. Instead, enabling this capability---particularly for private exchanges---typically requires submitting a request toSnowflake Support. Snowflake evaluates account type, region, and compliance requirements before enabling the Data Exchange functionality. Snowflake administrators cannot independently enable this through Snowsight, nor is there a SQL command available to turn it on. Once activated, account administrators can create private exchanges, manage listings, and define which Snowflake accounts can participate. This activation step ensures secure, intentional use of data-sharing capabilities at an account level.

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


Question 7

What is the primary purpose of the CLASSIFY_TEXT function in Cortex?



Answer : D

TheCLASSIFY_TEXTfunction performscategory assignmentfor free-form text. Users provide a list of predefined labels, and the function predicts the most appropriate category using a Snowflake-optimized LLM. It is ideal for automatically tagging customer feedback, routing support tickets, labeling product reviews, classifying email content, and segmenting operational logs.

The function outputs both the predicted label and an associated confidence score, enabling downstream filtering, dashboarding, and automated processing.

Other options belong to different Cortex functions:

TRANSLATEhandles multilingual translation.

COMPLETEgenerates natural language completions.

PARSE_DOCUMENTextracts structured information from documents.

Thus, CLASSIFY_TEXT is task-specific and optimized specifically for classification workloads.


Page:    1 / 14   
Total 214 questions