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: Feb 15, 2025

Add To Cart

Question 1

A data engineer wants to upload a CSV file from local system storage to the DBFS of a Databricks workspace. They have Databricks CLI already configured on the local system.

Which of the following Databricks CLI commands can the data engineer use to complete this task ?

A : workspace

B : fs

C : jobs

D : configure

E : libraries

Answer: B

Question 2

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 3

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

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: D

Question 5

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

Page: 1 / 50

Total 247 Questions | Updated On: Feb 15, 2025

Add To Cart