Pass Your Microsoft 70-450 Exam Easy!

High-performance mode question:
The question is talking about configuring, not what you would do in the case of a Failover.

So, you need to configure a solution that has lowest latency.
That means it can't be "D" (Auto Failover), as that requires Synchronous mode, and that has highest latency, as Commit must happen on Mirror before Commit happens on Primary.

Can't be "A" (Pause), as that would mean no High Availability.

Can't be "B" (Manual Failover), as Manual Failover relies on Synchronous mode, even for short while.

That leaves C (Forced).
The App is designed to retry transactions if failover happens.
So forcing, though it may lose committed transactions, is the answer, as the App logic will detect that transactions are not committed, and retry them on the new Primary.

Question 41.
Let's turn the discussion about the correct answer. I saw several people saying that the correct answer is A, others say it is C. I did the second test and got 650pt and failed.
We need everyone to research the correct answer to the questions!!!

High-performance mode, supports only one form of role switching: forced service (with possible data loss), which uses the mirror server as a warm standby server. Forced service is one of the possible responses to the failure of the principal server.
Considering all th articles, this is the only possible good solution, I think.
http://technet.microsoft.com/en-us/library/ms187110.aspx

anyone have a definitive answer for the manual failover vs forced service role switching? From what I read I figure its forced service role switching, but sometimes the right answer in the real world isnt the right answer on these tests

@Sule - I am not sure about your idea so we might as well get help from the others. High-Safety and High-Performance modes can both commit transactions. In the article it says:

"High-Safety Mode supports synchronous operation"
"As soon as the databases are synchronized, a transaction is committed on both partners, at the COST OF INCREASED transaction LATENCY."
"Manual and Automatic Failover Role Switching requires High-Safety Mode"


"High-Performance Mode runs asynchronously."
"In high-performance mode, as soon as the principal server sends a log record to the mirror server, the principal server sends a confirmation to the client. It does not wait for an acknowledgement from the mirror server. This means that "TRANSACTIONS COMMIT" without waiting for the mirror server to write the log to disk. Such asynchronous operation enables the principal server to run with minimum transaction latency, at the potential risk of some data loss."
"Forced Service Role Switching runs under high-performance mode and high-safety mode without automatic failover"

What do you guys think?

And what about this part of question: "for committed
transactions." I'm not sure that High-Performance Mode (Configure forced service role switching) support this.. I don't understand question very well..

@Helper22. You explanation is exactly what I also understand from the article. Another idea I thought is related to the part "The current application includes programming logic that will retry transactions if a failover occurs." which indicates that if the "Forced service" occurs and a possible data loss takes place, the application will retry de transactions and there will be no data loss in fact. What do you think? I hope others DBA's join us in this discussion.

@Carlos - Well I am not an expert in SQL Server but what I simply think is that, There are 2 mirroring Operating Modes, one is the High-Safety Mode and the other one is High-Performance Mode. There is an increased transaction latency involved in High-Safety Mode. Automatic and Manual Failover Role Switching requires High-Safety Mode but "FORCED SERVICE" runs under High-Performance Mode wherein asynchronous operation enables the principal server to run with minimum transaction latency. These are the ideas I gathered from that article and according to the problem, this might be the solution. If I will be wrong I stand corrected sorry.

Hi helper22, why do you think the correct answer is "Configure forced service role switching."? I've read the pages you indicated and I think you might be right, but I wanna understand better what you think.

Guys: regarding the question below from Emir's 21 questions in the pdf, I think the answer should be

"Configure forced service role switching." The two popular answers that have been debated were "Configure

manual failover role switching." and "Configure automatic failover role switching". I may be wrong but
you can refer to this link "http://msdn.microsoft.com/en-us/library/ms189852.aspx" and read "Operating
Modes" plus "Role Switching".


You administer a SQL Server 2008 instance.
You plan to design a high-availability solution by using database mirroring.
The current application includes programming logic that will retry transactions if a failover occurs.
You need to configure a strategy that will provide the minimum amount of latency for committed
transactions. What should you do?

A. Pause database mirroring.
B. Configure manual failover role switching.
C. Configure forced service role switching.
D. Configure automatic failover role switching.

Q40 the answer should be C - Enable nested Triggers - "If the nested triggers server configuration option is disabled, On change: prevent will not work correctly. Policy-Based Management relies on DDL triggers to detect and roll back DDL operations that do not comply with policies that use this evaluation mode. Removing the Policy-Based Management DDL triggers or disabling nest triggers, will cause this evaluation mode to fail or perform unexpectedly." - http://technet.microsoft.com/en-us/library/bb510667.aspx

Regarding Q 54

http://msdn.microsoft.com/en-us/library/ms187465.aspx

Answer is B.

I think 66 is wrong. My opionon: 66 D

http://msdn.microsoft.com/en-us/library/ms190984.aspx

Hello Peter,
I'm sorry but you're not rught about question (38).
SQL Server 2008 supports Kerberos authentication on the following protocols:
TCP/IP
Named pipes
Shared memory
You can check this from the following link:
http://msdn.microsoft.com/en-us/library/cc280744.aspx

Regarding John's suggestions to the 21 new questions:
I agree on 4, 16, 21, 28, 29, 35, 42, 51, 54, 64, 65
I think 38, 40 + 41 are wrong. My opionon: 38A, 40D, 41C
(38B can't be right since Kerberos can only be used with TCP/IP for example)

I found Hank's answers to be correct (for the most part.)

I managed to pass with 834.

Hope this helps.

Check a couple of posts below, John has provided the latest answers, although there are still some incorect ones but noone still knows, which exactly.

Where can I find the answers to the 21 new questions?

Regarding question 64, I have a doubt that C is the correct answer. Based on the link posted below, I would say that B is more correct. The only problem with the answer B is that it says server master key instead of service master key. Any thoughts on this?

here is the link to the document: http://www.sqlservercentral.com/blogs/steve_jones/archive/2009/05/12/sql-server-encryption-the-service-master-key.aspx

Sorry I meant to say: Even checking Books online doesn't help me, I am still not sure which of those answers are right or wrong.. but you got the point anyway, I am sure :)

@Peter: Do you happen to know, which are not correct? We are all checking those new questions and noone seems to know, which of the answers are wrong. Even checking Books online doesn't help me, I am still not sure what if some of those answers are right or wrong.

tested now not all John's answers are corect carefully check answer b4 testing

When compared to the answers of John and Haywire ,they are different from each other .Can you suggest me which answers to follow.Did any one take the exam after reading the Haywire???

Bruno,
Dê uma olhada nas minhas respostas abaixo. Não garanto todas, mas pelo que estamos discutindo ha alguns dias, a maioria aqui está utilizando estas respostas para fazer o exame.

Hi
Passed the exam, 50 questions, and MrE, and new 21 question from Emir.
I used answered by John, passed ( 800).
Good luck everyone.

MrE's issues are enough to pass the exam?

I downloaded the pdf, but dont have the answers of this 21 new questions. Someone have this?

hello everybody!
back to discussion on new issues, here are my answers. I wish people who have taken the test, inform if these answers are correct or not.

4.A
12.B
16. B,D
21.A
24.C
25.C,D
26. A
28.C
29.B
35.D
38.B
40.C
41.A
42.B
43.A
47.D
51.C
54.D
64.C
65. A,C
66. C

I have the MrE Questions but can't find Emir with 21 questions, Czar, Mo, John can u kindly send it to my mail "flynet.tech@gmail.com" i'll appreciate

Studied MR2 and the "New questions". Pretty much valid w/ like 3 new questions. Passed 746/1000. So you really have to get the MR2 answers right if you are uncertain about "New questions"

Just take the exam today with dumps from MrE together with extra questions from Emir w/ answers from Hank & Andreas.

Questions are all from them, but answers.. Could just give me a bare pass only..

I've passed today; MrE + the 21 questions Emir had provided is all you need (I came across 50 q's,)

Thank you all for the discussions, insight and guidance (thank you Emir, Hank, and Andreas!)

Thanks everyone. Just passed today. 50 questions/120 mins. MrE and new questions covers the most. There are about 3-4 new questions. Thanks John and good luck to everyone.

Guys,
The new questions are available here:
http://www.4shared.com/document/vpmqJoaG/70-450_New_Question.html
I have uploaded them as they have been removed from Rapidshare.
Please tell me the correct answers if you have them.

John,

Do you the 21 new questions? I cannot download them. If you have it, could you email me? Thanks.

Renching

maple,

I'm talking to a friend MVP, and he will give me your opinion about the answers. then I put his answers here. Use the answers already discussed here and if you're approved, you place your feedback here. Thanks.

I am going to take the test tomorrow. Could someone send me the new questions? My email address is maple_9876@yahoo.com. Thanks a lot.

TOMO,

Congratulations!
But, do you remember of your answers by the new questions?
Please, help us?

It was only 46 questions.
passed today.
scored 1000/1000.
It was all from Mr2.
Probably I was lucky.
Thank you very much everyone and good luck.

Sorry. Thank you very much to Emir, Hank and Andreas!!!

I passed today with 769. So 12 questions were wrong answered. I used MrE , the questions from Emir and the answers from Hank and Andreas. In doubt the one of Andreas. All 50 questions were from this two collections.
So start quick to get the certificate! :)

I cannot download Emir's new questions. Rapidshare said it is expired. Do you have a copy of the new questions?

Thanks.

Somebody find new answers to the 21 new questions?

lunatic:
50 q

Now the exam have 50q or 69q

Just took it from United States - Could you please enlighten us as to which questions are wrong, and if you know the right answer please tell us.

Thanks

Also took the exam today passed with 746. 50 questions, 17 are from Emir and others from MrE.

Just took the exam. All 50 questions are from the MrE and this latest 21 questions from Emir. That makes it easier to study as you only need to learn 70 questions. However, the answers that Hank and Andreas took the time to post are at least half wrong, at least. Until a definitive answer list comes out, use their answer sheets as a starting point. I passed with a 700. Research the answers yourself and you will easily pass with a 1000

Excellent discussion, i now feel confident to pass the exam thanks a lot andreas. i still think the answer for question 12 is alter trace though lol, but we'll see when i do my exam soon.

enclosed my comments / questions:

http://pastebin.ca/2053637

question 64: B(backup server master key) should be the answer
http://sql-articles.com/blogs/how-to-copy-move-a-database-that-is-encrypted-with-tde/

Q66
A: c - Perform a partial restoreof the PRIMARY filegroup and FileGroupA from a partial backup. Perform an online recovery of FileGroupB, and then perform an online restore of FileGroupC

Here are my opinion on the answers of the questions from Emir http://pastebin.ca/2053333

Please tell me what you guys think or if any of them are wrong.

Emir, do you have the answers for those questions? I have found some of the answers by researching but it would be easier if someone just posted them as I am unsure.

EMIR, can you post the answers of the new 21 questions???
Thanks

Can someone post the answers to these 21 new questions? so we can discuss better?

50 Question

Emir Alizadeh
Same questions as I saw on exam!!!
Good!

https://rapidshare.com/files/459882965/70-450_New_Question.pdf

Ok. Passed today - 746. Really deadline result.
About 30-35 questions from Jorge, MrE, Debel and G-Force.
Other 15q was new.
But this 35 questions/answers not word-to-word as in dumps, also answers was replace.

There are many long new questions. I passed with 732.
This dump has some questions but Mr2 is still the best.
Bottom line is that do not just memorize the dump and go to the exam. It will be too risky.