LFC Delta Live Tables 2

Question 1

What is the key difference between a DLT LIVE TABLE and a LIVE VIEW?

Accepted Answer

LIVE TABLE stores data persistently; LIVE VIEW is a reusable virtual query that does not store data

Answer

A LIVE TABLE materializes and persists query results as a Delta table, while a LIVE VIEW is a virtual definition reused within the pipeline without storing data.

Question 2

What file format do Delta Live Tables use to store their output by default?

Accepted Answer

Delta Lake format

Answer

Delta Live Tables store output in Delta Lake format, enabling ACID transactions, time travel, and schema enforcement on the results.

Question 3

How do you reference another live table within a DLT SQL pipeline?

Accepted Answer

Using the LIVE. prefix before the table name

Answer

Within a DLT pipeline, tables defined in the same pipeline are referenced using the LIVE. namespace prefix (e.g., SELECT * FROM LIVE.my_table).

Question 4

What is a DLT 'pipeline' composed of?

Accepted Answer

A collection of notebooks or source files containing dataset definitions and transformations

Answer

A DLT pipeline can include one or more notebooks or source files, each contributing table and view definitions that together form the full DAG.

Question 5

Which DLT expectation violation action causes the entire pipeline update to fail?

Accepted Answer

FAIL UPDATE

Answer

FAIL UPDATE causes the pipeline update to stop with a failure status if any records violate the expectation, enforcing the strictest data quality guarantee.

(LFC) Lakehouse Fundamentals Certification Practice Test

(LFC) Lakehouse Fundamentals Certification Practice Test

LFC Delta Live Tables 2