Can it be stored also in Synapse?
💡 Model Answer
Yes, Synapse can store data in several ways. The dedicated SQL pool stores structured data in a columnar format optimized for analytics. The serverless SQL pool can query data directly from Azure Data Lake Storage without loading it into a warehouse. Spark pools can store and process semi‑structured data in ADLS. Additionally, Synapse supports external tables that reference data in Blob or ADLS, allowing you to keep raw files in the lake while querying them through Synapse. This flexibility lets you choose the most cost‑effective and performance‑optimal storage model for each use case.
This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.
🎤 Get questions like this answered in real-time
Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers — invisible to screen sharing.
Get Assisting AI — Starts at ₹500