Snowflake Exam SnowPro-Core Topic 1 Question 82 Discussion

Actual exam question for Snowflake's SnowPro Core Exam exam

Question #: 82
Topic #: 1

[All SnowPro Core Exam Questions]

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

Alist @bronzestage;

Bselect * from directory(@bronzestage);

Cselect metadata$filename from @bronzestage;

Dselect * from table(information_schema.stage_directory_file_registration_history(
stage name=>'bronzestage1));

Show Suggested Answer

Suggested Answer: B

According to the Snowflake documentation1, a directory table stores a catalog of staged files in cloud storage and can be queried to retrieve theSnowflake-hosted file URLto each file in the stage. A file URL has the following format:

https:///api/files/<db_name>.<schema_name>.<stage_name>/<relative_path>

Based on this information, I think the query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage isB. select * from directory(@bronzestage);

by Solange at Mar 07, 2024, 10:45 AM

Limited Time Offer

25%

Off

Get Premium SnowPro-Core Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Johnetta

2 days ago

I think the answer is C.

upvoted 0 times

...