Pass Your Microsoft 70-462 Exam Easy!

98% still valid ,exam in Poland passed jan 2014

Passed today with 718! A lot of new questions, 15 or more. Some questions are wrong, pay attention!

Hi guys! which exam collection stream should i take ? this one, or the one in the Aug 14th post !!

topilno,
The correct answer is "Restore the full backup taken the previous night." Why? because the question states you restore from "23:30" at which time another full backup exists. If you restored the "Restore the most recent full backup" you would be restoring a copy of the corrupted database.

Q5 - I see no difference between "Restore the most recent full backup" and "Restore the full backup taken the previous night." It's 22:40, full backup at 23, the most recent is the one of the previous night..

Got 833, no new question, Still Valid ! Be carefull with the wrong answers in the dump :).

Valid
19 new questions and 4 re-worded but similar questions

Valid dump just passed with 887.
New Question was added about 20 items.
Good Luck.

Valid dump just passed with 933

passed with >800

Passed today with 950, 100 % valid in Canada.

Got 833, no new question. 10-15% errors in the dump

Thanks

Pretty sure q16 is wrong as it clearly states that in the file the first row contains data so you should not tick the box

q 8
correct answer:
B.
SELECT * FROM sys.dm_exec_sessions WHERE sessionid = 60

http://www.aiotestking.com/microsoft/2013/05/which-transact-sql-statement-should-you-use-40/

Passed Exam with 950. Still valid

Passed the exam with 900. A couple of new questions, but most are from this dump. Just different order or names. There was 1 new question about adding a node to an excisting cluster.

hello Modulus,
yes I mean Q83. sorry to confuse you.

@marian, do you mean Q83?
Q41 is "You need to identify which queries are taking longer than 1 second to run over an extended period of time. What should you do?".
But yes you only need to Create the condition NOT LIKE 'sp_%', and then create the police and enable it.

hello, in my opinion answer for Q41 is not really correct.
As per proposed answer, firs step is - Create Policy condition LIKE 'sp[_]%' and second step is - Create condition NOT LIKE 'sp[_]%'.
In my opinion is enough to enable only second policy condition.
Please advice.

Q56. on wednesday at 10:00 hours, development team requests to refresh the database on a development server by using the most recent version.

The provided answer is J.Transaction log but I think it should be L. Copy-only because it will give the most recent version without affecting the differential log base.

Thank you, Modulus. Only these 3 questions have wrong answers and the rest of the answers correct in this file?

@dany just change your file with the visual cert exam designer. I just used the comments and what I thought was correct. For example:
Q49:
Answer: Restore the latest full backup. Then, restore the latest differential backup.

Q46:
Answer: D

@83:
Answer: 1. Create Condition, 2. Create Policy, 3. Enable Policy

Need help guys. Please spend some time to update this exam with correct answers. or pls provide list in comments which questions has wrong answers n what is correct answer.Any help would be highly appreciated.

its a valid exam, passed 8.points. but has many wrong questions like those below.and the exam as about 8 new questions

Q46 answer should be H, because "The differential backup of the reporting database fails." So the database should to be restored with full backup only.

SB, about question Q8, i think that answer "EXEC sp_who 60" been correct, because don't exists sessionid in sys.dm_exec_sessions. In sys.dm_exec_sessions has session_id.

Passed with 900. not all answers are correct. Got 5 completely new questions. Some questions are the same as in the praticetest, but i got more answers to choose from and some answers in this test didn't appear in real. So take care

What do you thing for the question 54. witch would be the correct answer?
select UNICODE
FORMAT
and COLUMN NAMES.


or just
FORMAT
and COLUMN NAMES.

Q46, answer should be H, db is in simple mode and the question states that the differential backup fails. Only option is to restore the full backup

-meant question 49 of Rafaels
-I passed with 850, here are a couple more notes:

Q73 - SQL WITHOUT login was not an option. So this is wrong.
Q8 - There is a very similar, but slightly different question on the exam. sp_who 60 is not on the option list.

Q4 - I'd love to know what the correct answer is and why. Thanks in advance.

- I agree with Raphael on 42 and 85. However on 85 I think you should configure the DB to use bulk-Log before you execute the BCP, then return to Full.
-Q46 is wrong. There are no transactions if in SIMPLE mode. Answer shoudl be D
-question 86 is missing the question
- Q52 - I think the Alerts should be handled by sSystem Monitor - not SQL Profiler.
-83 is wrong. 1) First need to create Condition, 2) then Policy, then 3)enable it
- Q4 - This is badly worded or very tricky. What if the batch is wrong? How does having the snapshot help? maybe I'm not understanding the question.

Question Q49 on the exam A, too is wrong in the my opinion.

The correct is the: "Restore the latest full backup. Then, restore the latest differential backup."

The question Q85 on the exam A, is incorrect, because the database already in full recovery model don't being necessary change again to FULL.