Snowflake COF-C02 Questions Answers

SnowPro Core Certification Exam Questions and Answers

Question 65

What is the difference between a stored procedure and a User-Defined Function (UDF)?

Stored procedures can execute database operations while UDFs cannot.

Returning a value is required in a stored procedure while returning values in a UDF is optional.

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

Question 66

If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?

1 minute

2 minutes

6 minutes

8 minutes

Question 67

What privilege should a user be granted to change permissions for new objects in a managed access schema?

Grant the OWNERSHIP privilege on the schema.

Grant the OWNERSHIP privilege on the database.

Grant the MANAGE GRANTS global privilege.

Grant ALL privileges on the schema.

Question 68

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.

A Data Exchange allows groups of accounts to share data privately among the accounts.

A Data Exchange allows accounts to share data with third, non-Snowflake parties.

Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.

The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.