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

Stay ahead with 100% Free Databricks Certified Professional Data Engineer Databricks-Certified-Professional-Data-Engineer Dumps Practice Questions

Page: 1 / 50

Total 247 Questions | Updated On: Apr 11, 2025

Add To Cart

Question 1

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

Question 2

A data engineer uses the following SQL query:

GRANT USAGE ON DATABASE sales_db TO finance_team

Which of the following is the benefit of the USAGE privilege ?

A : Gives read access on the database

B : Gives full permissions on the entire database

C : Gives the ability to view database objects and their metadata

D : No effect! but it's required to perform any action on the database

E : USAGE privilege is not part of the Databricks governance model

Answer: D

Question 3

The data engineering team maintains the following code:

Assuming that this code produces logically correct results and the data in the source table has been deduplicated and validated, which statement describes what will occur when this code is executed?

A : The silver_customer_sales table will be overwritten by aggregated values calculated from all records in the gold_customer_lifetime_sales_summary table as a batch job.

B : A batch job will update the gold_customer_lifetime_sales_summary table, replacing only those rows that have different values than the current version of the table, using customer_id as the primary key.

C : The gold_customer_lifetime_sales_summary table will be overwritten by aggregated values calculated from all records in the silver_customer_sales table as a batch job.

D : An incremental job will leverage running information in the state store to update aggregate values in the gold_customer_lifetime_sales_summary table.

E : An incremental job will detect if new rows have been written to the silver_customer_sales table; if new rows are detected, all aggregates will be recalculated and used to overwrite the gold_customer_lifetime_sales_summary table.

Answer: E

Question 4

The data engineering team is using the LOCATION keyword for every new Delta Lake table created in the Lakehouse.

Which of the following describes the purpose of using the LOCATION keyword in this case ?

A : The LOCATION keyword is used to configure the created Delta Lake tables as managed tables.

B : The LOCATION keyword is used to configure the created Delta Lake tables as external tables.

C : The LOCATION keyword is used to define the created Delta Lake tables in an external database.

D : The LOCATION keyword is used to define the created Delta Lake tables in a database over a JDBC connection.

E : The LOCATION keyword is used to set a default schema and checkpoint location for the created Delta Lake tables.

Answer: B

Question 5

The Databricks workspace administrator has configured interactive clusters for each of the data engineering

groups. To control costs, clusters are set to terminate after 30 minutes of inactivity. Each user should be able to

execute workloads against their assigned clusters at any time of the day.

Assuming users have been added to a workspace but not granted any permissions, which of the following

describes the minimal permissions a user would need to start and attach to an already configured cluster.

A : "Can Manage" privileges on the required cluster

B : Workspace Admin privileges, cluster creation allowed, "Can Attach To" privileges on the required cluster

C : Cluster creation allowed, "Can Attach To" privileges on the required cluster

D : "Can Restart" privileges on the required cluster

E : Cluster creation allowed, "Can Restart" privileges on the required cluster

Answer: A

Page: 1 / 50

Total 247 Questions | Updated On: Apr 11, 2025

Add To Cart