My data needs are not so vast to utilize the MPP. Thus it seems I should be considering #2, i.e. outside the Synapse Analytics.
Azure SQL (#2) above further branches into "Single Database", "Elastic pool" and "Single instance managed DB".
I am guessing that for my scenario, "Azure SQL - Single Database" is the best option.
If I choose this, will I be able to use this storage in Azure Synapse Analytics?
Furthermore, to use Azure Data Factory (ADF) - if I set up "Azure SQL - Single Database", should I be aiming to use Data Factory within Azure Synapse Analytics, or outside it (i.e. use ADF in Azure portal)?