What happens if I tell my target I'm part of the Dark Brotherhood?

Solution 1:

Generally, they'll attack you.

This can make the assassination quite a bit easier, since you are technically acting in "self defense", and you will not be given a bounty for killing the target. You will also not draw aggro from otherwise neutral NPCs in the area, like you would if they noticed you attacking the target in the first place.