On the connection between microscopic description and memory effects in open quantum system dynamics