Which ALTER DATABASE statement parameter allows a dedicated SQL pool to scale?

The correct parameter to allow a dedicated SQL pool to scale is the MODIFY parameter. In the context of Azure Synapse Analytics, when you need to adjust the compute resources allocated to a dedicated SQL pool, you use the ALTER DATABASE statement combined with the MODIFY keyword to change the performance level and subsequently scale the pool.

Using the MODIFY parameter lets you specify changes to the resource class or to the DW (Data Warehouse) units, which effectively enables you to resize the dedicated SQL pool according to your requirements. This is crucial for optimizing performance and managing costs according to workload needs.

The other options do not correspond to the specific syntax used in Azure SQL Database operations. For example, SCALE and CHANGE may seem intuitively related but they are not valid keywords in the Azure SQL context for the purpose of scaling a dedicated SQL pool. RESIZE could be misunderstood in general terms of adjustment, but it is not the correct command used for this particular operation in Azure Synapse Analytics.