Here is a link to the new '07-'08 Sentra SE-R cat-back exhaust from BRM. There are sound clips as well.
zerothread/281103
Keep in mind, the SE-R Spec-V used for the sound clips uses a slightly different QR25DE motor compared to the Rogue. The Spec-V has different cylinder heads, a redesigned header, and a higher redline. It will sound different as compared to the 'normal' QR25DEmotors.
As you can see, BRM still uses a resonator in their setup. Without it, you would be getting alot more high frequency noise and droning on the highway. Some have gone so far as to install the biggest resonator they can fit under the car... just to reduce the noise.
And before you ask....
Although the Rogue is based on the Sentra chassis, the BRM exhaust WILL NOT bolt onto a Rogue. There are no aftermarket performance exhaust systems for the Rogue. You would have to custom fabricate one.