December 11, 2007 at 6:52 am
Got this from Transcender (not a real exam) and thought I'd pass it along to those who haven't seen the exams before. These are the types of "trick questions" Microsoft likes to set people up with...
Case Study, partial exerpt:
...There are two database servers. The primary server is DB1, and the secondary server (mirror) is DB2...The OrderSys database should be available at all times...If the primary database server experiences failure, the SQL Server instance should automatically failover to the secondary database server. Synchronized database mirroring sessions will be used to increase availability and prevent loss of data to committed transactions. Due to the expense, there will be no witness server...
Now read that three times fast. @=)
Do you know what's wrong with the above scenario?
There are a lot of Real Life situations where what the client wants and what the client gets don't always match. Microsoft mirrors those situations by giving you seemingly implausible questions / case study setups. The key is to read the question carefully, make note of the inconsistences and then compare them to the available answers. If you reason out why certain answers won't work, you're usually left with the proper result.
But you do have to know your stuff. And if you have more than one answer left (or two answers that look identical), compare them word-by-word to see where the differences lie. Often this is the only way to discover the correct answer.
Anyway, just thought I'd pass that along. @=)
December 12, 2007 at 12:01 am
Brandie Tarvin (12/11/2007)
Do you know what's wrong with the above scenario?
Yeah, witness servers aren't exactly expensive. SQL Express and a desktop work just fine.
:hehe: 😉
Without a witness, mirroring won't automatically fail over. Thus, the lack of a witness server means that one of the requirements cannot be (or is trickier to) achieve
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply