Free Snowflake SnowPro-Advanced-Data-Engineer Exam Questions

Become Snowflake Certified with updated SnowPro-Advanced-Data-Engineer exam questions and correct answers

Page: 1 / 48

Total 240 Questions | Updated On: Nov 14, 2024

Add To Cart

Question 1

Which of the following System keeps the following characteristics?

a. It will keep in it all the raw data.

b. Generally, the users of it is data scientists and data developers.

c. Flat architecture

d. Highly agile

A : Data Warehouse

B : Data Mart

C : Data Lake

D : Data Hub

Answer: C

Question 2

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

Question 3

Which is the non-supportable JavaScript UDF data types?

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 4

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?

A : TRUE

B : FALSE

Answer: A

Question 5

The smaller the average depth, the better clustered the table is with regards to the specified column?

A : TRUE

B : FALSE

Answer: A

Page: 1 / 48

Total 240 Questions | Updated On: Nov 14, 2024

Add To Cart