Question 1

For a business group, you need to create a table with customer demography data in snowflake. Business users will need to do both range and equality searches on the table. Which of the below techniques will you use to speed up the queries.

Options :

A : Create a materialized view on the table and create the required clustering key

B : Turn on search optimization for the table

C : Create a secure view for each of the search access patterns

Answer: A

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

It is a best practice to avoid binding data using Python's formatting function due to the risk of SQL injection.

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

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

Higher Test Marks with Free Online SnowPro-Advanced-Data-Engineer Exam Practice

Buying Options: