Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 859 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 859
Topic #: 1
[All SnowPro Core Questions]

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.
  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by Heetec at Oct. 11, 2023, 10:39 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
06c63d0
2 months, 4 weeks ago
Is C, the rol ACCOUNTADMIN is able to see all the queries! => "To view history for other queries, your active role affects what else you can see in Query History: If your active role is the ACCOUNTADMIN role, you can view all query history for the account." Source: https://docs.snowflake.com/en/user-guide/ui-snowsight-activity#:~:text=To%20view%20history,for%20the%20account.
upvoted 1 times
aemilka
4 weeks, 1 day ago
If you have privileges to view queries executed by another user, the Query Detail page displays the details for the query, but, for data privacy reasons, the page does not display the actual query result.
upvoted 1 times
aemilka
4 weeks, 1 day ago
So D is correct
upvoted 1 times
...
...
...
Heetec
1 year, 1 month ago
Selected Answer: D
D correct - You can view results only for queries you have executed. If you have privileges to view queries executed by another user, the Query Detail page displays the details for the query, but, for data privacy reasons, the page does not display the actual query result. https://docs.snowflake.com/en/user-guide/ui-history
upvoted 3 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel