Pass the Snowflake SnowPro Advanced Certification SOL-C01 Questions and answers with CertsForce

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.

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

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.

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

To create a new schema in Snowsight, users must follow the hierarchical navigation of Snowflake’s object structure. The correct sequence is:

Data → Database → Create Schema

Steps:

Open theDatatab in the left navigation.

Select aDatabasewhere the schema will be created.

ChooseCreate → Schema.

Enter the schema name and (optionally) description.

ClickCreate.

Incorrect options:

“Add Data” is used for loading files, not creating schema objects.

“Data → Create Schema” is incomplete because Snowflake must knowwhich databasethe schema belongs to.

“Data Product” is unrelated to object creation.

Thus, Snowflake requires explicit database context before schema creation.

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

The correct SQL command for creating a new database in Snowflake isCREATE DATABASE database_name;. This initializes a new logical container for schemas and objects. USE DATABASE switches the active database context but does not create one. Snowflake does not support the shorthand CREATE DB or USE DB syntax. Therefore, CREATE DATABASE is the correct and only valid command for creating a database.

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