LFC Delta Live Tables

Question 1

What is Delta Live Tables (DLT) in the Databricks ecosystem?

Accepted Answer

A declarative ETL framework for building reliable data pipelines

Answer

Delta Live Tables is a declarative ETL framework that automates pipeline infrastructure management and enforces data quality constraints.

Question 2

Which Python decorator is used to define a materialized Delta table in a DLT pipeline?

Accepted Answer

@dlt.table

Answer

The @dlt.table decorator defines a materialized table whose results are stored persistently as a Delta table.

Question 3

What is the primary purpose of DLT Expectations?

Accepted Answer

To enforce data quality constraints and handle invalid records

Answer

DLT Expectations allow you to define data quality constraints with named rules and specify actions to take when records violate them.

Question 4

Which DLT pipeline execution mode processes all available data and then stops?

Accepted Answer

Triggered mode

Answer

Triggered mode processes all available data at the time of the run and then terminates, making it suitable for scheduled batch workloads.

Question 5

What does the CONSTRAINT clause do in a DLT SQL pipeline?

Accepted Answer

Specifies data quality expectations with a name and condition

Answer

The CONSTRAINT clause in DLT SQL defines a named data quality expectation with a boolean condition that each record must satisfy.

(LFC) Lakehouse Fundamentals Certification Practice Test