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 Dec 19,2025.
- Exam Code: Databricks Certified Data Engineer Professional
- Exam Name: Databricks Certified Data Engineer Professional Exam
- Certification Provider: Databricks
- Latest update: Dec 19,2025
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer to run, which of the following steps can be taken to resolve the issue?
- A . They can turn on the Serverless feature for the SQL endpoint.
- B . They can increase the maximum bound of the SQL endpoint’s scaling range.
- C . They can increase the cluster size(2X-Small to 4X-Large) of the SQL endpoint.
- D . They can turn on the Auto Stop feature for the SQL endpoint.
- E . They can turn on the Serverless feature for the SQL endpoint and change the Spot In-stance Policy from “Cost optimized” to “Reliability Optimized.”
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer to run, which of the following steps can be taken to resolve the issue?
- A . They can turn on the Serverless feature for the SQL endpoint.
- B . They can increase the maximum bound of the SQL endpoint’s scaling range.
- C . They can increase the cluster size(2X-Small to 4X-Large) of the SQL endpoint.
- D . They can turn on the Auto Stop feature for the SQL endpoint.
- E . They can turn on the Serverless feature for the SQL endpoint and change the Spot In-stance Policy from “Cost optimized” to “Reliability Optimized.”
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer to run, which of the following steps can be taken to resolve the issue?
- A . They can turn on the Serverless feature for the SQL endpoint.
- B . They can increase the maximum bound of the SQL endpoint’s scaling range.
- C . They can increase the cluster size(2X-Small to 4X-Large) of the SQL endpoint.
- D . They can turn on the Auto Stop feature for the SQL endpoint.
- E . They can turn on the Serverless feature for the SQL endpoint and change the Spot In-stance Policy from “Cost optimized” to “Reliability Optimized.”
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer to run, which of the following steps can be taken to resolve the issue?
- A . They can turn on the Serverless feature for the SQL endpoint.
- B . They can increase the maximum bound of the SQL endpoint’s scaling range.
- C . They can increase the cluster size(2X-Small to 4X-Large) of the SQL endpoint.
- D . They can turn on the Auto Stop feature for the SQL endpoint.
- E . They can turn on the Serverless feature for the SQL endpoint and change the Spot In-stance Policy from “Cost optimized” to “Reliability Optimized.”
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer to run, which of the following steps can be taken to resolve the issue?
- A . They can turn on the Serverless feature for the SQL endpoint.
- B . They can increase the maximum bound of the SQL endpoint’s scaling range.
- C . They can increase the cluster size(2X-Small to 4X-Large) of the SQL endpoint.
- D . They can turn on the Auto Stop feature for the SQL endpoint.
- E . They can turn on the Serverless feature for the SQL endpoint and change the Spot In-stance Policy from “Cost optimized” to “Reliability Optimized.”
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer to run, which of the following steps can be taken to resolve the issue?
- A . They can turn on the Serverless feature for the SQL endpoint.
- B . They can increase the maximum bound of the SQL endpoint’s scaling range.
- C . They can increase the cluster size(2X-Small to 4X-Large) of the SQL endpoint.
- D . They can turn on the Auto Stop feature for the SQL endpoint.
- E . They can turn on the Serverless feature for the SQL endpoint and change the Spot In-stance Policy from “Cost optimized” to “Reliability Optimized.”
You are currently working with the application team to setup a SQL Endpoint point, once the team started consuming the SQL Endpoint you noticed that during peak hours as the number of concur-rent users increases you are seeing degradation in the query performance and the same queries are taking longer to run, which of the following steps can be taken to resolve the issue?
- A . They can turn on the Serverless feature for the SQL endpoint.
- B . They can increase the maximum bound of the SQL endpoint’s scaling range.
- C . They can increase the cluster size(2X-Small to 4X-Large) of the SQL endpoint.
- D . They can turn on the Auto Stop feature for the SQL endpoint.
- E . They can turn on the Serverless feature for the SQL endpoint and change the Spot In-stance Policy from “Cost optimized” to “Reliability Optimized.”
Which of the following locations in the Databricks product architecture hosts the notebooks and jobs?
- A . Data plane
- B . Control plane
- C . Databricks Filesystem
- D . JDBC data source
- E . Databricks web application
A data engineer is using a Databricks SQL query to monitor the performance of an ELT job. The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL query returns the number of minutes since the job’s most recent runtime.
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not been run in an hour?
- A . They can set up an Alert for the accompanying dashboard to notify them if the returned value is greater than 60.
- B . They can set up an Alert for the query to notify when the ELT job fails.
- C . They can set up an Alert for the accompanying dashboard to notify when it has not refreshed in 60 minutes.
- D . They can set up an Alert for the query to notify them if the returned value is greater than 60.
- E . This type of alert is not possible in Databricks
A data engineer is using a Databricks SQL query to monitor the performance of an ELT job. The ELT job is triggered by a specific number of input records being ready to process. The Databricks SQL query returns the number of minutes since the job’s most recent runtime.
Which of the following approaches can enable the data engineering team to be notified if the ELT job has not been run in an hour?
- A . They can set up an Alert for the accompanying dashboard to notify them if the returned value is greater than 60.
- B . They can set up an Alert for the query to notify when the ELT job fails.
- C . They can set up an Alert for the accompanying dashboard to notify when it has not refreshed in 60 minutes.
- D . They can set up an Alert for the query to notify them if the returned value is greater than 60.
- E . This type of alert is not possible in Databricks
