Which command can drop a Kafka pipe?

• A. DELETE PIPE <kafkaPipe>
• B. DROP PIPE <kafkaPipe>
• C. DELETE KAFKA_PIPE <kafkaPipe>
• D. DROP KAFKA_PIPE <kafkaPipe>

Answer: (B)

Dropping a Kafka pipe uses the standard command for removing pipes. In Snowflake, a pipe—whether it's a Kafka-backed pipe or not—is removed with DROP PIPE followed by the pipe’s name. The other forms aren’t valid for Snowflake object deletion: there isn’t a DELETE command for pipes, and there isn’t a separate DROP KAFKA_PIPE form. Therefore, the correct way to drop the Kafka pipe is DROP PIPE .