Question 200
Atlas Scientific processes lab collaboration and cloud-hosted research with a defined data freshness objective. The investigation finds: A pipeline service principal can read source tables but fails while creating its destination managed table. The team reports that the correction is complete. Which result BEST verifies that the specific issue was resolved?
Explanation
Correct Answer
The pipeline creates its output in the authorized schema and cannot create objects in unrelated schemas. The observation provides evidence that the proposed fix (Grant the destination's narrowly required CREATE TABLE privileges without broadening source privileges.) addressed the reported issue (A pipeline service principal can read source tables but fails while creating its destination managed table.) for Atlas Scientific and its lab collaboration and cloud-hosted research. It verifies an observable outcome instead of relying only on a completed task ticket.
Incorrect Answers
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 Atlas Scientific, it does not prove the required result: The pipeline creates its output in the authorized schema and cannot create objects in unrelated schemas.
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 Atlas Scientific, it does not prove the required result: The pipeline creates its output in the authorized schema and cannot create objects in unrelated schemas.
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 Atlas Scientific, it does not prove the required result: The pipeline creates its output in the authorized schema and cannot create objects in unrelated schemas.