Snowflake SnowPro Core Certification COF-C03 New Questions

SnowPro Core Certification 2026 Exam Questions and Answers

Question 69

What data-type constructs are used to create a hierarchy when organizing semi-structured data? (Select TWO).

Options:

A VARIANT can hold a value of any other data type.

An ARRAY or OBJECT holds a value of type INTEGER.

An ARRAY or OBJECT holds a value of type VARIANT.

An ARRAY or OBJECT holds a value of type VARCHAR.

An ARRAY or OBJECT holds a value of type VECTOR.

Question 70

When a replication schedule is set, how does Snowflake manage refreshes for failover groups?

Options:

Multiple refreshes will run concurrently.

Only one refresh will run at a time.

Refreshes will run regardless of role privileges.

If the current refresh was delayed, the next scheduled refresh will be canceled.

Question 71

The ORDERS table contains 12,000 rows.

Which query will return 10 rows that are randomly sampled from the table every time the query is run?

Options:

select * from ORDERS fetch 10;

select * from ORDERS limit 10;

select * from ORDERS sample (10);

select * from ORDERS tablesample (10 rows);

Question 72

A Finance department must ensure that only users operating with the FINANCE_ANALYST role can see unmasked values in the SALARY column of a sensitive table.

Which feature and configuration should be used?

Options:

Use a row access policy to filter rows based on the role, and apply masking functions in each query.

Use a network policy and masking functions to restrict access to the SALARY column.

Apply one masking policy at the schema level to every column in the schema.

Create a masking policy with conditional role logic and attach the policy to the SALARY column.

Summer Certification Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Snowflake SnowPro Core Certification COF-C03 New Questions

SnowPro Core Certification 2026 Exam Questions and Answers

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

Options:

Answer:

Explanation:

CompTIA

Fortinet

Microsoft

Salesforce