exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1305 discussion

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

Which view can be used to track the read and write operations that have been performed on a table?

  • A. COPY_HISTORY
  • B. ACCESS_HISTORY
  • C. QUERY_HISTORY
  • D. TASK_HISTORY
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Billhardy
1 week ago
Selected Answer: B
Snowflake provides the ACCESS_HISTORY view to track both read and write operations performed on tables (and other objects) within your account. ACCESS_HISTORY records every query’s access details, including reads (direct_objects_accessed and base_objects_accessed) and writes (objects_modified) for operations such as INSERT, UPDATE, DELETE, and COPY. It retains up to 365 days of history in the ACCOUNT_USAGE schema (Enterprise Edition or higher), enabling auditing and compliance reporting on who accessed or modified your data.
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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago