Question 1

Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?

Options :

A : Free listing

B : Paid listing

C : Direct share

D : Data Exchange

Answer: C

Question 2

Which of the following are best practices for loading data into Snowflake? (Choose three.)

Options :

A : Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

B :

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

C : Enclose fields that contain delimiter characters in single or double quotes.

D :

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

E : When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

F :

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Answer: A,C,D

Question 3

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options :

A : Management of metadata

B : Computing the data

C : Maintaining Availability Zones

D : Infrastructure security

E : Parsing and optimizing queries

Answer: A,E

Question 4

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 5

The following settings are configured: THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level. THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level. For how many days will the data be retained at the object level?

Options :

A : 2

B : 3

C : 5

D : 7

Answer: A