BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake Exam SnowPro-Core Topic 3 Question 71 Discussion

Actual exam question for Snowflake's SnowPro-Core exam
Question #: 71
Topic #: 3
[All SnowPro-Core Questions]

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

Show Suggested Answer Hide 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);


Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!


Save Cancel