In a normal scenario it should be considered as the default behaviour for the question which is CI (and not CS).
I disagree, and I'll tell you why.
In questions where collation is not a factor, using the consistent case throughout the question prevents ambiguity. If you ensure the question works okay onm a CS collation, it will also be okay on a CI collation. The reverse is not true. So writing the question for a CS collation is the best way to ensure that everyone has a fair chacne - including those who are aware that not all SQL Server instances in the world are installed on a CI collation.
And in questions where collation is
a factor, the collation should always be included in the question, so there can never be a problem there.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis