Question 1

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

Options :

A : TRUE

B : FALSE

Answer: B

Question 2

Which of the following objects are automatically created by the KAFKA connector?

Options :

A : One internal stage to temporarily store data files for each topic.

B : One pipe to ingest the data files for each topic partition.

C : One table for each topic

D : One external stage to temporarily store data files for each topic.

Answer: A,B,C

Question 3

If an external function is secure, the URL, the HTTP headers, and the context headers are hidden from all users who are not owners of the function.

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 5

Mark the Incorrect Statements with respect to types of streams supported by Snowflake?

Options :

A : Standard streams cannot retrieve update data for geospatial data.

B : An append-only stream returns the appended rows only and therefore can be much more performant than a standard stream for extract, load, transform (ELT).

C : Insert-only Stream supported on external tables only.

D : An insert-only stream tracks row inserts & Delete ops only

Answer: D

Free DEA-C02 Mock Exam – Practice Online Confidently

Buying Options: