SnowPro Advanced: Data Engineer — Question 30

A Data Engineer wants to check the status of a pipe named my_pipe. The pipe is inside a database named test and a schema named Extract (case-sensitive).
Which query will provide the status of the pipe?

Answer options

• A. SELECT SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");
• B. SELECT SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
• C. SELECT * FROM SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
• D. SELECT * FROM SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");

Correct answer: B

Explanation

The correct answer is B because it uses the appropriate case-sensitive notation for the schema 'Extract' within double quotes. Options A and D incorrectly use single quotes for the schema, and option C, while similar to B, is not the correct syntax for querying the pipe status directly.