Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Serverless SQL pool in Azure Synapse Analytics lets you query data stored in Azure Data Lake Storage by using standard T-SQL without first loading it into dedicated tables. Because the compute layer is entirely managed by the platform, there are no clusters to provision or maintain, and capacity scales transparently on a pay-per-query basis. Serverless SQL pools expose a SQL endpoint that Power BI can use for direct connectivity. HDInsight with Spark would require you to deploy and manage clusters and use Spark SQL rather than native T-SQL. Azure SQL Database Hyperscale cannot query files directly in Data Lake and would require data ingestion into relational tables, adding cost and latency. Azure Data Lake Analytics (U-SQL) is a deprecated service and does not provide the low-latency interactive T-SQL experience required. Therefore, the serverless SQL pool option in Azure Synapse Analytics best meets all the stated requirements.