What privileges are required to create a task?

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

Comment: *

Name: *

Email: *

Verification: *

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

• A.The primary cluster in the virtual warehouse
• B.The entire virtual warehouse
• C.The database in which the virtual warehouse resides
• D.The Queries currently being run on the virtual warehouse

Comment: *

Name: *

Email: *

Verification: *

What is a best practice after creating a custom role?

• A.Assign the custom role to the PUBLIC role
• B.Create the custom role using the SYSADMIN role.
• C.Add_CUSTOM to all custom role names
• D.Assign the custom role to the SYSADMIN role

Comment: *

Name: *

Email: *

Verification: *

Which statement accurately describes Snowflake's architecture?

• A.It is a blend of shared-disk and shared-everything database architectures.
• B.It is a hybrid of traditional shared-disk and shared-nothing database architectures.
• C.It uses a local data repository for all compute nodes in the platform.
• D.It reorganizes loaded data into internal optimized, compressed, and row-based format.

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes a Snowflake stored procedure?

• A.They can be created to run with a caller's rights or an owner's rights.
• B.They can contain only a single SQL statement.
• C.They can be created as secure and hide the underlying metadata from the user.
• D.They can only access tables from a single database.

Comment: *

Name: *

Email: *

Verification: *