SnowPro Advanced: Data Engineer Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose B1

  The correct query to check the status of a pipe named my_pipe inside a database named test and a case-sensitive schema named Extract is: B. SELECT SYSTEM$PIPE_STATUS('test."Extract".my_pipe'); This query uses double quotes around the schema name "Extract" to ensure that the case sensitivity is preserved. Additionally, the single quotes around the pipe name my_pipe and the dot notation for specifying the database and schema are correct in Snowflake SQL syntax.

• Chose B2

  SELECT SYSTEM$PIPE_STATUS('mydb.myschema.mypipe');

• 1

  https://docs.snowflake.com/en/sql-reference/functions/system_pipe_status