COF-C02 Snowflake Exam Questions and Free Practice Test

Question 25

- (Topic 1)
When is the result set cache no longer available? (Select TWO)

A. When another warehouse is used to execute the query

B. When another user executes the query

C. When the underlying data has changed

D. When the warehouse used to execute the query is suspended

E. When it has been 24 hours since the last query

Correct Answer:CE
The result set cache in Snowflake is invalidated and no longer available when the underlying data of the query results has changed, ensuring that queries return the most current data. Additionally, the cache expires after 24 hours to maintain the efficiency and accuracy of data retrieval1.

Question 26

- (Topic 3)
When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

A. When users will be using compute at different times throughout a 24/7 period

B. When managing a steady workload

C. When the compute must be available with no delay or lag time

D. When the user does not want to have to manually turn on the warehouse each time it is needed

E. When the warehouse is shared across different teams

Correct Answer:BC
Disabling auto-suspend for a virtual warehouse is recommended when there is a steady workload, which ensures that compute resources are always available. Additionally, it is advisable to disable auto-suspend when immediate availability of compute resources is critical, eliminating any startup delay

Question 27

- (Topic 4)
Which views are included in the DATA SHARING USAGE schema? (Select TWO).

A. ACCESS_HISTORY

B. DATA_TRANSFER_HISTORY

C. WAREHOUSE_METERING_HISTORY

D. MONETIZED_USAGE_DAILY

E. LISTING TELEMETRY DAILY

Correct Answer:DE
The DATA_SHARING_USAGE schema includes views that display information about listings published in the Snowflake Marketplace or a data exchange, which includes DATA_TRANSFER_HISTORY and LISTING_TELEMETRY_DAILY2.

Question 28

- (Topic 3)
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

A. Auto-scale mode

B. Maximized mode

C. Economy scaling policy

D. Standard scaling policy

Correct Answer:A
In Snowflake, when queries begin to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately if the warehouse is set to auto-scale mode. This mode allowsSnowflake to automatically add or resume additional clusters as soon as the workload increases, and similarly, shut down or pause the additional clusters when the load decreases

Question 29

- (Topic 4)
While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?

A. GET_PRESIGNED_URL

B. GET_ABSOLUTE_PATH

C. BUILD_STAGE_FILE_URL

D. BUILD SCOPED FILE URL

Correct Answer:C
The BUILD_STAGE_FILE_URL function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs2.

Question 30

- (Topic 1)
How often are encryption keys automatically rotated by Snowflake?

A. 30 Days

B. 60 Days

C. 90 Days

D. 365 Days

Correct Answer:A
Snowflake automatically rotates encryption keys when they are more than 30 days old. Active keys are retired, and new keys are created. This process is part of Snowflake??s comprehensive security measures to ensure data protection and is managed entirely by the Snowflake service without requiring user intervention.
References:
✑ Understanding Encryption Key Management in Snowflake

START COF-C02 EXAM