Question 1
A required security notice is recorded in NoticeEvents, where recipient and notice-code fields can contain NULL. Auditors must identify active users with no delivery of this specific notice. Which evidence most directly determines the correct anti-join predicates?
Explanation
Correct Answer
The anti-join needs a recipient correlation, an exact required-notice identifier and a documented delivery criterion. Checking nullable keys and event statuses prevents unrelated or malformed records from being mistaken for receipt.
Incorrect Answers
A populated user email does not establish whether a notice event belongs to that user or whether the required notice was delivered; the event relationship and status must be checked.
A system-wide notice count cannot distinguish recipients from nonrecipients. Per-user and per-notice matching is required for an absence report.
An event timestamp alone may belong to a different user or a different notice. The lookup must match the notice and recipient before timestamps could be useful.