What are the main components of Azure Synapse Analytics?

Question

What are the main components of Azure Synapse Analytics?

[Note: As we migrate from MSDN, this question has been posted by an Azure Cloud Engineer as a frequently asked question]

Sourced from Azure Synapse FAQ

Answer 1

Welcome to the Microsoft Q&A platform.

Happy to answer your questions.

Azure Synapse has the following capabilities:

• • Analytics capabilities are offered through SQL pool or SQL on-demand (preview) (Serverless).
• Apache Spark pool (preview) with full support for Scala, Python, SparkSQL, and C#
• Data Flow offering a code-free big data transformation experience
• Data Integration & Orchestration to integrate your data and operationalize all of your code development
• Studio to access all of these capabilities through a single Web UI

Hope this helps.

Sourced from Azure Synapse FAQ

Answer 2

You need to classify your use cases. Below are some examples

1. Personas - Data Analyst/Scientists/ML/AI
   Performs SQL/Spark queries on data. (Components - Spark Spool , Serverless SQL Pool)
   Typically readonly database objects
   Power BI integration
2. Persona - Data Engineers
   Database creations (lake database/serverless/SQL DW)
   pipelines/dataflow
   datawarehouse (Component - dedicated SQLPool)
3. Persona - Administrator
   Spool creations
   Linked services
   security