SnowPro Core Certification — Question 827

User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.

What will happen if User2 tries to access the query history?

Answer options

• A. If User2 has the SYSADMIN role they will be able to see the results.
• B. If User2 has the SECURITYADMIN role they will be able to see the results.
• C. If User2 has the ACCOUNTADMIN role they will be able to see the results.
• D. User2 will be unable to view the result set of the query executed by User1.

Correct answer: D

Explanation

The correct answer is D because in Snowflake, query results are not visible to other users unless they have been specifically granted access, regardless of their role. Even if User2 holds a high-level role such as SYSADMIN, SECURITYADMIN, or ACCOUNTADMIN, they will not see the result set unless proper permissions are set for sharing that information.