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.
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
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
Access history in Snowflake provides the following benefits pertaining to read and write operations:
Data discovery
Discover unused data to determine whether
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
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.
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"
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.
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.
0e504b5
2 months, 2 weeks agobaskar14
5 months, 1 week agoRam9198
5 months, 2 weeks agoRam9198
5 months, 2 weeks agoMarge23
7 months agoshankarj68
9 months agoMultiCloudIronMan
9 months agoFlava
10 months, 1 week agoKelvin_Yu
10 months, 4 weeks agobee5k
11 months, 1 week agoHarpreetwal
11 months, 4 weeks agolearner2023
1 year agoKvk117
1 year agoGiselaS
1 year agookurok
1 year, 1 month agookurok
1 year agoKarBiswa
1 year, 1 month agomarkpumc
1 year, 2 months agomarkpumc
1 year, 2 months ago