Pass Your Microsoft 70-459 Exam Easy!

Still valid in Germany (passed 900/1000). Not all case studies were from this dump but questions had similar content.

Exam A / Q39 -> is wrong
C is correct

Fail today
Dump is not Valid
Please update with new Dump

Failed as got 665 in 70-465.
Marked them as I went and had a few that were 50/50 from here. Was surprised to have first ever fail :(

Dump Still Valid.

I Passed Yesterday with:
70-464 900
70-465 900

Bottom line: don't just remember the answers, but research each question to understand why the answer was derived so that you don't fail.

Thanks a lot to DBA-Alexa

All the questions came but the answers are not correct. South Africa

None of the answers are valid from that question. You need a trigger to achieve that.

Hi. The question concerning the view that has a clause "WHERE Column1 = 'City1' is wrong. That's not what the CHECK option is made for. Actually you will be able to updated ONLY the rows satisfied by that WHERE clause, that is, only the rows with the Column1 being 'City1'.

Dump Still Valid
I Passed Yesterday with
70-464 800 Marks
70-465 700
Some Questions arrangements are changed in real exam but 80% Q comes
from this dump
please prepare carefully and understand the answer not remember the answer
becuase in real exam Q slightly twisted

@hadi
New questions at all or changes "sirck" has described (the old question with changes) ??

failed, not valid in indonesia

Took the exam, all the questions are still valid with no new questions, however with a big twist.

A lot of the questions had a minor change that you need to pay attention to. Otherwise if you simply remember the answer, you will get it wrong.

example 1. a question that had the table column specifications of "english" would normally result in the answer being "varchar", but the question now changed to "international", so you need to know that the answer is "nvarchar".
example 2. "case sensitive, accent sensitive" would usually be "CS_AS", but now the question changed to "case insensitive, accent sensitive" so its "CI_AS".

So while to the untrained eye, the questions appear the same. They are only 99% the same, but the specifications may have changed slightly. So pay attention.

Bottom line: don't just remember the answers, but research each question to understand why the answer was derived so that you don't fail.

Also remember to study "Exam A" as well as the case studies.

Exam A
QUESTION 24
You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store the credit card numbers in the database. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
A. One-way encryption
B. Reversible encryption
C. Encrypting File System (EFS)
D. Transparent Data Encryption (TDE)

Answer given A (one-way encryption. Correct answer B Reversible encryption. For passwords you want a one way hash, but for CC data you have to be able to retrieve it later (think if the customer wanted a refund), so you need reversible encryption.

@dbo-jhon: Based from your exam, are all questions and answers are in the exam and is this dump accurate or with new questions?

Valid. Tks alexa and burgos

@DBA-Alexa:

The only difference between version and Burgos's version is that one question from Case Study A Datum, Question 4 has been changed to C.

Was this one change enough to help you pass? Because based on Burgo's version, you mentioned that you "score 933 in 70-464 and score 656 in 70-465."

guys, I guess question 9..
Identify which transaction causes a deadlock.
The answer is marked as sys.dm_exec_requests..
Isn't that the case of EXTENDED EVENTS?

Regards

Es valido. este examen es basado en el de @burgos, solo se corrigen 4 preguntas.

@DBA-Alexa:

Is this valid based on your passing the exam?