Yes. It’s a pretty popular meme that when you find the beacon in game it is very loud. I was cutting this Jicama and inadvertently cut it in the shape of the beacon.
You don't have to play/complete the quest. If you play the game (Skyrim) and pick up the item (and you will find it fairly early) it triggers the very loud audio que.
Most of us older gamers have made more than one Skyrim run and this announcement is something that I've personally heard several hundred times.