Let $\mathcal{C}$, $\mathcal{D}$ be two small categories. Let $f\: : \: \mathcal{C}\to \mathcal{D}$ be a functor. Then it induces a functor $$ f^{*}\: : \: sPsh(\mathcal{D})\to sPsh(\mathcal{C}) $$ via $f^{*}(X)=X\circ f$. Now consider $sPsh(\mathcal{D}), sPsh(\mathcal{C})$ equipped with the projective model structure. Then $f^{*}$ is a right Quillen functor and its left adjoint is given by the left kan extension $$ f_{!}\: : \: sPsh(\mathcal{C}) \to sPsh(\mathcal{D}). $$ Assume that $X$ is a cofibrant replacement of the final functor $*\in sPsh(\mathcal{C})$. Then $f_{!}(X)$ is again cofibrant.
Q: When is $f_{!}(X)$ again a cofibrant replacement of $*$?