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%

14 days ago

I think Snowflake supports uncorrelated scalar subqueries in WHERE clauses.

upvoted 0 times

...