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

LIVE TABLE is read-only; LIVE VIEW is writable

Answer

LIVE TABLE uses SQL only; LIVE VIEW uses Python only

Answer

There is no functional difference between them

Question 2

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

Accepted Answer

Delta Lake format

Answer

Parquet

Answer

CSV

Answer

ORC

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

Using only the regular table name

Answer

Using a correlated subquery

Answer

Using an external database catalog reference

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 single notebook with exactly one table definition

Answer

A set of Databricks Jobs linked together

Answer

A cluster configuration YAML file

Question 5

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

Accepted Answer

FAIL UPDATE

Answer

WARN

Answer

DROP ROW

Answer

QUARANTINE

Question 6

What is Auto Loader in the context of Delta Live Tables pipelines?

Accepted Answer

A tool that incrementally ingests new files arriving in cloud storage into Delta tables

Answer

A feature that automatically loads machine learning models into serving

Answer

A cluster auto-scaling feature for DLT pipelines

Answer

A SQL optimizer that automatically rewrites DLT queries

Question 7

What advantage does Continuous pipeline mode offer over Triggered mode?

Accepted Answer

Lower latency for near-real-time data processing

Answer

Lower compute cost per pipeline run

Answer

Simpler pipeline configuration and setup

Answer

Better support for one-time batch workloads