What happens when a virtual warehouse is resized?

• A.When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.
• B.When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
• C.Users who are trying to use the warehouse will receive an error message until the resizing is complete
• D.The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Comment: *

Name: *

Email: *

Verification: *

True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.

• A.False
• B.True

Comment: *

Name: *

Email: *

Verification: *

What privileges are required to create a task?

• A.The global privilege create task is required to create a new task.
• B.Tasks are created at the Application level and can only be created by the Account Admin role.
• C.Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
• D.The role must have access to the target schema and the create task privilege on the schema itself.

Comment: *

Name: *

Email: *

Verification: *

What are ways to create and manage data shares in Snowflake? (Select TWO)

• A.Through the DATA_SHARE=TRUE parameter
• B.Through the enable__share=true parameter
• C.Through the Snowflake web interface (Ul)
• D.Through SQL commands
• E.Using the CREATE SHARE AS SELECT * TABLE command

Comment: *

Name: *

Email: *

Verification: *

True or False: Snowflake supports federated authentication in all editions.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *