COF-C02 by Snowflake Actual Free Exam Questions And Answers

Question 1

For the ALLOWED VALUES tag property, what is the MAXIMUM number of possible string values for a single tag?

A. 10

B. 256

C. 50

D. 64

Discussion 0

Correct Answer: B Vote an answer

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

Question 2

What persistent data structures are used by the search optimization service to improve the performance of point lookups?

A. Search access paths

B. Clustering keys

C. Micro-partitions

D. Equality searches

Discussion 0

Correct Answer: A Vote an answer

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

Question 3

What is the MINIMUM Snowflake edition required to use object tagging?

A. Enterprise

B. Standard

C. Business Critical

D. Virtual Private Snowflake (VPS)

Discussion 0

Correct Answer: A Vote an answer

Question 4

User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

A. SHOW GRANTS TO USER INQUISITIVE_PERSON

B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING

C. SHOW GRANTS ON ROLE DATA_SCIENCE

D. SHOW GRANTS OF ROLE DATA_SCIENCE

Discussion 0

Correct Answer: B Vote an answer

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

Question 5

Which Snowflake database object can be shared with other accounts?

A. Secure User-Defined Functions (UDFs)

B. Tasks

C. Stored Procedures

D. Pipes

Discussion 0

Correct Answer: A Vote an answer

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

Question 6

In Snowflake, what allows users to perform recursive queries?

A. LATERAL

B. QUALIFY

C. CONNECT BY

D. PIVOT

Discussion 0

Correct Answer: A Vote an answer

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

Question 7

Which strategy for optimizing virtual warehouse performance should be used to speed the execution of a very large query?

A. Increase the size of the warehouse.

B. Convert to a multi-cluster warehouse.

C. Use the query acceleration service.

D. Enable the search optimization service.

Discussion 0

Correct Answer: C Vote an answer

Question 8

When resizing a currently running virtual warehouse, what happens to in-progress queries?

A. In-progress queries will be cancelled.

B. Queries will continue running, using the current warehouse size.

C. Queries will continue running, using the new warehouse size.

D. Queries will be paused and automatically reprocessed using the new warehouse size.

Discussion 0

Correct Answer: B Vote an answer

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

Question 9

Which object provides a list of the files stored in a stage?

A. Directory table

B. Materialized view

C. Semantic view

D. Information schema

Discussion 0

Correct Answer: A Vote an answer

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

Question 10

How can a Snowflake user validate data that is unloaded using the COPY INTO < location > command?

A. Load the data into a CSV file.

B. Load the data into a relational table.

C. Use the validation mode = return rows statement.

D. Use the VALlDATlON_MODE - SQL statement.

Discussion 0

Correct Answer: D Vote an answer

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

Snowflake SnowPro Core Certification - COF-C02 Exam Practice Test

Contact Us

Useful Links

Latest Updated