Question 1

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 2

Which are the Cloud Platforms that Support Calling an External Function?

Options :

A : GCP

B : AWS & AZURE

C : AWS only

D : AWS,GCP,AZURE

Answer: D

Question 3

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 4

Which system table will you use to get the total credit consumption over a specific time period?

Options :

A : WAREHOUSE_METERING_HISTORY

B : WAREHOUSE_CREDIT_USAGE_HISTORY

C : WAREHOUSE_USAGE_HISTORY

Answer: A

Question 5

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