Question 1

Your data transfer takes 48 hours. In this case which data transfer mode will you use with Spark connector?

Options :

A : Internal Transfer

B : External Transfer

C : Both can be used

Answer: B

Question 2

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

Options :

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

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?

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

You have just created a table in snowflake. There are now rows in the table. What will be the clustering depth of the table?

Options :

A : 0

B : 1

C : 2

Answer: A

Question 5

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

Options :

A : Standard tables, including shared tables.

B : Views, including secure views

C : Directory tables

D : Query Log Tables

E : External tables

Answer: D

Free SnowPro-Advanced-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: