Microsoft folded a massively parallel warehouse service into Synapse Analytics as a dedicated pool. What was that service called before it was renamed?
Show answer and explanation
Answer: A
The dedicated SQL pool in Synapse Analytics was previously known as Azure SQL Data Warehouse, often abbreviated SQL DW. It uses massively parallel processing across provisioned compute measured in data warehouse units. SQL Edge targets IoT and edge devices, Data Lake Analytics was a retired job service, and Analysis Services hosts tabular semantic models.
Why the other options are wrong
- B. Azure SQL Edge is a lightweight SQL engine built for IoT and edge devices. It was never the earlier name of the Synapse warehouse component.
- C. Azure Data Lake Analytics was a pay-per-job analytics service that has since been retired. It was a separate product and not the earlier name of a Synapse pool.
- D. Azure Analysis Services hosts tabular semantic models for BI tools. It is a different product that serves models rather than providing warehouse storage and MPP queries.
Exam tip. A dedicated SQL pool is the renamed Azure SQL Data Warehouse.