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

Become Databricks Certified with updated Databricks-Certified-Professional-Data-Engineer exam questions and correct answers

Page: 1 / 50

Total 247 Questions | Updated On: Apr 16, 2025

Add To Cart

Question 1

Which statement regarding static Delta tables in Stream-Static joins is correct?

A : Static Delta tables must be small enough to be broadcasted to all worker nodes in the cluster.

B : Static Delta tables need to be partitioned in order to be used in stream-static join.

C : Static Delta tables need to be refreshed with REFRESH TABLE command for each microbatch of a stream-static join

D : The latest version of the static Delta table is returned each time it is queried by a microbatch of the stream-static join

E : The latest version of the static Delta table is returned only for the first microbatch of the stream-static join. Then, it will be cached to be used by any upcoming microbatch.

Answer: D

Question 2

The DevOps team has configured a production workload as a collection of notebooks scheduled to run daily using the Jobs UI. A new data engineering hire is onboarding to the team and has requested access to one of these notebooks to review the production logic. What are the maximum notebook permissions that can be granted to the user without allowing accidental changes to production code or data?

A : n Manage

B : n Edit

C : permissions

D : n Read

E : n Run

Answer: D

Question 3

A developer has successfully configured their credentials for Databricks Repos and cloned a remote Git repository. They do not have privileges to make changes to the main branch, which is the only branch currently visible in their workspace.

Which approach allows this user to share their code updates without the risk of overwriting the work of their teammates?

A : Use Repos to create a new branch, commit all changes, and push changes to the remote Git repository.

B : Use Repos to create a fork of the remote repository, commit all changes, and make a pull request on the source repository.

C : Use Repos to pull changes from the remote Git repository; commit and push changes to a branch that appeared as changes were pulled.

D : Use Repos to merge all differences and make a pull request back to the remote repository.

Answer: A

Question 4

Although the Databricks Utilities Secrets module provides tools to store sensitive credentials and avoid accidentally displaying them in plain text users should still be careful with which credentials are stored here and which users have access to using these secrets. Which statement describes a limitation of Databricks Secrets?

A : cause the SHA256 hash is used to obfuscate stored secrets, reversing this hash will display the value in plain text.

B : count administrators can see all secrets in plain text by logging on to the Databricks Accounts console.

C : crets are stored in an administrators-only table within the Hive Metastore; database administrators have permission to query this table by default.

D : erating through a stored secret and printing each character will display secret contents in plain text.

E : Databricks REST API can be used to list secrets in plain text if the personal access token has proper credentials.

Answer: D

Question 5

Which of the following describes Cron syntax in Databricks Jobs ?

A : It’s an expression to represent the maximum concurrent runs of a job

B : It’s an expression to represent the retry policy of a job

C : It’s an expression to describe the email notification events (start, success, failure)

D : It’s an expression to represent the run timeout of a job

E : It’s an expression to represent complex job schedule that can be defined programmatically

Answer: E

Page: 1 / 50

Total 247 Questions | Updated On: Apr 16, 2025

Add To Cart