Which of the following data lakehouse features results in improved data quality over a traditional data lake?

• A.A data lakehouse provides storage solutions for structured and unstructured data.
• B.A data lakehouse supports ACID-compliant transactions.
• C.A data lakehouse allows the use of SQL queries to examine data.
• D.A data lakehouse stores data in open formats.
• E.A data lakehouse enables machine learning and artificial Intelligence workloads.

Comment: *

Name: *

Email: *

Verification: *

Which of the following is hosted completely in the control plane of the classic Databricks architecture?

• A.Worker node
• B.Databricks Filesystem
• C.Databricks web application
• D.JDBC data source
• E.Driver node

Comment: *

Name: *

Email: *

Verification: *

A data engineer has a single-task Job that runs each morning before they begin working. After identifying an upstream data issue, they need to set up another task to run a new notebook prior to the original task.
Which of the following approaches can the data engineer use to set up the new task?

• A.They can clone the existing task in the existing Job and update it to run the new notebook.
• B.They can create a new task in the existing Job and then add it as a dependency of the original task.
• C.They can create a new task in the existing Job and then add the original task as a dependency of the new task.
• D.They can create a new job from scratch and add both tasks to run concurrently.
• E.They can clone the existing task to a new Job and then edit it to run the new notebook.

Comment: *

Name: *

Email: *

Verification: *

A data engineer has been given a new record of data:
id STRING = 'a1'
rank INTEGER = 6
rating FLOAT = 9.4
Which of the following SQL commands can be used to append the new record to an existing Delta table my_table?

• A.INSERT INTO my_table VALUES ('a1', 6, 9.4)
• B.my_table UNION VALUES ('a1', 6, 9.4)
• C.INSERT VALUES ( 'a1' , 6, 9.4) INTO my_table
• D.UPDATE my_table VALUES ('a1', 6, 9.4)
• E.UPDATE VALUES ('a1', 6, 9.4) my_table

Comment: *

Name: *

Email: *

Verification: *

A data engineer has realized that the data files associated with a Delta table are incredibly small. They want to compact the small files to form larger files to improve performance.
Which of the following keywords can be used to compact the small files?

• A.REDUCE
• B.OPTIMIZE
• C.COMPACTION
• D.REPARTITION
• E.VACUUM

Comment: *

Name: *

Email: *

Verification: *