Question 80
During a scheduled ingestion recovery rehearsal at Northbridge University, the information governance lead identifies a Databricks issue: A service account can operate a notebook but cannot start its assigned SQL warehouse due to missing compute permissions. The team reports that the correction is complete. Which result BEST verifies that the specific issue was resolved?
Explanation
Correct Answer
The service identity executes the authorized query and cannot manage unrelated warehouse settings. The observation provides evidence that the proposed fix (Grant only the necessary use permissions on the specified SQL warehouse or compute resource.) addressed the reported issue (A service account can operate a notebook but cannot start its assigned SQL warehouse due to missing compute permissions.) for Northbridge University and its student collaboration and research access. It verifies an observable outcome instead of relying only on a completed task ticket.
Incorrect Answers
The idle resource shuts down after the configured period and can restart for a new authorized session. This is suitable evidence for another condition (An interactive exploratory cluster remains running for hours after the last user leaves because it lacks an idle termination rule.) after a different response (Set an appropriate automatic termination interval for the interactive compute resource.). For Northbridge University, it does not prove the required result: The service identity executes the authorized query and cannot manage unrelated warehouse settings.
A permitted operator can run the approved task while a lower-privilege user cannot change compute configuration. This is suitable evidence for another condition (An untrusted operator can edit production cluster configuration because all workspace users have manage permissions on shared compute.) after a different response (Restrict manage and attach permissions on compute to the roles required by each workflow.). For Northbridge University, it does not prove the required result: The service identity executes the authorized query and cannot manage unrelated warehouse settings.
Two controlled runs report the same package versions and produce matching validated test results. This is suitable evidence for another condition (Two job runs produce different results because each notebook installs an unpinned package release at runtime.) after a different response (Pin and manage supported dependency versions consistently for the job compute environment.). For Northbridge University, it does not prove the required result: The service identity executes the authorized query and cannot manage unrelated warehouse settings.