Question 1

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 2

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 3

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 4

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 5

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

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

Buying Options: