Question 1

What is a characteristic of loading data into Snowflake using the Snowflake Connector for Kafka?

Options :

A : The Connector only works in Snowflake regions that use AWS infrastructure.

B : The Connector works with all file formats, including text, JSON, Avro, Ore, Parquet, and XML.

C : The Connector creates and manages its own stage, file format, and pipe objects.

D : Loads using the Connector will have lower latency than Snowpipe and will ingest data in real time.

Answer: C

Question 2

Which alter command below may affect the availability of column with respect to time travel?

Options :

A : ALTER TABLE...DROP COLUMN

B : ALTER TABLE...SET DATA TYPE

C : ALTER TABLE...SET DEFAULT

Answer: B

Question 3

Which Snowflake architecture recommendation needs multiple Snowflake accounts for implementation?

Options :

A : Enable a disaster recovery strategy across multiple cloud providers.

B :

Create external stages pointing to cloud providers and regions other than the region hosting the Snowflake account.

C : Enable zero-copy cloning among the development, test, and production environments.

D : Enable separation of the development, test, and production environments.

Answer: D

Question 4

What is the data size limit for loading into a variant column?

Options :

A : 16 MB(Compressed)

B : 1 GB(Compressed)

C : 32 GB

D : 10 MB - 100 MB compressed

Answer: A

Question 5

You want to automatically delete the files from stage after a successful load using the COPY INTO command. What will be recommended approach for deletion?

Options :

A : Set PURGE=TRUE in the COPY INTO command

B : Set REMOVE=TRUE in the COPY INTO Command

C : No need to do anything, snowflake does it automatically

Answer: A