Databricks Databricks Certified Data Engineer Professional Databricks Certified Data Engineer Professional Exam Online Training
Databricks Databricks Certified Data Engineer Professional Online Training
The questions for Databricks Certified Data Engineer Professional were last updated at May 11,2025.
- Exam Code: Databricks Certified Data Engineer Professional
- Exam Name: Databricks Certified Data Engineer Professional Exam
- Certification Provider: Databricks
- Latest update: May 11,2025
You are tasked to set up a set notebook as a job for six departments and each department can run the task parallelly, the notebook takes an input parameter dept number to process the data by department, how do you go about to setup this up in job?
- A . Use a single notebook as task in the job and use dbutils.notebook.run to run each note-book with parameter in a different cell
- B . A task in the job cannot take an input parameter, create six notebooks with hardcoded dept number and setup six tasks with linear dependency in the job
- C . A task accepts key-value pair parameters, creates six tasks pass department number as parameter foreach task with no dependency in the job as they can all run in parallel. (Correct)
- D . A parameter can only be passed at the job level, create six jobs pass department number to each job with linear job dependency
- E . A parameter can only be passed at the job level, create six jobs pass department number to each job with no job dependency
Which of the following commands can be used to run one notebook from another notebook?
- A . notebook.utils.run("full notebook path")
- B . execute.utils.run("full notebook path")
- C . dbutils.notebook.run("full notebook path")
- D . only job clusters can run notebook
- E . spark.notebook.run("full notebook path")
Which of the following commands can be used to run one notebook from another notebook?
- A . notebook.utils.run("full notebook path")
- B . execute.utils.run("full notebook path")
- C . dbutils.notebook.run("full notebook path")
- D . only job clusters can run notebook
- E . spark.notebook.run("full notebook path")
You have configured AUTO LOADER to process incoming IOT data from cloud object storage every 15 mins, recently a change was made to the notebook code to update the processing logic but the team later realized that the notebook was failing for the last 24 hours, what steps team needs to take to reprocess the data that was not loaded after the notebook was corrected?
- A . Move the files that were not processed to another location and manually copy the files into the ingestion path to reprocess them
- B . Enable back_fill = TRUE to reprocess the data
- C . Delete the checkpoint folder and run the autoloader again
- D . Autoloader automatically re-processes data that was not loaded
- E . Manually re-load the data
John Smith is a newly joined team member in the Marketing team who currently has access read access to sales tables but does not have access to delete rows from the table, which of the following commands help you accomplish this?
- A . GRANT USAGE ON TABLE table_name TO [email protected]
- B . GRANT DELETE ON TABLE table_name TO [email protected]
- C . GRANT DELETE TO TABLE table_name ON [email protected]
- D . GRANT MODIFY TO TABLE table_name ON [email protected]
- E . GRANT MODIFY ON TABLE table_name TO [email protected]
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
- A . MERGE INTO table_name
- B . COPY INTO table_name
- C . UPDATE table_name
- D . INSERT INTO OVERWRITE table_name
- E . INSERT IF EXISTS table_name
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
- A . MERGE INTO table_name
- B . COPY INTO table_name
- C . UPDATE table_name
- D . INSERT INTO OVERWRITE table_name
- E . INSERT IF EXISTS table_name
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
- A . MERGE INTO table_name
- B . COPY INTO table_name
- C . UPDATE table_name
- D . INSERT INTO OVERWRITE table_name
- E . INSERT IF EXISTS table_name
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
- A . MERGE INTO table_name
- B . COPY INTO table_name
- C . UPDATE table_name
- D . INSERT INTO OVERWRITE table_name
- E . INSERT IF EXISTS table_name
Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
- A . MERGE INTO table_name
- B . COPY INTO table_name
- C . UPDATE table_name
- D . INSERT INTO OVERWRITE table_name
- E . INSERT IF EXISTS table_name
Latest Databricks Certified Data Engineer Professional Dumps Valid Version with 278 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
