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: Jan 10, 2025

Add To Cart

Question 1

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 2

A DLT pipeline includes the following streaming tables:

• raw_iot ingests raw device measurement data from a heart rate tracking device.

• bpm_stats incrementally computes user statistics based on BPM measurements from raw_iot.

How can the data engineer configure this pipeline to be able to retain manually deleted or updated records in the raw_iot table, while recomputing the downstream table bpm_stats table when a pipeline update is run?

A : Set the pipelines.reset.allowed property to false on raw_iot

B : Set the skipChangeCommits flag to true on raw_iot

C : Set the pipelines.reset.allowed property to false on bpm_stats

D : Set the skipChangeCommits flag to true on bpm_stats

Answer: B

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

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

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: Jan 10, 2025

Add To Cart