The correct answer is B.
In queries, unqualified object names are resolved through a search path.
The SEARCH_PATH is not used inside views or Writing User-Defined Functions (UDFs). All unqualified objects in a view or UDF definition will be resolved in the view’s or UDF’s schema only.
https://docs.snowflake.com/en/sql-reference/name-resolution#name-resolution-in-queries
In queries, unqualified object names are resolved through a search path.
The SEARCH_PATH is not used inside views or Writing User-Defined Functions (UDFs). All unqualifed objects in a view or UDF definition will be resolved in the view’s or UDF’s schema only.
https://docs.snowflake.com/en/sql-reference/name-resolution
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
_yyukta
7Â months, 4Â weeks agoBobFar
1Â year agoMultiCloudIronMan
1Â year, 3Â months agoshujaz
1Â year, 4Â months agovishnuas
11Â months, 1Â week agodmitriypo
1Â year, 5Â months agoOTE
1Â year, 7Â months agoSimbajagnole
1Â year, 8Â months ago