Câu 32: SnowPro Advanced Data Engineer

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?

1. A. SELECT SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");
2. B. SELECT SYSTEM$PIPE_STATUS('test."Extract".my_pipe'); — đáp án hiện tại
3. C. SELECT * FROM SYSTEM$PIPE_STATUS('test."Extract".my_pipe');
4. D. SELECT * FROM SYSTEM$PIPE_STATUS("test.'extract'.my_pipe");