Answer-first summary for fast verification
Answer: User2 will be unable to view the result set of the query executed by User1.
The correct answer is D because Snowflake's data privacy and security model prevents users from viewing the actual query results of other users, even with administrative privileges. According to the community discussion and Snowflake documentation, while roles like ACCOUNTADMIN can view query history details (metadata about the query execution), they cannot see the actual result set for privacy reasons. The Query Detail page shows query execution details but not the results themselves. This aligns with Snowflake's security best practices where query results are only accessible to the user who executed the query.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
User1, who has the SYSADMIN role, executed a query in Snowsight. User2, who is in the same Snowflake account, wants to view the result set of that query using the Snowsight query history. What will happen when User2 attempts to access the query history?
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.
No comments yet.