Question 1

Which command should be used to load data from a local computer into Snowflake?

Options :

A : CREATE EXTERNAL TABLE

B : COPY INTO

C : INSERT

D : PUT

Answer: B

Question 2

What is the recommended file sizing for data loading using Snowpipe?

Options :

A : A compressed file size greater than 100 MB, and up to 250 MB

B : A compressed file size greater than 100 GB, and up to 250 GB

C : A compressed file size greater than 10 MB, and up to 100 MB

D : A compressed file size greater than 1 GB, and up to 2 GB

Answer: C

Question 3

Which of the following are characteristics of security in Snowflake?

Options :

A : Account and user authentication is only available with the Snowflake Business Critical edition.

B : Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C : Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D : Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Answer: C

Question 4

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

Options :

A : The primary cluster in the virtual warehouse

B : The entire virtual warehouse

C : The database in which the virtual warehouse resides

D : The Queries currently being run on the virtual warehouse

Answer: B

Question 5

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

Options :

A : Swift

B : JavaScript

C : Python

D : SQL

Answer: C