Which language is optimized for querying real-time data in an eventhouse?

• A. Python
• B. Java
• C. KQL
• D. SQL

Answer: (C)

Real-time event data querying benefits from a language that handles fast time-based filtering, parsing semi-structured logs, and quick aggregations over time windows. KQL is built for these workloads in Microsoft’s telemetry and log analytics platforms, including eventstores and dashboards. It supports concise time range filtering, field extraction, and aggregations like summarizing counts or metrics by time bins, enabling interactive, near-instantaneous exploration of streaming data. While Python and Java are general-purpose languages and SQL works well for structured relational data, they don’t provide the same native, time-series-oriented operators and performance optimizations that KQL offers for real-time event data.