COF-R02 Exam Dumps : SnowPro Core Recertification Exam

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

The global privilege create task is required to create a new task.

Tasks are created at the Application level and can only be created by the Account Admin role.

Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.

The role must have access to the target schema and the create task privilege on the schema itself.

Columns can be aggregated

Columns can be joined with an existing table

Columns can be reordered

Columns can be omitted

Data can be loaded without the need to spin up a virtual warehouse