Snowflake SnowPro Certification Practice Test

Can ACCOUNTADMINS view results of queries run by other users?

1. Yes, they can see all user queries

2. No, they can only see the queries they ran

3. Only if given special permissions

4. Only for users in their group

The correct answer is: No, they can only see the queries they ran

The ability of ACCOUNTADMIN users in Snowflake is defined by the permissions associated with their role. While ACCOUNTADMIN is a high-level administrative role that grants significant privileges, it does not inherently include the ability to view the complete details of queries run by other users unless specific permissions or settings have been configured. ADMIN roles, including ACCOUNTADMIN, can view query history, but they typically see queries under their own account's context and will have limited access to detail unless clear permissions are assigned or specific monitoring tools are used. The default behavior ensures that users' privacy and data security are maintained, thereby restricting the visibility of each user's queries to their respective sessions or contexts. This reflects Snowflake's design ethos towards role-based access control, maintaining a separation of duties, and ensuring security best practices. Thus, the response correctly identifies that ACCOUNTADMINs can primarily see the queries they themselves have executed without additional configurations or tools in place to expand their visibility to other users' queries.