DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ22

Monitor, configure, and optimize database resources

You have an Azure SQL Database elastic pool that includes 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 while minimizing administrative effort.

Which three actions can you take? Each correct answer provides a complete solution.

NOTE: Each correct selection is worth one point.

Choose three
Explanation

Elastic-pool storage is shared by its databases. The limit can be resolved by increasing the pool’s maximum storage, moving a database outside the pool so its storage is no longer shared there, or shrinking a database to reclaim unused allocated file space. Deleting rows alone does not automatically reclaim allocated file space; compression is not a guaranteed complete remedy for the pool-level storage limit.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!