New Release COF-C02 SnowPro Core Certification Questions

The SAMPLE clause allows users to retrieve a randomly selected subset of rows from a table.

Syntax:

SELECT * FROM my_table SAMPLE (10 ROWS);

This statement selects 10 random rows from my_table.

Why Other Options Are Incorrect:

A. AVERAGE(<num> ROWS): Does not exist; AVERAGE() is an aggregate function for numeric columns.

B. MEDIAN(<num> ROWS): Does not exist; MEDIAN() calculates the median value of a numeric column.

D. RANDOM(<num> ROWS): No such function in Snowflake for selecting rows.

References:

Snowflake SAMPLE Clause

In Snowflake streams, the METADATASACTION column indicates the type of data manipulation operation that has occurred. The possible values include INSERT and DELETE.

INSERT: Indicates that a new row has been inserted into the table.

DELETE: Indicates that a row has been deleted from the table.

References:

Snowflake Documentation: Change Data Capture (CDC) with Streams

Snowflake Documentation: Stream Data Capture

A pre-signed URL in Snowflake grants access to unstructured files (e.g., in external stages) without requiring additional authentication.

The URL includes an embedded token that specifies the expiration time and access permissions.

Key Point: Anyone who has the pre-signed URL can access the referenced file for the duration of the token’s validity.

Why Other Options Are Incorrect:

B. Only the user who generates the URL can use it: The URL is shareable and not restricted to its creator.

C. Users with roles and privileges: Pre-signed URLs bypass direct role or privilege checks.

D. Role specified in GET REST API call: This is unrelated to pre-signed URL access.

References:

Pre-Signed URLs Documentation