Discuss Snowflake COF-C02 Exam Topic 5 Question 15

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

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

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Valentine 11 months ago

Surprised this is even a question, B is the obvious choice!

Hollis 11 months ago

I'm pretty sure A just lists files, not URLs.

Lettie 11 months ago

Wait, isn't D just about file registration history?

Bettina 11 months ago

I think it's C, but B seems right too.

Deandrea 12 months ago

Definitely B, that's the one for directory tables!

Carol 12 months ago

Option D seems off because it references a different stage name. I think it’s not the correct one for bronzestage.

Emile 12 months ago

I practiced a similar question, and I feel like option A just lists the stage without showing the files.

Carmela 1 year ago

I'm not entirely sure, but I remember something about using "select" to get file metadata. Maybe option C?

Shay 1 year ago

I think option B might be the right choice since it mentions a directory and could show the files in the stage.

Sage 1 year 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.

Lyda 1 year 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.

Maurine 1 year 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.

Snowflake COF-C02 Exam - Topic 5 Question 15 Discussion