Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 585

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

SELECT * FROM @mystage::DIRECTORY

SELECT * FROM DIRECTORY (@mystage)

SELECT * FROM TO_TABLE (DIRECTORY @mystage)

SELECT * FROM TABLE (@mystage DIRECTORY)

Correct Answer: B

The correct way to reference a directory table created on stage mystage in a SQL query in Snowflake is by using the syntax SELECT * FROM DIRECTORY (@mystage). This is the standard syntax for querying directory tables as per Snowflake’s documentation.

Discussion

bibisaOption: B

SELECT * FROM DIRECTORY(@mystage); https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage

RenvisOption: B

B is correct.

zzengOption: B

B is correct. Ref: https://docs.snowflake.com/en/user-guide/data-load-dirtables-query

PrashantGupta1616Option: B

B. SELECT * FROM DIRECTORY (@mystage) Most Voted

MultiCloudIronManOption: B

Correct