Legit COF-C02 Exam Download

Stored procedures can execute both DDL (Data Definition Language) and DML (Data Manipulation Language) statements.

Example: A stored procedure can create a table (DDL) and insert data into it (DML) in the same execution block.

Other objects like UDFs and UDTFs are limited to returning values or sets of rows, and cannot perform DDL/DML operations.

References:

Snowflake Documentation: Stored Procedures

Resource monitors in Snowflake can perform actions such as suspending a virtual warehouse when its credit usage reaches a defined limit and triggering a notification to account administrators when credit usage reaches a specified threshold. These actions help manage and control resource usage and costs within Snowflake.

References:

Snowflake Documentation: Resource Monitors

The Query Acceleration Service is available starting with the Enterprise Edition of Snowflake.

This feature provides additional compute resources to accelerate query execution without manual scaling.

References:

Snowflake Documentation: Query Acceleration Service

Snowflake Editions Overview

The privilege required on a virtual warehouse to abort any existing executing queries is OPERATE. The OPERATE privilege on a virtual warehouse allows a user to perform operational tasks on the warehouse, including starting, stopping, and restarting the warehouse, as well as aborting running queries. This level of control is essential for managing resource utilization and ensuring that the virtual warehouse operates efficiently.

References:

Snowflake Documentation on Access Control: Access Control Privileges