SnowPro Core Certification — Question 460

How does a Snowflake user reference a directory table created on stage mystage in a SQL query?

Answer options

• A. SELECT * FROM @mystage::DIRECTORY
• B. SELECT * FROM DIRECTORY (@mystage)
• C. SELECT * FROM TO_TABLE (DIRECTORY @mystage)
• D. SELECT * FROM TABLE (@mystage DIRECTORY)

Correct answer: B

Explanation

The correct option, B, uses the proper syntax for referencing a directory table in Snowflake. Options A, C, and D employ incorrect formats or functions that do not exist in Snowflake's SQL syntax for accessing directory tables.