Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Azure Data Explorer (ADX) is a fully managed analytics service purpose-built for high-volume telemetry and log data. It can ingest data directly from Azure Event Hubs and can also load Avro files from Azure Blob Storage by applying an appropriate ingestion mapping or using a simple transformation step during ingestion. ADX automatically indexes data as it arrives, enabling complex, ad-hoc time-series and anomaly-detection queries to execute in seconds with Kusto Query Language. Because Microsoft manages scaling, patching, and cluster maintenance, operational overhead is minimal.

A dedicated SQL pool in Azure Synapse Analytics is tuned for large-scale batch warehousing workloads; achieving consistent sub-second latency for highly concurrent time-series analysis generally requires significant performance tuning. An Azure HDInsight cluster running Hive provides distributed processing but requires you to provision, size, and monitor the cluster and typically delivers higher query latency than required. Azure SQL Database Hyperscale can handle substantial streaming ingestion but is optimized for transactional and mixed analytical workloads rather than specialized time-series analytics at this scale. Therefore, Azure Data Explorer is the most suitable choice.