question

RamyaHarinarthini-MSFT avatar image
0 Votes"
RamyaHarinarthini-MSFT asked 61307089 commented

What are the main components of Azure Synapse Analytics?

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


azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered 61307089 commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

شكر لك اجابه مثاليهThank you thank you perfect answer perfect

0 Votes 0 ·
MarriAnandaKrishnaITSSG-6576 avatar image
0 Votes"
MarriAnandaKrishnaITSSG-6576 answered

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




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.