>After a certain period of inactivity, SQL Server might reset its cache mode on specific tables, or all of them or no matter else would have been cached. Is there a setting somewhere that would tell us the actual value in regards to that?

I never heard about "cache mode on specific tables". What are you referring to?