Snowflake Updated SOL-C01 Exam Questions and Answers by lawrence

ThePARSE_JSON()function converts a valid JSON string into aVARIANTvalue. This allows Snowflake to store and query nested, hierarchical data using dot and bracket notation.

Example:

SELECT PARSE_JSON('{"name":"John","age":30}') AS data;

After parsing, fields can be accessed like:

data:name or data['age']

Incorrect options:

TO_JSON()converts VARIANT to a JSON string (opposite direction).

CONVERT_JSONandEXTRACT_JSONare not Snowflake functions.

PARSE_JSON is essential for dynamically loading, transforming, or analyzing JSON content from files, streams, or external applications.

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

Snowflake includes severalsystem-defined RBAC rolesto provide structured access control across the platform.

ACCOUNTADMINis the highest-privileged role, governing the entire account, including billing, replication, failover groups, and object ownership inheritance.

SECURITYADMINis responsible for user, role, and privilege management, including granting and revoking roles, password policies, and MFA enforcement. It is essential for identity lifecycle governance.

USERADMINmanages user creation, role creation, and user authentication administration. It is commonly assigned to identity administrators.

CUSTOM_ROLEis not a Snowflake system role; it is a user-created role, allowing organizations to design fine-grained, domain-specific access policies.

These predefined roles form the foundation of Snowflake’s security model and support least-privilege implementations.

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

Snowflake Cortex AI provides built-in AI functions and tools designed to work natively with unstructured and structured data. Two key capabilities are:

• Extract and classify text using functions like PARSE_DOCUMENT, EXTRACT_TEXT, and classification models. Cortex can process documents, identify relevant fields, and convert unstructured content into usable structured formats.

• Simplify unstructured data workflows by combining document extraction, vector search, summarization, and AI reasoning tools (e.g., Cortex Analyst, Cortex Search) directly inside Snowflake without external services.

It does not provide Marketplace data sharing features, which belong to Snowflake’s Data Sharing platform. Loading semi-structured data is a core Snowflake capability using VARIANT and COPY INTO—not Cortex-specific. Enhancing data security is a platform-wide feature, not a Cortex function.

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

A red checkmark in Snowflake Notebooks indicates that the cell encountered anerrorduring execution. This visual indicator helps users quickly identify issues so they can inspect the error message and adjust code accordingly. Successful execution shows a green checkmark, while running cells show a spinner. Snowflake notebooks do not include a “paused” state for notebook cells.

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