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
8 months ago
Surprised this is even a question, B is the obvious choice!
upvoted 0 times
...
Hollis
8 months ago
I'm pretty sure A just lists files, not URLs.
upvoted 0 times
...
Lettie
8 months ago
Wait, isn't D just about file registration history?
upvoted 0 times
...
Bettina
8 months ago
I think it's C, but B seems right too.
upvoted 0 times
...
Deandrea
9 months ago
Definitely B, that's the one for directory tables!
upvoted 0 times
...
Carol
9 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
9 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
9 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
9 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
9 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
10 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
10 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