Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

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?

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);


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
1 years ago
Because it mentions using the stage name 'bronzestage1' which is relevant to the question
upvoted 0 times
...
Huey
1 years ago
Why do you think it's D, Carisa?
upvoted 0 times
...
Carisa
1 years ago
I disagree, I believe the correct answer is D
upvoted 0 times
...
Aretha
1 years 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
...

Save Cancel