Assets outside the resources folder are loaded in to memory when the game start?

Questions & Answers
1

or they are loaded dynamically when the game logic really need it?

2

They are loaded when they are referenced by a scene or a prefab being instantiated.