Ace Your COF-C02 SnowPro Core Certification Exam

ACCESS_HISTORY

COPY_HISTORY

QUERY_HISTORY

ROW ACCESS POLICIES

To count the number of characters in a string

To split a string into an array of sub-strings

To split a string and flatten the results into rows

To split a string and flatten the results into columns

To profile how many times a particular query was executed and analyze its u^age statistics over time.

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

Send an alert notification to all account users who have notifications enabled.

Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.