Snowflake Exam SnowPro-Core Topic 1 Question 82 Discussion

Actual exam question for Snowflake's SnowPro-Core exam

Question #: 82
Topic #: 1

[All SnowPro-Core 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

Carisa

5 months ago

Because it mentions using the stage name 'bronzestage1' which is relevant to the question

upvoted 0 times

...

Huey

5 months ago

Why do you think it's D, Carisa?

upvoted 0 times

...

Carisa

5 months ago

I disagree, I believe the correct answer is D

upvoted 0 times

...

Aretha

5 months ago

Because it makes sense to select metadata$filename from the stage

upvoted 0 times

...

Huey

6 months ago

Why do you think it's C?

upvoted 0 times

...

Aretha

6 months ago

I think the answer is C

upvoted 0 times

...

Rex

6 months ago

But B could also be correct because it uses the directory function to list files in the @bronzestage.

upvoted 0 times

...

Johnetta

6 months ago

I think C is the right answer because it directly selects the filename from the @bronzestage.

upvoted 0 times

...

Natalie

6 months ago

I'm not sure about this question, it's a bit tricky.

upvoted 0 times

...

Rex

7 months ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

Johnetta

7 months ago

I think the answer is C.

upvoted 0 times

...