Snowflake DEA-C01 Exam

Certification Provider: Snowflake

Exam Name: SnowPro Advanced: Data Engineer Certification Exam

Number of questions in our database: 130

Exam Version: May. 31, 2023

DEA-C01 Exam Official Topics:

Topic 1: Single Topic

Free Snowflake DEA-C01 Exam Actual Questions

The questions for DEA-C01 were last updated On May. 31, 2023

Question #1

Which are supported Programming Languages for Creating UDTFs?

APython

BNode.javascript

CJavascript

DJava

EPerl

Reveal Solution

Correct Answer: A, C, D

Question #2

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?

ATRUE

BFALSE

Reveal Solution

Correct Answer: A

Question #3

Select the correct usage statements with regards to SQL UDF?

AThe body of a UDF cannot contain DDL statements or any DML statement other than SELECT.

BScalar functions (UDFs) have a limit of 500 input arguments.

CWhen using a query expression in a SQL UDF, do not include a semicolon within the UDF body to terminate the query expression.

DYou can include only one query expression.

EAll of above are correct.

Reveal Solution

Correct Answer: E

Question #4

Which is the non-supportable JavaScript UDF data types?

AIntegers

BString

CBinary

DDouble

Reveal Solution

Correct Answer: A

Question #5

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?

ATRUE

BFALSE

Reveal Solution

Correct Answer: B

Please note JavaScript is case sensitive but if we are using a JavaScript UDF in a masking policy,

ensure the data type of the column, UDF, and masking policy match.

Unlock all DEA-C01 Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now

Disscuss Snowflake DEA-C01 Topics, Questions or Ask Anything Related

Submit Cancel