Solutions built within the Power Platform should be future-proof and stable.
Before you start developing your application, one part of your analysis should be to choose the right data layer.
Changing your data layer afterwards might be a painful experience. You need a migration project and probably you had issues which made you move to Dataverse or another relational data layer like Azure SQL.
In order to help you choose the right data layer, I did an attempt to create some kind of infographic.
This infographic is not the holy grail, it contains some basic facts to help you make aware of the different data layer options for Microsoft Power Platform.