Home
Databricks
Databricks-Certified-Data-Engineer-Associate: Databricks Certified Data Engineer Associate Exam

Databricks Certified Data Engineer Associate Exam

Certification Provider: Databricks

Exam Name: Databricks Certified Data Engineer Associate Exam

Number of questions in our database: 45

Exam Version: May. 25, 2023

Exam Official Topics:

Topic 1: Single Topic

Free Databricks Databricks Certified Data Engineer Associate Exam Exam Actual Questions

The questions for Databricks Certified Data Engineer Associate Exam were last updated On May. 25, 2023

Question #1

A data engineer needs to apply custom logic to string column city in table stores for a specific use case. In order to apply this custom logic at scale, the data engineer wants to create a SQL user-defined function (UDF).

Which of the following code blocks creates this SQL UDF?

AOption A

BOption B

COption C

DOption D

EOption E

Reveal Solution

Correct Answer: E

Question #2

Which of the following describes the relationship between Gold tables and Silver tables?

AGold tables are more likely to contain aggregations than Silver tables.

BGold tables are more likely to contain valuable data than Silver tables.

CGold tables are more likely to contain a less refined view of data than Silver tables.

DGold tables are more likely to contain more data than Silver tables.

EGold tables are more likely to contain truthful data than Silver tables.

Reveal Solution

Correct Answer: C

Question #3

A data analyst has a series of queries in a SQL program. The data analyst wants this program to run every day. They only want the final query in the program to run on Sundays. They ask for help from the data engineering team to complete this task.

Which of the following approaches could be used by the data engineering team to complete this task?

AThey could submit a feature request with Databricks to add this functionality.

BThey could wrap the queries using PySpark and use Python's control flow system to determine when to run the final query.

CThey could only run the entire program on Sundays.

DThey could automatically restrict access to the source table in the final query so that it is only accessible on Sundays.

EThey could redesign the data model to separate the data used in the final query into a new table.

Reveal Solution

Correct Answer: B

Question #4

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?

ADatabase

BFunction

CView

DTemporary view

ETable

Reveal Solution

Correct Answer: C

Question #5

A data engineer is maintaining a data pipeline. Upon data ingestion, the data engineer notices that the source data is starting to have a lower level of quality. The data engineer would like to automate the process of monitoring the quality level.

Which of the following tools can the data engineer use to solve this problem?

AUnity Catalog

BData Explorer

CDelta Lake

DDelta Live Tables

EAuto Loader

Reveal Solution

Correct Answer: C

Unlock all Databricks Certified Data Engineer Associate Exam Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now

Disscuss Databricks Databricks Certified Data Engineer Associate Exam Topics, Questions or Ask Anything Related

Submit Cancel