Exam DP-300 topic 1 question 43 discussion

To resolve the storage limit alert for your Azure SQL Database elastic pool, you can: A. Increase the maximum storage limit of the elastic pool through Azure's management tools, which is a quick fix requiring minimal administrative effort. D. Enable data compression to reduce the storage size of tables and indexes, which can provide space savings without data loss. E. Shrink individual databases to release unused space back to the pool, although this should be done carefully to avoid performance issues due to fragmentation. Options B and C are less desirable as they involve deleting data or databases, which requires more effort and could impact your applications. Always consider the long-term implications and monitor storage after making changes to prevent future issues.

Correct

I think it is ACE. D. enable data compression - will compress the data inside the database files, but won't change the size of the database files itself immediately.

https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql#elastic-pool-errors

ACD - A and D are fairly obvious , E is fraught with potential problems , B involves losing data the way the question is phrased , which must be undesirable

C is not valid as in A, you already increased pool size.

ACD, study the free material on the MS site.

Answer looks good - don't forget all these options could work but the question mentions the solutions must be the ones of "least administrative effort". For example option B Deleting data isn't as simple as it seems, you'd need to discover what data can be deleted, get permission from compliance teams on whether you can delete the "old/unused" data etc.

I agree with chandlermonica833

Isn't taking a DB out of the pool the same fix as deleting data?

https://stackoverflow.com/questions/52496146/azure-sql-server-error-the-elastic-pool-has-reached-its-storage-limit-the-sto https://learn.microsoft.com/en-us/azure/azure-sql/database/file-space-manage?view=azuresql-db increase resource size shrink database move a database to another tier

A,C,E are the only options that will resolve the issue with elastic DB pools.

If we need to directly resolve the alert, I think the answer is correct.