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 COF-C02 Exam - Topic 5 Question 15 Discussion

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?
B) select * from directory(@bronzestage);
A) list @bronzestage;
C) select metadata$filename from @bronzestage;
D) select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));

Snowflake COF-C02 Exam - Topic 5 Question 15 Discussion

Actual exam question for Snowflake's COF-C02 exam
Question #: 15
Topic #: 5
[All COF-C02 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);


by Whitley at Jul 10, 2023, 02:46 AM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Valentine
9 months ago
Surprised this is even a question, B is the obvious choice!
upvoted 0 times
...
Hollis
9 months ago
I'm pretty sure A just lists files, not URLs.
upvoted 0 times
...
Lettie
10 months ago
Wait, isn't D just about file registration history?
upvoted 0 times
...
Bettina
10 months ago
I think it's C, but B seems right too.
upvoted 0 times
...
Deandrea
10 months ago
Definitely B, that's the one for directory tables!
upvoted 0 times
...
Carol
10 months ago
Option D seems off because it references a different stage name. I think it’s not the correct one for bronzestage.
upvoted 0 times
...
Emile
10 months ago
I practiced a similar question, and I feel like option A just lists the stage without showing the files.
upvoted 0 times
...
Carmela
11 months ago
I'm not entirely sure, but I remember something about using "select" to get file metadata. Maybe option C?
upvoted 0 times
...
Shay
11 months ago
I think option B might be the right choice since it mentions a directory and could show the files in the stage.
upvoted 0 times
...
Sage
11 months ago
I'm pretty sure postrenal AKI is related to obstruction of urine flow after the kidneys, so I'm thinking option D, renal vein thrombosis, is the correct answer.
upvoted 0 times
...
Lyda
11 months ago
Hmm, this looks like a networking question. I'll need to think about the different network interface types supported by SLES and which one is used for link aggregation.
upvoted 0 times
...
Maurine
11 months ago
The key here is understanding the structure of JSON data. An object is the correct choice - it's an unordered collection of name-value pairs.
upvoted 0 times
...

Save Cancel