Databricks-DE-Pro Debugging and Deploying Practice Question
A data engineer deploys a Databricks Job that runs a notebook task. The notebook writes to a Delta table in Unity Catalog. The job fails with the error: 'PERMISSION_DENIED: User does not have USE CATALOG on catalog 'prod'.' The engineer confirms the job's service principal has USE CATALOG granted on the catalog. Which configuration should the engineer check next?
⚠ Common exam trap
The trap here is assuming the error always means the grant is missing, when in fact the job may be running as a different identity than the one that was granted privileges.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Whether the job is configured to run as the service principal or as a different user
Unity Catalog privileges are enforced based on the identity that executes the job. When a service principal has USE CATALOG but the job runs as a different user or principal, the error still occurs. Checking the job's run-as configuration and aligning it with the granted identity resolves the mismatch and allows the notebook to access the catalog.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The notebook's default language setting
Why it's wrong here
The default language of the notebook affects how cells are interpreted (Python, SQL, Scala, R) but has no bearing on Unity Catalog privilege evaluation. A PERMISSION_DENIED error for USE CATALOG is an access-control issue, not a parsing or language issue. Changing the language would not grant the missing catalog permission and would not address the root cause.
- ✓
Whether the job is configured to run as the service principal or as a different user
Why this is correct
Unity Catalog privileges are evaluated against the identity that executes the job. If the job's run-as setting points to a user or a different service principal than the one granted USE CATALOG, the error appears even though the intended principal has the privilege. Confirming and correcting the run-as identity ensures the granted privileges are applied to the execution context.
- ✗
The job cluster's Spark config for spark.databricks.acl.enabled
Why it's wrong here
This Spark configuration is not a valid Unity Catalog privilege control; Unity Catalog permissions are enforced by the metastore and workspace, not by a Spark config flag. Enabling or disabling it would not resolve a missing USE CATALOG grant. The engineer should instead verify that the job is running as the service principal that holds the grant, which is the most common cause of this misleading error.
- ✗
The cluster's autoscaling min and max worker counts
Why it's wrong here
Autoscaling worker counts affect compute capacity and cost, not Unity Catalog permissions. A PERMISSION_DENIED error is unrelated to how many workers the cluster has. Adjusting autoscaling would not change the identity or privileges used to access the catalog. The engineer must focus on the run-as identity and the actual grants applied to that identity.
Visual reference
About these practice questions
This Databricks-DE-Pro question is part of Courseiva's 267-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-DE-Pro practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DE-Pro exam.