ExamGecko
Home / Snowflake / DEA-C01
Ask Question

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

Question list
Search

Question 121

Report
Export
Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 122

Report
Export
Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 123

Report
Export
Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 124

Report
Export
Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 125

Report
Export
Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 126

Report
Export
Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 127

Report
Export
Collapse

Select the correct usage statements with regards to SQL UDF?

Become a Premium Member for full access
  Unlock Premium Member

Question 128

Report
Export
Collapse

Which is the non-supportable JavaScript UDF data types?

Become a Premium Member for full access
  Unlock Premium Member

Question 129

Report
Export
Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 130

Report
Export
Collapse

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

Become a Premium Member for full access
  Unlock Premium Member
Total 130 questions
Go to page: of 13