Question 1

Which schema-level objects allow the user to periodically perform an action under specific conditions, based on data within Snowflake?

Options :

A : Alerts

B : External tables

C : Secure views

D : Materialized views

Answer: A

Question 2

While running a query on a virtual warehouse in auto-scale mode, additional clusters are stated immediately if which setting is configured?

Options :

A : MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters

B : MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters

C : MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters

D : MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters

Answer: C

Question 3

How does the authorization associated with a pre-signed URL work for an unstructured file?

Options :

A : Anyone who has the URL can access the referenced file for the life of the token.

B : Only the user who generates the URL can use the URL to access the referenced file.

C : Only the users who have roles with sufficient privileges on the URL can access the referenced file.

D :

The role specified in the GET REST API call must have sufficient privileges on the stage to access the referenced file using the URL.

Answer: A

Question 4

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Options :

A :

B : Specify the TEMPORARY option when creating the file format.

C :

D : Use the REMOVE command after the load completes.

E : Use the DELETE LOAD HISTORY command after the load completes.

Answer: C,D

Question 5

Which Snowflake edition enables data sharing only through Snowflake Support?

Options :

A : Virtual Private Snowflake

B : Business Critical

C : Enterprise

D : Standard

Answer: A

Higher Test Marks with Free Online COF-C02 Exam Practice