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

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…

Account Access and Security

Question

Options

AOPERATE
BREAD
CSELECT
DUSAGE

How the community answered

(47 responses)

A
87% (41)
B
9% (4)
C
2% (1)
D
2% (1)

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