Free Databricks Databricks-Certified-Associate-Data-Engineer Exam Questions

Become Databricks Certified with updated Databricks-Certified-Associate-Data-Engineer exam questions and correct answers

Page: 1 / 63

Total 315 Questions | Updated On: Mar 26, 2025

Add To Cart

Question 1

You had setup a new all-purpose cluster, but the cluster is unable to start which of the following steps do you need to take to resolve this issue?

A : eck the cluster driver logs

B : eck the cluster event logs

C : rkspace logs

D : orage account

E : ta plane

Answer: B

Question 2

You are currently working on a project that requires the use of SQL and Python in a given notebook, what would be your approach

A : eate two separate notebooks, one for SQL and the second for Python

B : ingle notebook can support multiple languages, use the magic command to switch between the two.

C : an All-purpose cluster for python, SQL endpoint for SQL

D : job cluster to run python and SQL Endpoint for SQL

Answer: B

Question 3

You were asked to identify number of times a temperature sensor exceed threshold temperature (100.00) by each device, each row contains 5 readings collected every 5 minutes, fill in the blank with the appropriate functions

Schema: deviceId INT, deviceTemp ARRAY< double >, dateTimeCollected TIMESTAMP

2022-07-10-07-48-44-ce161b7b323528430beda1ec35cfd36e

SELECT deviceId, __ (__ (__(deviceTemp], i -> i > 100.00)))

FROM devices

GROUP BY deviceId

A : M, COUNT, SIZE

B : M, SIZE, SLICE

C : M, SIZE, ARRAY_CONTAINS

D : M, SIZE, ARRAY_FILTER

E : M, SIZE, FILTER

Answer: A

Question 4

The sales team has asked the Data engineering team to develop a dashboard that shows sales performance for all stores, but the sales team would like to use the dashboard but would like to select individual store location, which of the following approaches Data Engineering team can use to build this functionality into the dashboard.

A : query Parameters which then allow user to choose any location

B : rrently dashboards do not support parameters

C : Databricks REST API to create a dashboard for each location

D : SQL UDF function to filter the data based on the location

E : Dynamic views to filter the data based on the location

Answer: A

Question 5

Which of the following functions can be used to convert JSON string to Struct data type?

A : _STRUCT (json value)

B : OM_JSON (json value)

C : OM_JSON (json value, schema of json)

D : NVERT (json value, schema of json)

E : T (json value as STRUCT)

Answer: C

Page: 1 / 63

Total 315 Questions | Updated On: Mar 26, 2025

Add To Cart