Knowledge check

1.

Which extraction type should a data engineer choose when the source system has a reliable timestamp column and hourly data freshness is sufficient?

Full extraction

Incremental extraction

Streaming extraction

2.

What is the primary advantage of Delta Lake over Parquet as a table format in Azure Databricks?

Delta Lake provides ACID transactions and time travel capabilities through its transaction log

Delta Lake offers better columnar storage compression than Parquet

Delta Lake supports a wider variety of data types than Parquet

3.

When is data partitioning recommended for Delta Lake tables?

For all tables to ensure consistent query performance

When the table contains more than 1 TB of data and query filters align with partition columns

Only for tables with high-cardinality columns like customer ID

4.

Which SCD type should be selected when historical accuracy is required for sales attribution by customer region?

SCD Type 1

SCD Type 2

SCD Type 3

5.

What is the key benefit of liquid clustering compared to traditional partitioning in Delta Lake?

Liquid clustering provides better data compression

Liquid clustering allows changing clustering keys without rewriting existing data

Liquid clustering eliminates the need for the OPTIMIZE command

Check your knowledge