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.

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.

FL Ferdous Attaie · Accepted Answer

Remove a database from the pool.

FL Ferdous Attaie · Accepted Answer

Increase the maximum storage of the elastic pool.

FL Ferdous Attaie · Accepted Answer

Shrink individual databases.

FL Ferdous Attaie · Answer

Delete data from a database.

FL Ferdous Attaie · Answer

Enable data compression.

List of questions