Free Practice Snowflake SnowPro-Advanced-Data-Engineer Exam Questions 2025

Stay ahead with 100% Free SnowPro Advanced Data Engineer SnowPro-Advanced-Data-Engineer Dumps Practice Questions

Page: 1 / 48

Total 240 Questions | Updated On: Apr 23, 2025

Add To Cart

Question 1

Which is the non-supportable JavaScript UDF data types?

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 2

Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

A : Standard tables, including shared tables.

B : Views, including secure views

C : Directory tables

D : Query Log Tables

E : External tables

Answer: D

Question 3

While using kafka connector, what charges are applied to your account?

A : Snowpipe processing time

B : Data storage

C : Kafka connector usage

Answer: A,B

Question 4

Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?

A : TRUE

B : FALSE

C : UPDATE

D : INSERT

Answer: B

Question 5

Which of the below stored procedure will convert null to string?

A : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE == null) { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

B : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE === null) { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

C : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE === 'null') { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

D : CREATE OR REPLACE PROCEDURE stored_proc_example(TEST_VALUE STRING) RETURNS string LANGUAGE JAVASCRIPT AS $$ if (TEST_VALUE == 'null') { var str = "String is null"; return str; } else { return TEST_VALUE; } $$ ;

Answer: A

Page: 1 / 48

Total 240 Questions | Updated On: Apr 23, 2025

Add To Cart