ExamGecko
Question list
Search
Search

Question 452 - COF-C02 discussion

Report
Export

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?

A.
If User2 has the sysadmin role they will be able to see the results.
Answers
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.
Answers
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.
Answers
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.
Answers
D.
User2 will be unable to view the result set of the query executed by User1.
Suggested answer: C

Explanation:

In Snowflake, the query history and the results of queries executed by a user are accessible based on the roles and permissions. If User1 executed a query with the SYSADMIN role, User2 would be able to view the result set of that query executed by User1 only if User2 has the ACCOUNTADMIN role. The ACCOUNTADMIN role has the broadest set of privileges, including the ability to access all aspects of the account's operation, data, and query history, thus enabling User2 to view the results of queries executed by other users.

References:

Snowflake Documentation: Understanding Snowflake Roles

asked 23/09/2024
Malik Spamu
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first