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

Lilli

2 months ago

Wait, Snowflake supports subqueries? I thought it was just for storing snowballs! All these options are making my head spin like a snowglobe.

upvoted 0 times

Micah

25 days ago

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

upvoted 0 times

...

Beth

1 months ago

B) Uncorrelated scalar subqueries in any place that a value expression can be used

upvoted 0 times

...

Reena

1 months ago

A) Uncorrelated scalar subqueries in WHERE clauses

upvoted 0 times

...

Belen

2 months 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

Royal

4 days ago

Yes, Snowflake supports both uncorrelated scalar subqueries and correlated/uncorrelated EXISTS, ANY/ALL, and IN subqueries.

upvoted 0 times

...

Marylyn

9 days ago

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

upvoted 0 times

...

Sharee

14 days ago

B) Uncorrelated scalar subqueries in any place that a value expression can be used

upvoted 0 times

...

Afton

15 days ago

A) Uncorrelated scalar subqueries in WHERE clauses

upvoted 0 times

...

Shawana

2 months ago

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

upvoted 0 times

...

Rikki

2 months 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

Jade

1 months ago

User2: Yeah, I agree. Correlated subqueries are outdated.

upvoted 0 times

...

Francesco

1 months ago

User1: I think C is the way to go. Uncorrelated subqueries are the best.

upvoted 0 times

...

Ben

2 months 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

Katlyn

15 days ago

Definitely! Snowflake really does offer a lot of options when it comes to subqueries.

upvoted 0 times

...

Desirae

1 months ago

I prefer having the option to use correlated or uncorrelated subqueries. It gives me more flexibility in my queries.

upvoted 0 times

...

Pa

2 months ago

Yes, I agree. Snowflake is quite versatile with its subquery support.

upvoted 0 times

...

Pamella

2 months ago

I think E is the right answer. Snowflake supports correlated or uncorrelated subqueries in WHERE clauses.

upvoted 0 times

...

Noe

2 months 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

2 months ago

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

upvoted 0 times

...

Shawana

3 months ago

I think Snowflake supports uncorrelated scalar subqueries in WHERE clauses.

upvoted 0 times

...