Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting? (Choose all that apply.)

• A.SnowSQL
• B.JDBC
• C.Snowflake Web Interface (UI)
• D.ODBC
• E.Python

Comment: *

Name: *

Email: *

Verification: *

What is the default character set used when loading CSV files into Snowflake?

• A.ANSI_X3.A
• B.ISO S859-1
• C.UTF-8
• D.UTF-16

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes how clustering keys work in Snowflake?

• A.Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time
• B.Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.
• C.Clustering keys sort the designated columns over time, without blocking DML operations
• D.Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

Comment: *

Name: *

Email: *

Verification: *

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

• A.Use the standard warehouse scaling policy
• B.Use the economy warehouse scaling policy
• C.Configure the warehouse to a size larger than generally required
• D.Set the minimum and maximum clusters to autoscale

Comment: *

Name: *

Email: *

Verification: *

What is a limitation of a Materialized View?

• A.A Materialized View cannot be joined with other tables
• B.A Materialized View cannot support any aggregate functions
• C.A Materialized View cannot be defined with a JOIN
• D.A Materialized View can only reference up to two tables

Comment: *

Name: *

Email: *

Verification: *