Snowflake DEA-C01 Practice Test - Questions Answers, Page 13
List of questions
Related questions
Question 121

Which UDF programming language is not supported with Snowflake Secure Data Sharing feature?
Question 122

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

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?
Question 124

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?
Question 125

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

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?
Question 127

Select the correct usage statements with regards to SQL UDF?
Question 128

Which is the non-supportable JavaScript UDF data types?
Question 129

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?
Question 130

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