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]

From what stage can a Snowflake user omit the FROM clause while loading data into a table?

AThe user stage

BThe table stage

CThe internal named stage

DThe external named stage

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

12 months ago

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

upvoted 0 times

...

Huey

12 months ago

Why do you think it's D, Carisa?

upvoted 0 times

...

Carisa

12 months ago

I disagree, I believe the correct answer is D

upvoted 0 times

...

Aretha

12 months ago

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

upvoted 0 times

...

Huey

1 years ago

Why do you think it's C?

upvoted 0 times

...

Aretha

1 years ago

I think the answer is C

upvoted 0 times

...

Rex

1 years ago

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

upvoted 0 times

...

Johnetta

1 years ago

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

upvoted 0 times

...

Natalie

1 years ago

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

upvoted 0 times

...

Rex

1 years ago

I disagree, I believe the correct answer is B.

upvoted 0 times

...

Johnetta

1 years ago

I think the answer is C.

upvoted 0 times

...