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 23, 2025

Add To Cart

Question 1

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 2

An upstream system has been configured to pass the date for a given batch of data to the Databricks Jobs API as a parameter. The notebook to be scheduled will use this parameter to load data with the following code: df = spark.read.format("parquet").load(f"/mnt/source/(date)") Which code block should be used to create the date Python variable used in the above code block?

A : date = spark.conf.get("date")

B : input_dict = input() date= input_dict["date"]

C : import sys date = sys.argv[1]

D : date = dbutils.notebooks.getParam("date")

E : dbutils.widgets.text("date", "null") date = dbutils.widgets.get("date")

Answer: E

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

The data engineering team has a Silver table called ‘sales_cleaned’ where new sales data is appended in near real-time.

They want to create a new Gold-layer entity against the ‘sales_cleaned’ table to calculate the year-to-date (YTD) of the sales amount. The new entity will have the following schema:

country_code STRING, category STRING, ytd_total_sales FLOAT, updated TIMESTAMP

It’s enough for these metrics to be recalculated once daily. But since they will be queried very frequently by several business teams, the data engineering team wants to cut down the potential costs and latency associated with materializing the results.

Which of the following solutions meets these requirements?

A : Define the new entity as a view to avoid persisting the results each time the metrics are recalculated

B : Define the new entity as a global temporary view since it can be shared between notebooks or jobs that share computing resources.

C : Configuring a nightly batch job to recalculate the metrics and store them as a table overwritten with each update

D : Create multiple tables, one per business team so the metrics can be queried quickly and efficiently.

E : All the above solutions meet the required requirements since Databricks uses the Delta Caching feature

Answer: C

Question 5

The data engineering team has a secret scope named ‘DataOps-Prod’ that contains all secrets needed by DataOps engineers in a production workspace.

Which of the following is the minimum permission required for the DataOps engineers to use the secrets in this scope ?

A : MANAGE permission on the “DataOps-Prod” scope

B : READ permission on the “DataOps-Prod” scope

C : MANAGE permission on each secret in the “DataOps-Prod” scope

D : READ permission on each secret in the “DataOps-Prod” scope

E : Workspace Administrator role

Answer: B

Page: 1 / 50

Total 247 Questions | Updated On: Apr 23, 2025

Add To Cart