Interest Thing you’re proposing: Not to use the database at all, just cache. But how? I encourage you to write an article about that.
Alberto De Rossi
Microsoft Certified Solutions Associate - SQL Server
Microsoft MVP - Data Platform
Power BI User Group Lima - Community Leader