Question 1

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

Options :

A : Snowpipe processing time

B : Data storage

C : Kafka connector usage

Answer: A,B

Question 2

Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platform

Options :

A : TRUE

B : FALSE

Answer: A

Question 3

For a particular business group, number of concurrent users are large but do not fluctuate. These users run queries on snowflake and expects extremely low latency response. The queries are all standard and same and need to be served from the result cache to meet the low latency requirement. Which of the below option will you choose?

Options :

A : Provision a multi-cluster warehouse and run it in maximized mode

B : Provision a multi-cluster warehouse and run it in economy mode

C : Provision a small warehouse and monitor the query overload metrics

Answer: A

Question 4

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?

Options :

A : TRUE

B : FALSE

C :

Answer: A

Question 5

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

Smartly Prepare Exam with Free Online SnowPro-Advanced-Data-Engineer Practice Test

Buying Options: