Logo ExamsQA
Exit
Official Bank 0/109

Databricks Certified Data Engineer Associate (Databricks-Certified-Data-Engineer-Associate) - Databricks Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
109 Total Questions
1
Question
A data engineer wants to schedule their Databricks SQL dashboard to refresh every hour, but they only want the associated SQL endpoint to be running when It is necessary. The dashboard has multiple queries on multiple datasets associated with it. The data that feeds the dashboard is automatically processed using a Databricks Job.

Which approach can the data engineer use to minimize the total running time of the SQL endpoint used in the refresh schedule of their dashboard?
Options
A O They can reduce the cluster size of the SQL endpoint.
B O They can set up the dashboard's SQL endpoint to be serverless.
C 0 They can ensure the dashboard's SQL endpoint matches each of the queries' SQL endpoints.
D Q They can turn on the Auto Stop feature for the SQL endpoint.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
A data engineer wants to create a data entity from a couple of tables. The data entity must be used by other data engineers in other sessions. It also must be saved to a physical location.

Which of the following data entities should the data engineer create?
Options
A Database
B View
C Temporary view
D Function
E Table
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
A data engineer has a Job with multiple tasks that runs nightly. Each of the tasks runs slowly because the clusters take a long time to start.

Which of the following actions can the data engineer perform to improve the start up time for the clusters used for the Job?
Options
A They can use endpoints available in Databricks SQL
B They can configure the clusters to be single-node
C They can use clusters that are from a cluster pool
D They can use jobs clusters instead of all-purpose clusters
E They can configure the clusters to autoscale for larger data sizes
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
An engineering manager uses a Databricks SQL query to monitor ingestion latency for each data source. The manager checks the results of the query every day, but they are manually rerunning the query each day and waiting for the results.

Which of the following approaches can the manager use to ensure the results of the query are updated each day?
Options
A They can schedule the query to refresh every 1 day from the SQL endpoint's page in Databricks SQL.
B They can schedule the query to run every 1 day from the Jobs UI.
C They can schedule the query to refresh every 1 day from the query's page in Databricks SQL.
D They can schedule the query to refresh every 12 hours from the SQL endpoint's page in Databricks SQL.
E They can schedule the query to run every 12 hours from the Jobs UI.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
The Delta transaction log for the ‘students’ tables is shown using the ‘DESCRIBE HISTORY students’ command. A Data Engineer needs to query the table as it existed before the UPDATE operation listed

Exhibit

in the log. Which command should the Data Engineer use to achieve this? (Choose two.)
Select 2
Options
A SELECT * FROM students@v4
B SELECT * FROM students VERSION AS OF 5
C SELECT * FROM students FROM HISTORY VERSION AS OF 3
D SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:47.000+00:00’
E SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:58.000+00:00’
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.