Microsoft Certified Azure Data Engineer Associate · Free Practice Question Easy
Question 14
Which ALTER DATABASE statement parameter allows a dedicated SQL pool to scale?
-
A
CHANGE -
B
SCALE -
C
OVER -
D
MODIFY
Reveal correct answer
Correct answer: D
Explanation
MODIFY is used to scale a dedicated SQL pool.
In the following example, we use the ALTER DATABASE T-SQL statement to modify the service objective. Run the following query to change the service objective to DW300.
- SQL
- ALTER DATABASE mySampleDataWarehouse
- MODIFY (SERVICE_OBJECTIVE = 'DW300c');
A. The CHANGE parameter is not commonly used in the ALTER DATABASE statement for scaling a dedicated SQL pool. When it comes to scaling a SQL pool, the MODIFY parameter is typically used to make the necessary adjustments to the pool's configuration, such as changing the number of DWUs.
B. The SCALE parameter is not typically used in the context of the ALTER DATABASE statement for scaling a dedicated SQL pool. While scaling involves adjusting the resources allocated to the pool, the specific parameter used for this purpose is usually MODIFY rather than SCALE.
C. The OVER parameter is not relevant to the process of scaling a dedicated SQL pool using the ALTER DATABASE statement. This parameter is not typically used in the context of adjusting the resources allocated to a SQL pool, which is the primary purpose of scaling in this scenario.
D. The ALTER DATABASE statement with the MODIFY parameter is used to make changes to the configuration of a database, including scaling a dedicated SQL pool. This parameter allows you to adjust the resources allocated to the SQL pool, such as increasing or decreasing the number of Data Warehouse Units (DWUs) to scale the pool accordingly.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
