The correct answer is B. DROP PROCEDURE SALES_REPORT(INT, INT); .
In Snowflake, stored procedures can be overloaded. This means multiple procedures can have the same name but different argument signatures. Because of this, when dropping a stored procedure, the procedure name and argument data types are used to identify the exact procedure to remove.
Why B is correct:
The procedure was created with two arguments:
MONTH INT, YEAR INT
When dropping the procedure, Snowflake uses the argument data types, not the argument names. Therefore, the correct statement is:
DROP PROCEDURE SALES_REPORT(INT, INT);
Why the other options are incorrect:
A). The argument names are not included in the drop signature. Snowflake expects the argument data types.
C). This includes only argument names without data types, which is not the correct procedure signature syntax.
D). This does not identify the procedure signature and is not sufficient when dropping a stored procedure.
Official Snowflake documentation reference:
Snowflake documentation for DROP PROCEDURE explains that the procedure name and argument data types are required to identify the stored procedure to drop.
Reference: Snowflake Documentation - DROP PROCEDURE; Snowflake Documentation - Stored procedures; SnowPro Core Study Guide - SQL and Snowflake Objects.
==