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.

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

A. Configure the Maximum Clusters setting to "Auto-Scale"

B. Set the Warehouse type to "Auto"

C. Set the Minimum Clusters and Maximum Clusters settings to the same value

D. Set the Minimum Clusters and Maximum Clusters settings to the different values

What can be used to view warehouse usage over time? (Select Two).

A. The load HISTORY view

B. The Query history view

C. The show warehouses command

D. The WAREHOUSE_METERING__HISTORY View

E. The billing and usage tab in the Snowflake web Ul

Which of the following commands cannot be used within a reader account?

A. CREATE SHARE

B. ALTER WAREHOUSE

C. DROP ROLE

D. SHOW SCHEMAS

E. DESCRBE TABLE

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

A. Pipe

B. External stage

C. Task

D. Stream

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.

Which of the following statements will accommodate this request?

A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

A. Schema

B. View

C. Internal stage

D. Table

E. User

F. Role

Which TABLE function helps to convert semi-structured data to a relational representation?

A. CHECK_JSON

B. TO_JSON

C. FLATTEN

D. PARSE_JSON

In the Snowflake access control model, which entity owns an object by default?

A. The user who created the object

B. The SYSADMIN role

C. Ownership depends on the type of object

D. The role used to create the object

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

A. Tri-Secret Secure

B. Time Travel

C. Fail-safe

D. Data encryption

E. External stages