Do Not Disturb silences incoming calls and notifications only if your device is locked, by default. However, it’s possible to leave it unlocked and still use Do Not Disturb.
Open Settings, select Do Not Disturb, and scroll down to the Silence section. From here choose the Always option. Now your iPad will mute all sounds when Do Not Disturb is enabled even if your iPad is not locked first.