Question 1

Which of the following can be used to simplify and unify siloed data architectures that are specialized for specific use cases?

Options :

A : None of these

B : Data lake

C : Data warehouse

D : All of these

E : Data lakehouse

Answer: E

Question 2

Which of the following is not a privilege in the Unity catalog?

Options :

A : SELECT

B : MODIFY

C : EXECUTE

D : CREATE

E : USAGE

Answer: C

Question 3

The data engineering team is using a SQL query to review data completeness every day to monitor the ETL job, and query output is being used in multiple dashboards which of the following approaches can be used to set up a schedule and automate this process?

Options :

A : They can schedule the query to run every day from the Jobs UI.

B : They can schedule the query to refresh every day from the query’s page in Databricks SQL

C : They can schedule the query to run every 12 hours from the Jobs UI.

D : They can schedule the query to refresh every day from the SQL endpoint’s page in Databricks SQL.

E : They can schedule the query to refresh every 12 hours from the SQL endpoint’s page in Databricks SQL

Answer: B

Question 4

When you drop a managed table using SQL syntax DROP TABLE table_name how does it impact metadata, history, and data stored in the table?

Options :

A : Drops table from meta store, drops metadata, history, and data in storage.

B : Drops table from meta store and data from storage but keeps metadata and history in storage

C : Drops table from meta store, meta data and history but keeps the data in storage

D : Drops table but keeps meta data, history and data in storage

E : Drops table and history but keeps meta data and data in storage

Answer: A

Question 5

A data engineer that is new to using Python needs to create a Python function to add two integers together and return the sum?

Which of the following code blocks can the data engineer use to complete this task?

Options :

A :

B :

C :

D :

E :

Answer: D

Free Databricks-Certified-Associate-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: