DEA-C02: SnowPro Advanced — Data EngineerDemo

By Snowflake · Question Mode

QuestionQ37

Official exam objectives/topics

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

Choose two
  • A SHOW USER FUNCTIONS LIKE 'REVENUE_BY_REGION' IN SCHEMA SALES;
  • B SELECT IS_SECURE FROM SNOWFLAKE.INFORMATION_SCHEMA.FUNCTIONS WHERE FUNCTION_SCHEMA = 'SALES' AND FUNCTION_NAME = 'REVENUE_BY_REGION'
  • C SELECT IS_SECURE FROM INFORMATION_SCHEMA.FUNCTIONS WHERE FUNCTION_SCHEMA = 'SALES' AND FUNCTION_NAME = 'REVENUE_BY_REGION';
  • D SHOW EXTERNAL FUNCTIONS LIKE 'REVENUE_BY_REGION’ IN SCHEMA SALES;
  • E SHOW SECURE FUNCTIONS LIKE 'REVENUE BY REGION' IN SCHEMA SALES;
Explanation

SHOW USER FUNCTIONS LIKE 'REVENUE_BY_REGION' IN SCHEMA SALES lists accessible UDFs matching that name and returns an is_secure field. The INFORMATION_SCHEMA.FUNCTIONS view for the current database contains a row for each UDF and its IS_SECURE value; therefore, querying it for the SALES schema and REVENUE_BY_REGION identifies both existence and security status. SNOWFLAKE.INFORMATION_SCHEMA refers to the SNOWFLAKE database rather than MYDATABASE; SHOW EXTERNAL FUNCTIONS is limited to external functions; and SHOW SECURE FUNCTIONS is not a supported command.

Learn more

Community Discussion

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