Assuming a Data Engineer has all appropriate privileges and context, which statements would be used to assess whether the User-Defined Function (UDF), MYDATABASE.SALES.REVENUE_BY_REGION, exists and is secure? (Choose two.)
Assuming a Data Engineer has all appropriate privileges and context, which statements would be used to assess whether the User-Defined Function (UDF), MYDATABASE.SALES.REVENUE_BY_REGION, exists and is secure? (Choose two.)
To assess whether the User-Defined Function (UDF), MYDATABASE.SALES.REVENUE_BY_REGION, exists and is secure, the appropriate statements would be: First, using 'SHOW USER FUNCTIONS LIKE 'REVENUE_BY_REGION' IN SCHEMA SALES;' checks the existence of the UDF in the specified schema, ensuring that you are querying within the correct context. Second, 'SELECT IS_SECURE FROM INFORMATION_SCHEMA.FUNCTIONS WHERE FUNCTION_SCHEMA = 'SALES' AND FUNCTION_NAME = 'REVENUE_BY_REGION';' queries the information schema to check if the function is secure. By combining these two steps, it ensures both the existence and security of the UDF.
SHOW USER FUNCTIONS LIKE 'DAY_NAME_ON' IN SCHEMA DEMO_SCHEMA; SELECT IS_SECURE FROM INFORMATION_SCHEMA.FUNCTIONS WHERE FUNCTION_SCHEMA = 'DEMO_SCHEMA' AND FUNCTION_NAME = 'DAY_NAME_ON';