In the context of optimizing high-frequency trading data ingestion into a lakehouse, which data modeling technique ensures minimal ingestion latency while keeping the data immediately available for real-time analytics?

Real Exam

Ingest data directly into a traditional RDBMS, then periodically migrate to the lakehouse for long-term storage and analysis.

3.3%

Use a single, monolithic table to store all incoming data, relying on the lakehouse‘s built-in optimization for real-time query performance.

15.4%

Model the data in a series of append-only tables, partitioned by ingestion timestamp, and optimize queries using Z-ordering on relevant columns.

63.7%

Implement a micro-batching approach with a complex ETL pipeline that transforms and loads data into partitioned Delta tables.

17.6%

Databricks Certified Data Engineer - Professional