CertsTopics Logo

Summer Certification Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

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

Page: 17 / 17
Total 230 questions
Get Databricks-Certified-Data-Engineer-Associate Full Access Download Databricks-Certified-Data-Engineer-Associate PDF

Databricks Certified Data Engineer Associate Exam Questions and Answers

Question 65

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 in the log.

Which command should the Data Engineer use to achieve this? (Choose two.)

Options:

A.

SELECT * FROM students@v4

B.

SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:47.000+00:00’

C.

SELECT * FROM students FROM HISTORY VERSION AS OF 3

D.

SELECT * FROM students VERSION AS OF 5

E.

SELECT * FROM students TIMESTAMP AS OF ‘2024-04-22T 14:32:58.000+00:00’

Question 66

A data engineer and data analyst are working together on a data pipeline. The data engineer is working on the raw, bronze, and silver layers of the pipeline using Python, and the data analyst is working on the gold layer of the pipeline using SQL The raw source of the pipeline is a streaming input. They now want to migrate their pipeline to use Delta Live Tables.

Which change will need to be made to the pipeline when migrating to Delta Live Tables?

Options:

A.

The pipeline can have different notebook sources in SQL & Python.

B.

The pipeline will need to be written entirely in SQL.

C.

The pipeline will need to be written entirely in Python.

D.

The pipeline will need to use a batch source in place of a streaming source.

Question 67

Identify a scenario to use an external table.

A Data Engineer needs to create a parquet bronze table and wants to ensure that it gets stored in a specific path in an external location.

Which table can be created in this scenario?

Options:

A.

An external table where the location is pointing to specific path in external location.

B.

An external table where the schema has managed location pointing to specific path in external location.

C.

A managed table where the catalog has managed location pointing to specific path in external location.

D.

A managed table where the location is pointing to specific path in external location.

Question 68

A data engineer observes that an ETL job in Databricks has increased its execution time from a five-minute baseline to 12 minutes over the past week. Using the Lakeflow Jobs run-history view, the engineer needs to identify whether the slowdown is consistent or intermittent and determine its root cause.

Which action should the engineer take to analyze execution-time trends against the baseline?

Options:

A.

Automatically increase the cluster size whenever execution time exceeds the previous run’s duration.

B.

Compare cluster metrics in the Lakeflow Jobs run history to identify resource spikes that are causing delays.

C.

Archive old job runs and reset the baseline counter to ensure an accurate comparison of current performance.

D.

Rerun the job immediately to establish a new baseline because historical data becomes irrelevant after seven days.

Page: 17 / 17
Total 230 questions
Get Databricks-Certified-Data-Engineer-Associate Full Access Download Databricks-Certified-Data-Engineer-Associate PDF