Practice Databricks-Certified-Professional-Data-Engineer Exam Online

Question 1

Which of the following describes the minimal permissions a data engineer needs to start and terminate an existing cluster ?

A : “Can Attach To” privilege on the cluster

B : “Can Restart” privilege on the cluster

C : “Can Manage” privilege on the cluster

D : Cluster creation allowed + “Can Attach To” privileges on the cluster

E : Cluster creation allowed + “Can Restart” privileges on the cluster

Answer: B

Question 2

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 : %sh triggers a cluster restart to collect and install Git. Most of the latency is related to cluster startup time

B :

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.

C : %sh does not distribute file moving operations; the final line of code should be updated to use %fs instead.

D :

Python will always execute slower than Scala on Databricks. The run.py script should be refactored to Scala

E :

%sh executes shell code on the driver node. The code does not take advantage of the worker nodes or Databricks optimized Spark.

Answer: C

Question 3

The data engineering team is looking for a simple solution to share part of a large Delta Lake table with the data science team. Only department-specific columns in the table need to be shared, but with different names. In addition, there is some sensitive data that must be filtered out before sharing.

Which of the following objects can be created to meet the specified requirements ?

A : A new Delta Table created using DEEP CLONE from the existing table

B : A new Delta Table created using SHALLOW CLONE from the existing table

C : A new Delta Table created using CTAS statement on the existing table

D : A stored view on the existing table

E : An ad-hoc query on the existing table

Answer: D

Question 4

A distributed team of data analysts share computing resources on an interactive cluster with autoscaling configured. In order to better manage costs and query throughput, the workspace administrator is hoping to evaluate whether cluster upscaling is caused by many concurrent users or resource-intensive queries. In which location can one review the timeline for cluster resizing events?

A : Workspace audit logs

B : Driver's log file

C : Ganglia

D : Cluster Event Log

E : Executor's log file

Answer: C

Question 5

A junior developer complains that the code in their notebook isn't producing the correct results in the development environment. A shared screenshot reveals that while they're using a notebook versioned with Databricks Repos, they're using a personal branch that contains old logic. The desired branch named dev2.3.9 is not available from the branch selection dropdown. Which approach will allow this developer to review the current logic for this notebook?

A : Use Repos to make a pull request use the Databricks REST API to update the current branch to dev2.3.9

B : Use Repos to pull changes from the remote Git repository and select the dev-2.3.9 branch

C : Use Repos to checkout the dev-2.3.9 branch and auto-resolve conflicts with the current branch

D : Merge all changes back to the main branch in the remote Git repository and clone the repo again

E : Use Repos to merge the current branch and the dev-2.3.9 branch, then make a pull request to sync with the remote repository

Answer: B

Name:	Databricks Certified Professional Data Engineer
Exam Code:	Databricks-Certified-Professional-Data-Engineer
Certification:	Databricks Certified Professional
Vendor:	Databricks
Total Questions:	198
Last Updated:	Apr 23, 2024

Databricks Databricks-Certified-Professional-Data-Engineer