Senior MVC Distributed caching → Shared cache like Redis or SQL Server.? Review the concept and prepare a concise verbal explanation with a real project example.