COF-C02 Question #535: Real Exam Question with Answer & Explanation

The correct answer is A: OPERATE. OPERATE. In Snowflake, to pause or resume a pipe, the OPERATE privilege is required on the pipe object. The OPERATE privilege allows users to perform operational tasks on specific objects such as pipes, tasks, and streams. Specifically, for a pipe, the OPERATE privilege enables t

Account Access and Security

Question

Which Snowflake privilege is required on a pipe object to pause or resume pipes?

Options

AOPERATE
BREAD
CSELECT
DUSAGE

Explanation

OPERATE. In Snowflake, to pause or resume a pipe, the OPERATE privilege is required on the pipe object. The OPERATE privilege allows users to perform operational tasks on specific objects such as pipes, tasks, and streams. Specifically, for a pipe, the OPERATE privilege enables the user to execute the ALTER PIPE ... SET PIPE_EXECUTION_PAUSED=TRUE or ALTER PIPE ... SET PIPE_EXECUTION_PAUSED=FALSE commands, which are used to pause or resume the pipe, respectively.

Topics

#Pipe objects#Snowflake privileges#Access control#Data loading

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions