Home / Snowflake / COF-C02

Question list

List of questions

Question 1

(0)

Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Question 2

(0)

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file

Question 3

(0)

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?

Question 4

(0)

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Question 5

(0)

What is true about sharing data in Snowflake? (Choose two.)

Question 6

(0)

The following JSON is stored in a VARIANT column called src of the CAR_SALES table: A user needs to extract the dealership information from the JSON. How can this be accomplished?

Question 7

(0)

Which of the following significantly improves the performance of selective point lookup queries on a table?

Question 8

(0)

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

Question 9

(0)

What is a best practice after creating a custom role?

Question 10

(0)

The fail-safe retention period is how many days?

Question 469 - COF-C02 discussion

Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?

Caching

Cluster depth

Query pruning

Retrieval optimization

Show Answer

asked 23/09/2024

Coleman Owie

39 questions

Your answer: A B C D

0 comments

Sorted by