Snowflake DEA-C01 Practice Test - Questions Answers, Page 13

While creating even Secure UDF, snowflake recommended to use randomized identifiers (e.g. generated by UUID_STRING) instead of sequence-generated values?

When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared with Snowflake accounts, Snowflake returns a NULL value for these functions?

Bob, a Lead Data Engineer is looking out to get the function definition & queried below statement to check if this function is secure enough to use in his script or not.

select is_secure from information_schema.functions where function_name = 'JOHNFUNCTION';

From the query output he is sure that, Function is secure UDF, what are the way provided by snowflake to get the function definition of secure UDF?

A SQL UDF evaluates an arbitrary SQL expression and returns the result(s) of the expression. Which value type it can returns?

For SQL UDFs, The invoker of the function need not have access to the objects referenced in the function definition, but only needs the privilege to use the function?

Select the correct usage statements with regards to SQL UDF?

Which is the non-supportable JavaScript UDF data types?

If using a JavaScript UDF in a masking policy, Data Engineer needs to ensure the data type of the column, UDF, and masking policy match irrespective of case-sensitivity?

External Function is a type of UDF & can be Scaler or Tabular?