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

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

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