Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).

• A.GO driver
• B.Node.js driver
• C.ODBC driver
• D.Python connector
• E.Spark connector

Comment: *

Name: *

Email: *

Verification: *

A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?

• A.Grant the additional privileges to a custom role.
• B.Grant the additional privileges to the ACCOUNTADMIN role.
• C.Grant the additional privileges to the SYSADMIN role.
• D.Grant the additional privileges to the ORGADMIN role.

Comment: *

Name: *

Email: *

Verification: *

A virtual warehouse query queuing time has been increasing due to a large number of users accessing the warehouse at the same time each day. Which warehouse configurations would address this issue MOST cost- effectively? (Select TWO).

• A.Run the warehouse in Auto-scale mode.
• B.Scale-up the warehouse.
• C.Run the warehouse using an Economy policy.
• D.Run the warehouse in Maximized mode.
• E.Scale-out the warehouse.

Comment: *

Name: *

Email: *

Verification: *

What is a fundamental characteristic of Snowflake micro-partitions?

• A.They are sized based on Time Travel requirements.
• B.They can be read directly as files.
• C.Once established they cannot be changed.
• D.They serve as an index for Snowflake tables.

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.
How will those object names be resolved during execution?

• A.Snowflake will resolve them according to the SEARCH_PATH parameter.
• B.Snowflake will only check the schema the UDF belongs to.
• C.Snowflake will first check the current schema, and then the schema the previous query used
• D.Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

Comment: *

Name: *

Email: *

Verification: *