Online Access Free Databricks-Certified-Professional-Data-Engineer Exam Questions

A data engineer has configured their Databricks Asset Bundle with multiple targets in databricks.yml and deployed it to the production workspace. Now, to validate the deployment, they need to invoke a job named my_project_job specifically within the prod target context. Assuming the job is already deployed, they need to trigger its execution while ensuring the target-specific configuration is respected.
Which command will trigger the job execution?

• A.databricks run my_project_job -t prod
• B.databricks execute my_project_job -e prod
• C.databricks job run my_project_job --env prod
• D.databricks bundle run my_project_job -t prod

What is a method of installing a Python package scoped at the notebook level to all nodes in the currently active cluster?

• A.Install libraries from PyPi using the cluster UI
• B.Use and Pip install in a notebook cell
• C.Use and sh install in a notebook cell
• D.Run source env/bin/activate in a notebook setup script

A Databricks job has been configured with 3 tasks, each of which is a Databricks notebook. Task A does not depend on other tasks. Tasks B and C run in parallel, with each having a serial dependency on Task A.
If task A fails during a scheduled run, which statement describes the results of this run?

• A.Tasks B and C will be skipped; task A will not commit any changes because of stage failure.
• B.Because all tasks are managed as a dependency graph, no changes will be committed to the Lakehouse until all tasks have successfully been completed.
• C.Tasks B and C will attempt to run as configured; any changes made in task A will be rolled back due to task failure.
• D.Unless all tasks complete successfully, no changes will be committed to the Lakehouse; because task A failed, all commits will be rolled back automatically.
• E.Tasks B and C will be skipped; some logic expressed in task A may have been committed before task failure.

A junior member of the data engineering team is exploring the language interoperability of Databricks notebooks. The intended outcome of the below code is to register a view of all sales that occurred in countries on the continent of Africa that appear in the geo_lookup table.
Before executing the code, running SHOW TABLES on the current database indicates the database contains only two tables: geo_lookup and sales .

Which statement correctly describes the outcome of executing these command cells in order in an interactive notebook?

• A.Both commands will fail. No new variables, tables, or views will be created.
• B.Cmd 1 will succeed. Cmd 2 will search all accessible databases for a table or view named countries af:
  if this entity exists, Cmd 2 will succeed.
• C.Cmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable representing a PySpark DataFrame.
• D.Both commands will succeed. Executing show tables will show that countries at and sales at have been registered as views.
• E.Cmd 1 will succeed and Cmd 2 will fail, countries at will be a Python variable containing a list of strings.

A data engineer wants to enforce the principle of least privilege when configuring ACLs for Databricks jobs in a collaborative workspace.
Which approach should the data engineer use?

• A.Grant all users CAN MANAGE permission on all jobs to avoid access issues.
• B.Assign users only the minimum permission level (e.g., CAN RUN or CAN VIEW) required for their role on each job.
• C.Use only folder-level permissions and avoid setting permissions on individual jobs.
• D.Grant CAN RUN permission to everyone and CAN MANAGE to a single admin group.