Question 1

Snowflake computes and adds partitions based on the defined partition column expressions when an external table metadata is refreshed. What are the Correct Statements to configure Partition metadata refresh in case of External Tables?

Options :

A : By default, the metadata is refreshed automatically when the object is created.

B : The object owner can configure the metadata to refresh automatically when new or updated data files are available in the external stage.

C : Metadata refresh is not required as its Managed implicitly by Snowflake.

D : Partitions of External tables is managed by External Stage Cloud provider.

E : There is nothing like adding partitions on External tables.

Answer: A,B

Question 2

It is a best practice to avoid binding data using Python's formatting function due to the risk of SQL injection.

Options :

A : TRUE

B : FALSE

Answer: A

Question 3

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 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

Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction. What is term used to call these Transaction?

Options :

A : Scoped transactions

B : Inner Transaction

C : Nested Scope Transaction

D : Atomic Transaction

E : Enclosed Transaction

Answer: A