Pass with professional Databricks-Certified-Data-Engineer-Professional actual quiz materials

Databricks Databricks-Certified-Data-Engineer-Professional Exam Overview:

Databricks Databricks-Certified-Data-Engineer-Professional Exam Syllabus Topics:

Databricks Certified Data Engineer Professional Sample Questions:

1. When scheduling Structured Streaming jobs for production, which configuration automatically recovers from query failures and keeps costs low?

A) Cluster: Existing All-Purpose Cluster;
Retries: Unlimited;
Maximum Concurrent Runs: 1
B) Cluster: Existing All-Purpose Cluster;
Retries: Unlimited;
Maximum Concurrent Runs: 1
C) Cluster: Existing All-Purpose Cluster;
Retries: None;
Maximum Concurrent Runs: 1
D) Cluster: New Job Cluster;
Retries: None;
Maximum Concurrent Runs: 1
E) Cluster: New Job Cluster;
Retries: Unlimited;
Maximum Concurrent Runs: Unlimited

2. Review the following error traceback:

Which statement describes the error being raised?

A) The code executed was PvSoark but was executed in a Scala notebook.
B) There is a type error because a DataFrame object cannot be multiplied.
C) There is no column in the table named heartrateheartrateheartrate
D) There is a syntax error because the heartrate column is not correctly identified as a column.
E) There is a type error because a column object cannot be multiplied.

3. A junior data engineer has manually configured a series of jobs using the Databricks Jobs UI.
Upon reviewing their work, the engineer realizes that they are listed as the "Owner" for each job.
They attempt to transfer "Owner" privileges to the "DevOps" group, but cannot successfully accomplish this task.
Which statement explains what is preventing this privilege transfer?

A) Only workspace administrators can grant "Owner" privileges to a group.
B) The creator of a Databricks job will always have "Owner" privileges; this configuration cannot be changed.
C) Other than the default "admins" group, only individual users can be granted privileges on jobs.
D) A user can only transfer job ownership to a group if they are also a member of that group.
E) Databricks jobs must have exactly one owner; "Owner" privileges cannot be assigned to a group.

4. The following code has been migrated to a Databricks notebook from a legacy workload:

The code executes successfully and provides the logically correct results, however, it takes over
20 minutes to extract and load around 1 GB of data.
Which statement is a possible explanation for this behavior?

A) Instead of cloning, the code should use %sh pip install so that the Python code can get executed in parallel across all nodes in a cluster.
B) %sh executes shell code on the driver node. The code does not take advantage of the worker nodes or Databricks optimized Spark.
C) %sh triggers a cluster restart to collect and install Git. Most of the latency is related to cluster startup time.
D) %sh does not distribute file moving operations; the final line of code should be updated to use %fs instead.
E) Python will always execute slower than Scala on Databricks. The run.py script should be refactored to Scala.

5. An external object storage container has been mounted to the location /mnt/finance_eda_bucket.
The following logic was executed to create a database for the finance team:

After the database was successfully created and permissions configured, a member of the finance team runs the following code:

If all users on the finance team are members of the finance group, which statement describes how the tx_sales table will be created?

A) A managed table will be created in the DBFS root storage container.
B) An external table will be created in the storage container mounted to /mnt/finance eda bucket.
C) A logical table will persist the query plan to the Hive Metastore in the Databricks control plane.
D) An managed table will be created in the storage container mounted to /mnt/finance_eda_bucket.
E) A logical table will persist the physical plan to the Hive Metastore in the Databricks control plane.

Solutions: