Azure Synapse Analytics is a data analytics service that includes all services that are required for ingestion, transformation, and visualization of data. It includes Spark Pool and SQL Pools for data analytics. There are two types of SQL Pools – dedicated and serverless. The Serverless Data Pool is optimized for large-scale data with the compute in the pool being distributed and managed by Microsoft. There is room for configuration in structure and file format, with optimization for ad-hoc queries and exploratory data analysis. The Dedicated Data Pool allows for more flexibility in how data is handled in a cost effective manner. It allows for multiple executions of the same or similar queries and automatic scaling without needing additional configuration.