Snowflake SnowPro Core Recertification - COF-R02 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Snowflake is designed for which type of workloads? (Choose two.)

A. Concurrent workloads B. OLTP (Transactional) workloads C. OLAP (Analytics) workloads D. On-premise workloads

Discussion 0

Correct Answer: A,C Vote an answer

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

Question 2

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

A. LOGIN_HISTORY B. ACCESS_HISTORY C. OBJECT_HISTORY D. VIEWS_HISTORY

Discussion 0

Correct Answer: B Vote an answer

Question 3

Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

A.

B.

C.

D.

Discussion 0

Correct Answer: C Vote an answer

Question 4

What are the default Time Travel and Fail-safe retention periods for transient tables?

A. Time Travel - 1 day. Fail-safe - 1 day B. Time Travel - 1 day. Fail-safe - 0 days C. Transient tables are retained in neither Fail-safe nor Time Travel D. Time Travel - 0 days. Fail-safe - 1 day

Discussion 0

Correct Answer: B Vote an answer

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

Question 5

Which of the following terms best describes Snowflake's database architecture?

A. Multi-cluster, shared data B. Columnar shared nothing C. Cloud-native shared memory D. Shared disk

Discussion 0

Correct Answer: A Vote an answer

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

Question 6

A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

A. view @my_stage B. show @my_stage C. list @my_stage D. display @my_stage

Discussion 0

Correct Answer: C Vote an answer

Question 7

What affects whether the query results cache can be used?

A. If multiple users are using the same virtual warehouse B. If the query contains a deterministic function C. If the referenced data in the table has changed D. If the virtual warehouse has been suspended

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

A. Customers can change the size of the Warehouse after creation B. A Warehouse can be configured to suspend after a period of inactivity C. A Warehouse can be configured to auto-resume when new queries are submitted D. A Warehouse can be resized while running

Discussion 0

Correct Answer: A,B,C,D Vote an answer

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

Question 9

What is the minimum Snowflake edition required to create a materialized view?

A. Virtual Private Snowflake Edition B. Enterprise Edition C. Business Critical Edition D. Standard Edition

Discussion 0

Correct Answer: B Vote an answer

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

Question 10

Which command can be used to load data into an internal stage?

A. LOAD B. GET C. copy D. PUT

Discussion 0

Correct Answer: D Vote an answer

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

Question 11

Which data type can store more than one type of data structure?

A. VARCHAR B. BINARY C. JSON D. VARIANT

Discussion 0

Correct Answer: D Vote an answer