Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 649

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

list @bronzestage;

select * from directory(@bronzestage);

select metadata$filename from @bronzestage;

select * from table(information_schema.stage_directory_file_registration_history( stage_name=>'bronzestage'));

Correct Answer: B

To retrieve a list of all files on a stage with metadata, including the Snowflake-hosted file URL, you need to query the directory table for that stage. The correct query format is SELECT * FROM DIRECTORY(@stage_name);. This will list all files along with their metadata for the specified stage.

Discussion

nexerSnowOption: B

Querying directory tables This topic covers how to query a directory table to retrieve a list of all files on a stage with metadata, such as the Snowflake file URL, for each file. SELECT * FROM DIRECTORY( @<stage_name> ) https://docs.snowflake.com/en/user-guide/data-load-dirtables-query

majewOption: B

B is correct

yfontanaOption: B

https://docs.snowflake.com/en/user-guide/data-load-dirtables-query

ravuri_rkOption: B

FILE_URL -Snowflake-hosted file URL to the file. https://docs.snowflake.com/en/user-guide/data-load-dirtables-manage

MultiCloudIronManOption: B

I think B