Azure Synapse Analytics

Components

Components of Synapse Analytics are

Synapse SQL	T-SQL based analytics, available as SQL pool and SQL on-demand.
Spark	Big Data
Synapse Pipelines	Data integration and ETL/ELT
Studio	Unified experience for managing, monitoring, coding and security.

Azure Synapse integrates well with other Azure services such as

Data Warehouse Units (DWU)

Data Warehouse Units are used to measure performance and consumption of resources and then calculate billing.

The service level determines the available Data Warehouse Units.

Costs for storage and computing are determined separately.

It's possible to select the current DWU numbers with SQL

select
   db.name              db_name, -- [Database],
   ds.edition                  , -- [Edition] ,
   ds.service_objective          -- [Service Objective]
from
   sys.database_service_objectives as ds join
   sys.databases                   as db on ds.database_id = db.database_id
;

Database Transaction Unit (DTU)

A given DTU allows for a specific amount of DWU.

Synapse SQL Pool

A Synapse SQL Pool is the entirety of the enterprise data warehousing features that are available with Azure Synopse.

Service objective

create database dbFooBarBaz (
  edition           = 'Datawarehouse',
  SERVICE_OBJECTIVE = 'DW1000c'
)

Querying Synapse with Power BI

It is possible to query Synapse with Power BI. However, Microsoft recommends to consider Power BI on top of Azure Analysis Services or Analysis Service IaaS.

Misc

Apparently, primary key and unique constraints can only be created as not enforced.