Exam DP203 SQL Management

SQL Pool management

In SQL pools, the unit of scale is an abstraction of compute power that is known as a DWU - data warehouse unit

You can scale a Synapse SQL dedicated pool through:

1. Azure portal (click on Scale, then drag a slider)
2. Synapse Studio (also right-click- scale + slider)
3. TSQL: ALTER DATABASE mySampleDataWarehouse MODIFY (SERVICE_OBJECTIVE = 'DW300c')
4. PowerShell: Set-AzSqlDatabase -ResourceGroupName "resourcegroupname" -DatabaseName "mySampleDataWarehouse" -ServerName "sqlpoolservername" -RequestedServiceObjectiveName "DW300c"

To do the same with Spark pools, you can also click "Scale". Note you can also apply autoscale. (I don't think you can autoscale with SQL dedicated pools).