thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Intermediate

Azure Synapse Analytics

Azure's analytics service combining dedicated and serverless SQL pools, Spark pools and pipelines; Microsoft now positions Fabric as its successor.

Definition

Dedicated SQL pools are MPP warehouses with hash, round-robin or replicated distributions. Serverless SQL pools query lake files on demand. Microsoft directs new analytics workloads to Fabric and provides migration paths from Synapse.

Exam tip

In a dedicated pool, use hash distribution for large fact tables and replicated tables for small dimensions.

Related terms