Free Snowflake COF-C03 Exam Questions

Become Snowflake Certified with updated COF-C03 exam questions and correct answers

Page: 1 / 40

Total 200 Questions | Updated On: Jun 17, 2026

Add To Cart

Question 1

A company wants to protect sensitive email addresses in a table so that only users with the "HR_ADMIN" role can see the actual values, while all other roles see masked data. They need the masking to be applied dynamically at query time without altering the stored data. Which Snowflake feature should they use?

A : Secure views that filter the email column based on the querying role

B : External tokenization to replace email values with tokens before loading

C : Dynamic data masking using a masking policy applied to the email column

D : Row access policies to filter rows containing email addresses

Answer: C

Question 2

Which of the following statements about Snowflake's access control is true?

A : Access control is based solely on role-based access control (RBAC).

B : A securable object can have multiple owners at any given time.

C : Privileges are assigned directly to users, not roles.

D : Access control uses both discretionary and role-based access control models.

Answer: D

Question 3

What is the function of the AUTO_SUSPEND property of a Virtual Warehouse? Choose one correct value.

A : Specifies if a Virtual Warehouse should be suspended immediately after its created.

B : Specifies whether to automatically resume a warehouse when a SQL statement is submitted to it.

C : Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.

D : Specifies the max threshold of queries after which point a virtual warehouse will be automatically suspended.

Answer: C

Question 4

Which types of notation are used to traverse semi-structured data natively in Snowflake? Select all that apply.

A : Dot notation.

B : Bracket notation.

C : Colon notation.

D : Dollar notation.

Answer: A,B

Question 5

Which of the following values are Snowflake editions? Choose two correct values.

A : Standard

B : Premium

C : Enterprise

D : Economy

E : Plus

Answer: A,C

Page: 1 / 40

Total 200 Questions | Updated On: Jun 17, 2026

Add To Cart