Question 1

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 2

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Options :

A : CHECK_OPTION

B : IS_SECURE

C : IS_UPDATEABLE

D : TABLE_NAME

Answer: B

Question 3

What type of query will benefit from the query acceleration service?

Options :

A : Queries without filters or aggregation

B : Queries with large scans and selective filters

C : Queries where the GROUP BY has high cardinality

D : Queries of tables that have search optimization service enabled

Answer: B

Question 4

Which command can be used to stage local files from which Snowflake interface?

Options :

A : SnowSQL

B : Snowflake classic web interface (Ul)

C : Snowsight

D : .NET driver

Answer: A

Question 5

Which command will identify the names of files that are in a Snowflake stage?

Options :

A : DESCRIBE FILE FORMAT

B : SHOW FILE FORMAT

C : LIST

D :

Answer: C