Snowflake Certification Practice Test

Can a user with the ACCOUNTADMIN role view results for a query run by another user?

1. Yes

2. No

3. Only if given special privileges

4. Only if the query was run recently

The correct answer is: No

The ACCOUNTADMIN role in Snowflake is the highest level of administrative access, but it does not automatically grant permission to view the results of queries run by other users. This level of access is designed to manage account settings and performance tuning rather than to serve as a means of monitoring user activity or data access. In Snowflake, query results are considered sensitive information, and the default security model maintains user privacy by preventing even an ACCOUNTADMIN from accessing the results of another user's queries, unless the necessary permissions are specifically granted. Thus, the proper interpretation of the question shows that an ACCOUNTADMIN cannot view the results of queries executed by others without appropriate permission. This distinction helps ensure user accountability and privacy, which is a fundamental aspect of data governance in many organizations, maintaining integrity across user roles and access levels.