Exactly. D Major chord is a V/V in C Major, which has only a couple of common uses in popular music according to the Hooktheory database. V/V -> V7 -> I is one common one. Another is a substitution for ii, like: I -> V/V -> IV -> V, see John mayer, Kelly Clarkson, Kenny Chesney etc.