SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ102

Implement Data Protection and Recovery

Assuming that a Data Engineer has all necessary privileges and context, which statements could be used to determine whether the User-Defined Function (UDF) MYDATABASE.SALES.REVENUE_BY_REGION exists and is secure?

Choose two
Explanation

SHOW USER FUNCTIONS returns matching user-defined functions and includes an is_secure output column. The current database’s INFORMATION_SCHEMA.FUNCTIONS view contains one row per defined UDF and exposes IS_SECURE, so filtering it for SALES.REVENUE_BY_REGION determines both the function’s presence and whether it is secure.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!