SnowPro Core Certification Exam (COF-C02) Free Practice Test

Question 1

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

A. UNION ALL

B. LIMIT

C. ORDER BY

D. PARTITION BY

E. GROUP BY

Correct Answer: C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

When using the COPY INTO < location > command to unload table data into a CSV file, which option would compress the file using the default algorithm?

A. SNAPPY

B. DEFLATE

C. NONE

D. AUTO

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Which resource monitor setting will cancel all active queries in a virtual warehouse when the threshold is met?

A. NOTIF

B. SUSPEND_IMMEDIATE

C. SUSPEND

D. NOTIFY_USERS

Correct Answer: B

Question 4

Which chart type is supported in Snowsight for Snowflake users to visualize data with dashboards?

A. Heat grid

B. Pie chart

C. Area chart

D. Box plot

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory?
(Select TWO).

A. Partitions scanned

B. Bytes spilled to remote storage

C. Bytes spilled to local storage

D. Bytes scanned

E. Percentage scanned from cache

Correct Answer: B,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

A. 14 days

B. 60 minutes

C. 24 hours

D. 30 days

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

When a schema is cloned, what will happen if the schema includes a table with a column that references a sequence that generates default values? (Select TWO).

A. If the table and sequence are in the same schema, the cloned table will reference the cloned sequence.

B. If the table and sequence are in different schemas, the cloned table will reference the source sequence.

C. If the table and sequence are in the same schema, the cloned table will reference the source sequence.

D. If the table and sequence are in different schemas, the cloned table will no longer have a default value for the column.

E. If the table and sequence are in the same schema, the cloned table will use the most-recently generated value from the source sequence.

Correct Answer: B,C

Question 8

Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?

A. Search optimization service

B. Data classification

C. Query acceleration service

D. Tagging

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

A. Column-level security to apply data masking policies to tables and views

B. Up to 90 days of data recovery through Time Travel

C. Customer-managed encryption keys through Tri-Secret Secure

D. Object-level access control

E. Automatic encryption of all data

Correct Answer: D,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 10

What Snowflake features are recommended to restrict unauthorized users from accessing Personal Identifiable Information (PII)? (Select TWO).

A. Secure views

B. Multi-Factor Authentication (MFA)

C. Data encryption

D. Transient tables

E. Dynamic Data Masking

Correct Answer: A,E

Welcome to TestSimulate

Snowflake SnowPro Core Certification (COF-C02) Free Practice Test