Microsoft documentation suggest that both derived tables and temporary table

will first use memory cache if available.

It then will use the temp database as needed in both cases depending on available...