The scale factor parameter limits the maximum number of resources (parallel threads) that the Query Acceleration Service can use. It helps control costs by bounding resource usage during query acceleration.
Reference:
Snowflake Docs: Query Acceleration Service

The correct answer is C. PARSE_JSON .
PARSE_JSON parses a valid JSON-formatted string and returns a VARIANT value. This is commonly used when inserting semi-structured JSON data into a VARIANT column.
Why C is correct:
A VARIANT column can store semi-structured data such as JSON objects and arrays. When the source value is a JSON string, PARSE_JSON converts it into a Snowflake VARIANT.
Example:
CREATE TABLE json_table (
src VARIANT
);
INSERT INTO json_table
SELECT PARSE_JSON( ' { " customer_id " : 101, " region " : " WEST " } ' ); Why the other options are incorrect:
A). TO_JSON converts a VARIANT value into a JSON string. It is commonly used in the opposite direction.
B). TO_VARCHAR converts a value to a string, not to a semi-structured VARIANT.
D). OBJECT_INSERT inserts or updates a key-value pair inside an existing object, but it is not the primary function used to parse JSON text into a VARIANT column.
Official Snowflake documentation reference:
Snowflake documentation describes PARSE_JSON as a function that interprets an input string as JSON and returns a VARIANT value.
Reference: Snowflake Documentation - PARSE_JSON; Snowflake Documentation - Semi-structured data types; SnowPro Core Study Guide - Working with Semi-Structured Data.
==

The correct answer is C. Rotation .
Key-pair authentication uses a public/private key pair to authenticate users or applications. To improve security, keys should be replaced periodically or when there is a possibility that a key has been exposed. This process is called key rotation .
Why C is correct:
Key rotation allows an organization to replace active keys with new keys. In Snowflake, users can have public keys assigned for key-pair authentication, and rotating keys helps maintain secure authentication practices.
Why the other options are incorrect:
A). Authentication is the overall process of verifying identity, not the specific feature for replacing keys.
B). Passkeys are a different authentication mechanism and are not the feature used to replace active key-pair authentication keys.
D). Time-based one-time passcodes are associated with MFA, not key-pair replacement.
Official Snowflake documentation reference:
Snowflake documentation describes key-pair authentication and includes key rotation as a security practice for replacing public/private key pairs.
Reference: Snowflake Documentation - Key-pair authentication; Snowflake Documentation - Key rotation; SnowPro Core Study Guide - Security and Access Control.
==

When creating a Snowpark-optimized virtual warehouse in Snowflake, the minimum size requirement is Small. Snowpark is designed to handle data processing workloads efficiently, and the Small size ensures adequate resources for such tasks.
Virtual Warehouse Sizes:
Snowflake offers different sizes for virtual warehouses, ranging from X-Small to 6X-Large.
Each size corresponds to a specific level of compute resources.
Minimum Size Requirement for Snowpark:
A Small virtual warehouse is the minimum size required to optimize performance and resource allocation for Snowpark workloads.
This ensures that the warehouse has sufficient capacity to handle data processing and transformation tasks efficiently.
Snowflake Documentation: Virtual Warehouse Sizes