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?

Options :

A : TRUE

B : FALSE

C :

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

Lets say you created a schema and a table as below
CREATE OR REPLACE SCHEMA TIME_TRAVEL_SCHEMA DATA_RETENTION_TIME_IN_DAYS =10;
CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;
Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data

Options :

A : 10

B : 20

C : 30

Answer: A

Question 4

Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?

Options :

A : TRUE

B : FALSE

C : UPDATE

D : INSERT

Answer: B

Question 5

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

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

Buying Options: