Microsoft
DP-300 · Question #256
You have an Azure SQL Database elastic pool that contains 10 databases. You receive the following alert. Msg 1132, Level 16, state 1, Line 1 The elastic pool has reached its storage limit. The…
The correct answer is A. Increase the maximum storage of the elastic pool. C. Remove a database from the pool. E. Shrink individual databases. https://learn.microsoft.com/en-us/azure/azure-sql/database/file-space-manage?view=azuresql-db
Submitted by daniela_cl· Mar 6, 2026Monitor, configure, and optimize database resources
Question
You have an Azure SQL Database elastic pool that contains 10 databases. You receive the following alert. Msg 1132, Level 16, state 1, Line 1 The elastic pool has reached its storage limit. The storage used for the elastic pool cannot exceed (76800) MBs. You need to resolve the alert. The solution must minimize administrative effort. Which three actions can you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- AIncrease the maximum storage of the elastic pool.
- BDelete data from a database.
- CRemove a database from the pool.
- DEnable data compression.
- EShrink individual databases.
How the community answered
(31 responses)- A81% (25)
- B6% (2)
- D13% (4)
Explanation
https://learn.microsoft.com/en-us/azure/azure-sql/database/file-space-manage?view=azuresql-db
Topics
#elastic pool#storage limit#database shrink#pool management
Community Discussion
No community discussion yet for this question.