Dynamically scaling SQL PaaS elastic pool DB
Azure Analysis Services – Scale and Pause or Resume using scheduled autoscaling
Auto-archival using Elastic Jobs or Azure Automation
Example Azure Automation: https://gallery.technet.microsoft.com/scriptcenter/Azure-Automation-Your-SQL-30f8736b
Also relevant to multi-tenant application and pool of databases (tenant per DB) , you want a single automated job to run across all DBs to monitor the table size and truncate the data as needed.
Example on getting started with Elastic Jobs: https://gallery.technet.microsoft.com/scriptcenter/Automating-management-of-e7c15e2f