Based on my 2006 A3 with DSG, "S" mode changes gears up in around 4000 rpm under the normal acceleration. This, of course, depends on how you send gas to the motor, though.
But be careful. When you dash agressively from the standing position in "S" mode, you surely have to handle wheel spins thanks to the high torque generated by 2.0T FSI.
Have a safe driving...