Can you tell me about a project where you used Synapse?

S: I was part of a data engineering team tasked with modernizing the company’s data warehouse. T: The goal was to migrate from an on‑premises SQL Server warehouse to Azure Synapse to improve query performance and scalability. A: I designed the data ingestion pipeline using Azure Data Factory to extract data from multiple source systems, transformed it with Spark notebooks, and loaded it into a dedicated SQL pool. I also set up serverless SQL for ad‑hoc analytics and implemented role‑based access controls. R: The migration reduced query times by 70%, cut storage costs by 30%, and enabled real‑time reporting for the business intelligence team. The project was delivered on schedule and received positive feedback from stakeholders for its performance gains and cost savings.