I've noticed that the 70-461 Exam guide contains quite a bit of the authors' opinions on the style issues of query writing that are not enforced by the database engine and not all code writers adhere too.
For example, the book may use an example like
SELECT s.St_Id AS 'Student ID', s.FIRST AS 'First Name', s.LAST AS 'Last Name', m.DESCRIPTION AS 'Major'
FROM STUDENT AS s
INNER JOIN MAJOR AS m ON s.M_ID = m.M_ID;
Where I might have written it like
select s.st_id 'Student ID', s.first 'First Name', s.last 'Last Name'
from student s inner join major m on m.m_ID = s.m_ID
There is the argument that some forms are more readable, but people who have been writing queries for years using a different style may disagree.
Is knowledge of the "preferred" styles of query writing needed on the exam? Or is it just being able to recognize what will and will not produce the desired output?