Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam SnowPro Core topic 1 question 428 discussion

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

What are benefits of using the ACCESS_HISTORY view in the SNOWFLAKE database?

  • A. Identification of unused data
  • B. Identification of which roles have been used
  • C. Tracking of network policy usage
  • D. Highlighting of row access policy usage
  • E. Identification of who has read data
Show Suggested Answer Hide Answer
Suggested Answer: AB 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
0e504b5
2 months, 2 weeks ago
Selected Answer: AE
A E C - no, use this instead: https://docs.snowflake.com/en/sql-reference/account-usage/network_policies B - I would probably use QUERY_HISTORY for that instead https://docs.snowflake.com/en/sql-reference/account-usage/query_history D - I would use this instead: ROW_ACCESS_POLICIES https://docs.snowflake.com/en/sql-reference/account-usage/row_access_policies
upvoted 1 times
...
baskar14
5 months, 1 week ago
Selected Answer: DE
Specifies the DDL operation on a database, schema, table, view, and column. These operations also include statements that specify a row access policy on a table or view, a masking policy on a column, and tag updates (e.g. set a tag, change a tag value) on the object or column. USER_NAME column JSMITH
upvoted 1 times
...
Ram9198
5 months, 2 weeks ago
Selected Answer: A
Access history in Snowflake provides the following benefits pertaining to read and write operations: Data discovery Discover unused data to determine whether
upvoted 1 times
...
Ram9198
5 months, 2 weeks ago
Selected Answer: AE
Who what when how
upvoted 2 times
...
Marge23
7 months ago
Selected Answer: E
[ { "objectDomain": "Stage", "objectId": 1, "objectName": "JRAMCELESTE", "stageKind": "User" } ]
upvoted 1 times
...
shankarj68
9 months ago
A is the right answer. Check the benefit section: https://docs.snowflake.com/en/user-guide/access-history#benefits
upvoted 3 times
...
MultiCloudIronMan
9 months ago
Selected Answer: AE
correct
upvoted 2 times
...
Flava
10 months, 1 week ago
Selected Answer: E
Access History in Snowflake refers to when the user query reads column data and when the SQL statement performs a data write operation, such as INSERT, UPDATE, and DELETE along with variations of the COPY command, from the source data object to the target data object
upvoted 1 times
...
Kelvin_Yu
10 months, 4 weeks ago
Selected Answer: AD
ADE A: https://docs.snowflake.com/en/user-guide/access-history#label-access-history-benefits:~:text=Discover%20unused%20data%20to%20determine%20whether%20to%20archive%20or%20delete%20the%20data. D: https://docs.snowflake.com/en/user-guide/access-history#example-track-row-access-policy-references E: https://docs.snowflake.com/en/user-guide/access-history#examples-read-queries
upvoted 2 times
...
bee5k
11 months, 1 week ago
Selected Answer: A
Only A. They did not ask for two.Dont Confuse
upvoted 1 times
...
Harpreetwal
11 months, 4 weeks ago
Selected Answer: AE
AE looks correct
upvoted 2 times
...
learner2023
1 year ago
Selected Answer: A
Benefits¶ Access history in Snowflake provides the following benefits pertaining to read and write operations: Data discovery Discover unused data to determine whether to archive or delete the data.
upvoted 2 times
...
Kvk117
1 year ago
Selected Answer: DE
Verified
upvoted 2 times
...
GiselaS
1 year ago
Selected Answer: CE
E: "Access History in Snowflake refers to when the user query reads column data and when the SQL statement performs a data write operation" C: "These records facilitate regulatory compliance auditing and provide insights on popular and frequently accessed tables and columns"
upvoted 1 times
...
okurok
1 year, 1 month ago
Selected Answer: DE
D: https://docs.snowflake.com/en/sql-reference/account-usage/access_history#:~:text=Specifies%20information%20about%20the%20enforced%20masking%20policy%20set%20on%20the%20column%20and%20the%20enforced%20row%20access%20policy%20set%20on%20the%20table%2C%20including%20policies%20set%20on%20intermediate%20objects%20or%20columns. E: https://docs.snowflake.com/en/sql-reference/account-usage/access_history#:~:text=The%20user%20who%20issued%20the%20query.
upvoted 1 times
okurok
1 year ago
also A https://docs.snowflake.com/en/user-guide/access-history#:~:text=Discover%20unused%20data
upvoted 1 times
...
...
KarBiswa
1 year, 1 month ago
Selected Answer: DE
No mention of roles into the columns of the view into the user document
upvoted 1 times
...
markpumc
1 year, 2 months ago
The benefits of using the ACCESS_HISTORY view in the Snowflake database include: Identification of who has read data Tracking of which roles have been used Highlighting of row access policy usage By using the ACCESS_HISTORY view, organizations can get a better understanding of who has access to what data within their Snowflake environment, and ensure that data is being accessed and used in an appropriate manner.
upvoted 3 times
markpumc
1 year, 2 months ago
should be BDE
upvoted 1 times
...
...
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
Loading ...