Answer: CURRENT_ACCOUNT()

The correct answer is A (CURRENT_ACCOUNT()) because when using secure views with Secure Data Sharing, the CURRENT_ACCOUNT function is specifically designed to authorize users from specific accounts to access rows in a base table. As confirmed by the community discussion and Snowflake documentation, CURRENT_ROLE() and CURRENT_USER() return NULL values when used in secure views shared across accounts, since the data owner doesn't control users or roles in the consuming accounts. CURRENT_SESSION() is not relevant for authorization purposes in this context.

Author: LeetQuiz Editorial Team