Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
A
Ingest data directly into a traditional RDBMS, then periodically migrate to the lakehouse for long-term storage and analysis.
B
Use a single, monolithic table to store all incoming data, relying on the lakehouse‘s built-in optimization for real-time query performance.
C
Model the data in a series of append-only tables, partitioned by ingestion timestamp, and optimize queries using Z-ordering on relevant columns.
D
Implement a micro-batching approach with a complex ETL pipeline that transforms and loads data into partitioned Delta tables.
