Question 1

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 2

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 3

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

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?

Options :

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

Which system table will you use to get the total credit consumption over a specific time period?

Options :

A : WAREHOUSE_METERING_HISTORY

B : WAREHOUSE_CREDIT_USAGE_HISTORY

C : WAREHOUSE_USAGE_HISTORY

Answer: A

Confidently Practice Online with Free SnowPro-Advanced-Data-Engineer Exam Cram

Buying Options: