Snowflake DEA-C01 SnowPro Advanced: Data Engineer Certification Exam Practice Test

Page: 1 / 14
Total 130 questions

Question 1

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

Answer : B

Question 2

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?

Answer : B

Question 3

Which is the non-supportable JavaScript UDF data types?

Answer : A

Question 4

Select the correct usage statements with regards to SQL UDF?

Answer : E

Question 5

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?

Answer : A

Question 6

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

Answer : C

Question 7

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 snow-flake to get the function definition of secure UDF?

Answer : D

Page:    1 / 14   
Total 130 questions