Question 170
An engineer overseeing Vantage Travel's booking platforms and customer profiles discovers the following behavior: A student research group can read an unnecessary confidential column because dataset access is granted only at whole-table scope. The team reports that the correction is complete. Which result BEST verifies that the specific issue was resolved?
Explanation
Correct Answer
The group queries permitted columns but cannot retrieve the excluded field in its original form. The observation provides evidence that the proposed fix (Use available column-level privilege or governed masking controls to limit access to that column.) addressed the reported issue (A student research group can read an unnecessary confidential column because dataset access is granted only at whole-table scope.) for Vantage Travel and its booking platforms and customer profiles. It verifies an observable outcome instead of relying only on a completed task ticket.
Incorrect Answers
The sales analyst retrieves approved reporting rows while access to unrelated confidential tables is denied. This is suitable evidence for another condition (A sales analyst receives SELECT on all company tables although the task needs only one reporting view.) after a different response (Scope SELECT access to the specific governed view or table needed for the assigned reporting task.). For Vantage Travel, it does not prove the required result: The group queries permitted columns but cannot retrieve the excluded field in its original form.
The contractor's test query is denied while authorized group members retain access. This is suitable evidence for another condition (A former contractor continues querying a governed table because its direct SELECT grant survived removal from the team group.) after a different response (Audit and revoke the contractor's direct grants as part of the offboarding workflow.). For Vantage Travel, it does not prove the required result: The group queries permitted columns but cannot retrieve the excluded field in its original form.
The analyst can run permitted reads but cannot drop or alter restricted production schemas. This is suitable evidence for another condition (A data analyst can drop production schemas because the entire department group has broad catalog ownership rights.) after a different response (Grant only necessary Unity Catalog privileges through scoped groups rather than assigning unnecessary ownership.). For Vantage Travel, it does not prove the required result: The group queries permitted columns but cannot retrieve the excluded field in its original form.