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: Feb 17, 2025

Add To Cart

Question 1

You are asked to setup the alert to notify every time once the data is loaded into a reporting table, team also asked to include the number of records in the alert email notification.

A : notebook and python code to run every minute, using python variables to capture send the information in an email

B : tup an alert but use the default template to notify the message in email’s subject

C : tup an alert but use the custom template to notify the message in email’s subject

D : the webhook destination instead so alert message can be customized

E : custom email hook to customize the message

Answer: C

Question 2

When investigating a data issue, if you are looking compare the current version of the data with the previous version, what is the best way to query historical data?

A : LECT * FROM TIME_TRAVEL(table_name) where time_stamp = 'timestamp'

B : ME_TRAVEL FROM table_name where time_stamp = 'timestamp'

C : LECT * FROM table_name as of 'timestamp'

D : CRIBE HISTORY table_name as of 'timestmap'

E : OW HISTORY table_name as of 'timestmap'

Answer: C

Question 3

Delete records from the transactions Delta table where transactionDate is greater than current timestamp?

A : LETE FROM transactions FORMAT DELTA where transactionDate > currenct_timestmap()

B : LETE FROM transactions if transctionDate > current_timestamp()

C : LETE FROM transactions where transactionDate > current_timestamp()

D : LETE FROM transactions where transactionDate > current_timestamp() KEEP_HISTORY

E : LET FROM transactions where transactionDate GE current_timestamp()

Answer: C

Question 4

Which of the following locations hosts the driver and worker nodes of a Databricks-managed cluster?

A : ta plane

B : ntrol plane

C : tabricks Filesystem

D : BC data source

E : tabricks web application

Answer: A

Question 5

You noticed that colleague is manually copying the notebook with _bkp to store the previous versions, which of the following feature would you recommend instead.

A : tabricks notebooks support change tracking and versioning

B : tabricks notebooks should be copied to a local machine and setup source control locally to version the notebooks

C : tabricks notebooks can be exported into dbc archive files and stored in data lake

D : tabricks notebook can be exported as HTML and imported at a later time

Answer: A

Page: 1 / 63

Total 315 Questions | Updated On: Feb 17, 2025

Add To Cart