Question 1

Mark the incorrect statement in case Data engineer using the COPY INTO command to load data from files into Snowflake tables?

Options :

A : For Data loading of files with semi-structured file formats (JSON, Avro, etc.), the only supported character set is UTF-16.

B : For loading data from all semi-structured supported file formats (JSON, Avro, etc.), as well as unloading data, UTF-8 is the only supported character set.

C : For Local environment, Files are first copied (“staged”) to an internal (Snowflake) stage, then loaded into a table.

D : UTF-32 & UTF-16 both encoding character sets supported for loading data from de-limited files (CSV, TSV, etc.)

Answer: A

Question 2

Each micro partition contains between 50 mb and 500 MB of uncompressed data

Options :

A : TRUE

B : FALSE

Answer: B

Question 3

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

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

Snowflake does not provide which of following set of SQL functions to support retrieving infor-mation about tasks?

Options :

A : SYSTEM$CURRENT_USER_TASK_NAME

B : TASK_HISTORY

C : TASK_DEPENDENTS

D : TASK_QUERY_HISTORY

E : SYSTEM$TASK_DEPENDENTS_ENABLE

Answer: C