SnowPro Advanced: Data Engineer — Question 79

A Data Engineer creates a pipe called mypipe.

What command needs to be run to verify that the pipe is configured correctly and is running?

Answer options

• A. show pipes like 'mypipe'
• B. select system$pipe_status('public.mypipe')
• C. describe pipe 'public.mypipe'
• D. select system$verify_pipe('public.mypipe')

Correct answer: B

Explanation

The correct answer is B, as the command 'select system$pipe_status('public.mypipe')' specifically checks the status of the pipe, confirming its operational state. Option A is incorrect because it merely lists pipes that match the name without checking their status. Option C describes the pipe but does not verify its running state, and Option D is not the recommended method for checking the pipe's status.