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

Exactprep COF-C03 Questions

Page: 5 / 84
Total 1160 questions

SnowPro Core Certification 2026 Exam Questions and Answers

Question 17

Which Snowflake database object can be used to track data changes made to table data?

Options:

A.

Tag

B.

Task

C.

Stream

D.

Stored procedure

Question 18

What does a masking policy consist of in Snowflake?

Options:

A.

A single data type, with one or more conditions, and one or more masking functions

B.

A single data type, with only one condition, and only one masking function

C.

Multiple data types, with only one condition, and one or more masking functions

D.

Multiple data types, with one or more conditions, and one or more masking functions

Question 19

What step can reduce data spilling in Snowflake?

Options:

A.

Using a larger virtual warehouse

B.

Increasing the virtual warehouse maximum timeout limit

C.

Increasing the amount of remote storage for the virtual warehouse

D.

Using a common table expression (CTE) instead of a temporary table

Question 20

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Options:

A.

Access control

B.

Fail-safe

C.

Network policies

D.

Time Travel

Page: 5 / 84
Total 1160 questions