Question 150
The lakehouse operations report for Northshore Hospitality describes this issue: A reader has SELECT on a table but cannot resolve its catalog namespace and reports permission denied. The team reports that the correction is complete. Which result BEST verifies that the specific issue was resolved?
Explanation
Correct Answer
The reader queries the approved table without gaining write or ownership rights to its parent schema. The observation provides evidence that the proposed fix (Grant the required USE CATALOG and USE SCHEMA permissions along with scoped table SELECT.) addressed the reported issue (A reader has SELECT on a table but cannot resolve its catalog namespace and reports permission denied.) for Northshore Hospitality and its reservation applications and staff devices. It verifies an observable outcome instead of relying only on a completed task ticket.
Incorrect Answers
A reporting member reads approved rows but cannot transfer ownership or change table definitions. This is suitable evidence for another condition (A shared reporting group has permanent ownership of a sensitive table although it only needs read access.) after a different response (Transfer or retain table ownership with the accountable steward and grant the reporting group SELECT.). For Northshore Hospitality, it does not prove the required result: The reader queries the approved table without gaining write or ownership rights to its parent schema.
The ingestion job creates its target table and an unapproved user receives a create-permission error. This is suitable evidence for another condition (A platform admin grants every user CREATE TABLE on a shared sensitive schema because one ingestion job needs it.) after a different response (Grant CREATE TABLE only to the job's authorized group or service principal on the intended schema.). For Northshore Hospitality, it does not prove the required result: The reader queries the approved table without gaining write or ownership rights to its parent schema.
A corrected permission permits the original query while a prohibited administrator operation remains blocked. This is suitable evidence for another condition (An engineer responds to a Unity Catalog permission error by granting account admin rather than diagnosing the securable chain.) after a different response (Inspect effective catalog, schema, and object privileges to identify the missing narrowly scoped grant.). For Northshore Hospitality, it does not prove the required result: The reader queries the approved table without gaining write or ownership rights to its parent schema.