All pastes #2053613 Raw Edit

Something

public text v1 · immutable
#2053613 ·published 2011-05-03 21:18 UTC
rendered paste body
Question 12:
I chose b. ALTER TRACE because MSDN says this which pretty much aligns directly to the question being asked:

"When policies are evaluated on demand, they execute in the security context of the user. To write to the error log, the user must have ALTER TRACE permissions or be a member of the sysadmin fixed server role. Policies that are evaluated by a user that has less privileges will not write to the event log, and will not fire an alert." - http://technet.microsoft.com/en-us/library/bb510667.aspx

-------------------------------------------------------------------------

Questions 21-24:
I couldn't come up with a 100% sure answer for this so your guess is as good as mine.

-------------------------------------------------------------------------

Question 25:
Upon further research I agree, it should be c and d. Checksum does look more correct - http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/6d45e4a9-2c9b-451d-b7c2-1fa96c6cd03a

-------------------------------------------------------------------------

Question 29:
The answer is somewhere on this page but i'm not 100% sure which one it is: http://msdn.microsoft.com/en-us/library/ms181007.aspx

-------------------------------------------------------------------------

Question 51:
I agree, should be peer-peer

-------------------------------------------------------------------------

Question 54:
I saw a table yesterday that suggested to me that manual failover might cause less latency, but can't find that today and upon further research I agree with you. Answer should be D.

------------------------------------------------------------------------

Question 65:
a+c it is then, thanks wasnt sure about this one.