DEA-C01 practice - PrepKeys

Q1 Multiple choice

Assuming a Data Engineer has all appropriate privileges and context which statements would be used to
assess whether the User-Defined Function (UDF), MTBATA3ASZ. SALES .
REVENUE_BY_REGION, exists and is secure? (Select TWO)

Select all that apply.

A
SHOW DS2R FUNCTIONS LIKE 'REVEX'^BYJIESION' IN SCHEMA SALES;
B
SELECT IS_SECURE FROM SNOWFLAKE. INFCRXATION_SCKZMA. FUNCTIONS WHERE
FUNCTI0N_3CHEMA = 'SALES' AND FUNCTI CN_NAXE = tEVEXUE_BY_RKXQH4;
C
SELECT IS_SEC"JRE FROM INFOR>LVTICN_SCHEMA. FUNCTIONS WHERE
FUNCTION_SCHEMA = 'SALES1 AND FUNGTZON_NAME = ' REVENUE_BY_REGION';
D
SHOW EXTERNAL FUNCTIONS LIKE `REVENUE_BY_REGION'IB SCHEMA SALES;
E
SHOW SECURE FUNCTIONS LIKE 'REVENUE 3Y REGION' IN SCHEMA SALES;