I answered "Displays information about Memory Allocated by SQL Server". How can that that be wrong?

These are all TRUE statements...

1. The buffer is memory.
2. The buffer is allocated by SQL Server.
3. The DBCC MEMORYSTATUS...

She HILLS R 58008

I love 3rd grade humor!

The true key would be the easter egg in the question and the answers. Use a calculator and enter these parts to the question...

57714 345

then turn the calculator upside down...

Do the...

Since the correct answer of 512GB on 64-Bit was not an option, I selected the next obvious one.

And Scott, your post is for the minimum requirements of Analysis Services.

@(#$&, I read the question wrong. Thought it said CREATE TABLE...

I agree "none of the above" would've been better. However, the way I get the Listening IP Addresses and Ports is with...

    1. xp_readerrorlog

    2. or by reading the error...

I agree with Tony. If you can afford RAID 0+1, then that would be the correct answer. I would prefer RAID 0+1 for the entire implementation, data and log.

I know it was a trick question. How about a trick answer. I think you might still be able to cluster the "Standard" Edition as a "Generic Service".

So I would...

I thought I answered correctly. The Windows "Application Event Log". There are "Application", "System" and "Security" Event logs. So I picked "Application" the correct answer.

I agree WTF is Windows Application...

I prefer the Trace Flag option myself. In my opinion the Trace Flag should always be on anyways, especially after a new upgrade. I agree that it is unlikely to...

I agree with SJT, Microsoft's website states the same "SQL Server Personal Edition" can only be upgraded to "SQL Server 2000 Standard Edition". The same article states the correct answer...

From the same article "The extra layer of translation is what provides access to physical memory beyond 4 GB."

I agree you can use /PAE with 4GB, however I don't see...