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: Feb 21, 2026

Add To Cart

Question 1

Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?

A : TRUE

B : FALSE

C :

Answer: A

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

Snowflake computes and adds partitions based on the defined partition column expressions when an external table metadata is refreshed. What are the Correct Statements to configure Partition metadata refresh in case of External Tables?

A : By default, the metadata is refreshed automatically when the object is created.

B : The object owner can configure the metadata to refresh automatically when new or updated data files are available in the external stage.

C : Metadata refresh is not required as its Managed implicitly by Snowflake.

D : Partitions of External tables is managed by External Stage Cloud provider.

E : There is nothing like adding partitions on External tables.

Answer: A,B

Question 5

If a user is granted ROLE-A, what roles he can switch from the Snowflake UI?

A : SYSADMIN, ROLE-A, ROLE-B,ROLE-C,ROLE-D,ROLE-E

B : ROLE-A,ROLE-B,ROLE-C

C : ROLE-A, ROLE-B,ROLE-C,ROLE-D,ROLE-E

D : ROLE-A

Answer: C

Page: 1 / 48

Total 240 Questions | Updated On: Feb 21, 2026

Add To Cart