I got the book answer right because I teach the classes but the FACT is that it is possible. The question was:
"Are we able to move Resource database in SQL Server 2008?"
And we ARE able. Period. Answer was wrong 🙂 The question should have been:
"SHOULD we move the Resource database?" if there is a reason NOT to.
I did it in my demo environment and everything is working great, including updates. Will it break? Probably, eventually.
Always remember, many we things we SHOULD not do are possible, like joining XP Home to a domain... interview question "Can you join XP Home to a domain?" and I said yes, you can... and I was right.
Did I have to change a registry setting? Sure I did and it worked! But you shouldn't...
It's all in the wording of the question 😀
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems