Download Microsoft.Certkey.70-450.v2011-04-13.by.Jorge.311q.vce

Exam: 70-450 - PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008
Size: 1.37 MB
# of downloads: 29
Free Download: This file is outdated. Browse other 70-450 VCE Files

Rating:

1 liked this dump 0 disliked
Click here to Like Dislike

VCE Simulator for Microsoft 70-450 VCE files
Comments

* The most recent comments are at the top.

Note:

Use VCE Exam Simulator only to play VCE files properly.


Richard

  • United Kingdom
  • Jan 16, 2012
  • Report Comment

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.


john

  • Brazil
  • Aug 24, 2011
  • Report Comment

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!!!


Levente Nagy

  • Hungary
  • Aug 22, 2011
  • Report Comment

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


ken

  • United States
  • Jul 28, 2011
  • Report Comment

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


Helper22

  • Saudi Arabia
  • May 27, 2011
  • Report Comment

@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?


Sule

  • Croatia
  • May 27, 2011
  • Report Comment

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..


Carlos

  • Brazil
  • May 27, 2011
  • Report Comment

@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.


Helper22

  • Saudi Arabia
  • May 27, 2011
  • Report Comment

@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.


Carlos

  • Brazil
  • May 26, 2011
  • Report Comment

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.


Helper22

  • Saudi Arabia
  • May 25, 2011
  • Report Comment

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.


Howard

  • United States
  • May 23, 2011
  • Report Comment

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


luckard

  • Hong Kong
  • May 22, 2011
  • Report Comment

Regarding Q 54

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

Answer is B.


mariusz

  • Poland
  • May 22, 2011
  • Report Comment

I think 66 is wrong. My opionon: 66 D

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


Mark

  • Egypt
  • May 14, 2011
  • Report Comment

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


Peter Weber

  • Germany
  • May 12, 2011
  • Report Comment

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)


Czar

  • United States
  • May 12, 2011
  • Report Comment

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

I managed to pass with 834.

Hope this helps.


p3tro3

  • Slovenia
  • May 12, 2011
  • Report Comment

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.


Peter Weber

  • Germany
  • May 12, 2011
  • Report Comment

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


p3tro3

  • Slovenia
  • May 12, 2011
  • Report Comment

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


p3tro3

  • Slovenia
  • May 12, 2011
  • Report Comment

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 :)


p3tro3

  • Slovenia
  • May 12, 2011
  • Report Comment

@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.


peter

  • United States
  • May 12, 2011
  • Report Comment

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


Rithika

  • Norway
  • May 12, 2011
  • Report Comment

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???


john

  • Brazil
  • May 11, 2011
  • Report Comment

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.


Sunny

  • Canada
  • May 11, 2011
  • Report Comment

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


Bruno

  • Brazil
  • May 10, 2011
  • Report Comment

MrE's issues are enough to pass the exam?


Bruno

  • Brazil
  • May 10, 2011
  • Report Comment

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


john

  • Brazil
  • May 09, 2011
  • Report Comment

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


peter

  • United States
  • May 09, 2011
  • Report Comment

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


Kel

  • Hong Kong
  • May 09, 2011
  • Report Comment

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"


Mo

  • Hong Kong
  • May 08, 2011
  • Report Comment

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..


Czar

  • United States
  • May 07, 2011
  • Report Comment

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!)


Maple

  • United States
  • May 07, 2011
  • Report Comment

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.


Mark

  • Egypt
  • May 07, 2011
  • Report Comment

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.


Maple

  • United States
  • May 06, 2011
  • Report Comment

John,

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

Renching


john

  • Brazil
  • May 06, 2011
  • Report Comment

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.


Maple

  • United States
  • May 06, 2011
  • Report Comment

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.


john

  • Brazil
  • May 06, 2011
  • Report Comment

TOMO,

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


tomo

  • Japan
  • May 06, 2011
  • Report Comment

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.


Erwin

  • Germany
  • May 06, 2011
  • Report Comment

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


Erwin

  • Germany
  • May 06, 2011
  • Report Comment

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! :)


Maple

  • United States
  • May 05, 2011
  • Report Comment

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

Thanks.


john

  • Brazil
  • May 05, 2011
  • Report Comment

Somebody find new answers to the 21 new questions?


John

  • Brazil
  • May 04, 2011
  • Report Comment

lunatic:
50 q


lunatic

  • Brazil
  • May 04, 2011
  • Report Comment

Now the exam have 50q or 69q


Hank

  • New Zealand
  • May 04, 2011
  • Report Comment

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


Soner

  • Netherlands
  • May 04, 2011
  • Report Comment

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


Just took it

  • United States
  • May 04, 2011
  • Report Comment

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


Hank

  • New Zealand
  • May 03, 2011
  • Report Comment

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.


andreas

  • United Kingdom
  • May 03, 2011
  • Report Comment

enclosed my comments / questions:

http://pastebin.ca/2053637


Shahnaz

  • Canada
  • May 03, 2011
  • Report Comment

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/


lunatic

  • Brazil
  • May 03, 2011
  • Report Comment

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


Hank

  • New Zealand
  • May 03, 2011
  • Report Comment

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.


Hank

  • New Zealand
  • May 02, 2011
  • Report Comment

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.


John

  • Brazil
  • May 01, 2011
  • Report Comment

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


John

  • Brazil
  • May 01, 2011
  • Report Comment

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


Emir Alizadeh

  • Iran
  • Apr 30, 2011
  • Report Comment

50 Question


Dodi

  • Russian Federation
  • Apr 30, 2011
  • Report Comment

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


Emir Alizadeh

  • Iran
  • Apr 30, 2011
  • Report Comment

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


Dodi

  • Russian Federation
  • Apr 29, 2011
  • Report Comment

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.


john chen

  • United States
  • Apr 22, 2011
  • Report Comment

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.

Report Comment

Verify:

Add Comment

Name: *
E-mail: *

This e-mail will not be published.

Comment: *

Comment will be moderated and published within 1-4 hours.

Rate file: * Like!     Dislike
Verification: * Secure Code
Type the characters from the picture.  
VCE Exam Simulator Free DemoVCE Exam Simulator Free Demo
Read about VCE Exam Simulator
Download VCE Exam Simulator
Prep4sure - Professional IT Certification Training
BrainDumps - Get Real Exam Questions
Actual Tests - Lifetime Access to IT Exams

Site Search:

Close
Only Registered Members Can Download VCE Files

Please fill out your email address below in order to Download VCE files or view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.

  • Trusted By 1.2M IT Certification Candidates Every Month
  • VCE Files Simulate Real exam environment
  • Instant download After Registration.
Please provide a correct E-mail address
Email Address:

A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Close
Log into your ExamCollection Account

Please Log In to download VCE file or view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

E-mail:
*  
Password:
* Forgot password?
 

Only registered Examcollection.com members can download vce files or view training courses.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Close
DO YOU HAVE A VCE PLAYER?
Play VCE files with Avanset VCE Simulator

Your file is being downloaded.

All tests on this site have been created with VCE Exam Simulator.

VCE Exam Simulator is interactive testing engine developed for certification exam preparation.

Files with VCE extension can be opened with this program.

Before you can open any file on this site you will need to download VCE Exam Simulator

Download VCE Player
I already have it
Close
Like this VCE file?

Log in to make your opinion count.

E-mail:
*  
Password:
* Forgot password?
 

Only registered Examcollection.com members can rate files.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Close

Close
Download Free Demo of VCE
Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.


Simply submit your e-mail address below to get started with our interactive software demo of your free trial.


Enter Your Email Address

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.