SnowPro Core Certification — Question 675

How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?

Answer options

• A. Use the SHOW STAGES command.
• B. Use the DESCRIBE STAGE command.
• C. Use the GET_ABSOLUTE_PATH function.
• D. Use the GET_STAGE_LOCATION function.

Correct answer: D

Explanation

The correct answer is D because the GET_STAGE_LOCATION function is specifically designed to return the URL of a stage in Snowflake. The other options do not provide the URL directly: SHOW STAGES lists stages, DESCRIBE STAGE provides details about a stage, and GET_ABSOLUTE_PATH does not relate to retrieving a stage's location.