Snowflake Exam COF-C02 Topic 6 Question 18 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 18
Topic #: 6

[All COF-C02 Questions]

Which types of subqueries does Snowflake support? (Select TWO).

AUncorrelated scalar subqueries in WHERE clauses

BUncorrelated scalar subqueries in any place that a value expression can be used

CEXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only

DEXISTS, ANY / ALL, and IN subqueries in where clauses: these subqueries can be correlated only

EEXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

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 Fernanda at Aug 29, 2023, 12:24 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Belen

6 days ago

B and E, baby! Uncorrelated scalar subqueries and correlated/uncorrelated EXISTS, ANY/ALL, and IN subqueries. Snowflake's got my back, that's for sure.

upvoted 0 times

...

Shawana

10 days ago

Yes, that's correct. Snowflake supports both types of subqueries.

upvoted 0 times

...

Rikki

11 days ago

Hmm, tricky one. I'm going to go with C. Uncorrelated subqueries are where it's at. Correlated subqueries? That's so last season, am I right?

upvoted 0 times

...

Ben

16 days ago

E, E, E! That's the one that makes the most sense. Correlated or uncorrelated, I'll take it! Snowflake really does have it all, doesn't it?

upvoted 0 times

...

Noe

18 days ago

A and B, for sure! Uncorrelated scalar subqueries are the way to go in Snowflake. I can't believe they even included those other options - correlated subqueries? In my Snowflake? Not a chance!

upvoted 0 times

...

Micah

18 days ago

I believe Snowflake also supports EXISTS, ANY / ALL, and IN subqueries in WHERE clauses.

upvoted 0 times

...

Shawana

22 days ago

I think Snowflake supports uncorrelated scalar subqueries in WHERE clauses.

upvoted 0 times

...