Pass Your Microsoft 70-461 Exam Easy!

Possible new exam status

@aankit, how did you write ill be writing soon

This exam is not valid in the US, took exam and failed. dont depend solely on this dumps, until a new dump is available. around 30% came from this but a whole lot off new fill in the blanks sort of quering questions.

For God Sake, someone provide a recent dump or give us some guidance. Is the premium dump from exam collection valid at the current situation?

I am taking this exam on this week. Please guide me which dumps are valid.

Please upload more recent dumps as all the comments indicate that the dumps that are currently available are no longer valid.

I am taking this exam on August 4th. Please guide me which dumps are valid.

This Exam is invalid.....Anyone with a new file for this exam please share!!!!

This dump is not valid , do not take this exam

Is there any opportunity to get an updated dump for this exam through this website?

Guys just to let you known there is free retake microsoft exam in place from 12 of july to january 2016. if you fail first attempt you can resit for free within 30 days. check this web address
https://www.microsoft.com/learning/en-us/second-shot.aspx

I took this examn today and I failed.

50 questions came exactly as the Jenson's and Nancy's examns.
but the answers are wrong.
I had 25 wrong answer of these dumps. DON'T USE THESE 2 DUMPS. DON'T TAKE THIS EXAMN UNTIL A NEW DUMP COMES UP.
or Wait for the SQL 2014 dump.

This dump isn't valid. If you don't know SQL cold, (meaning you've actually studied a lot or are a DNA) you will not pass with any dump currently on this site. Questions on exam are twisted, new and just similar enough to be deceptive. I prepared extensively, memorized the top five (including Jenson & Nancy) and I also work with TSQL on a daily basis. I failed. I advise either learning SQL or waiting to take this exam until a new dump comes out.

Any news on a possible update for this dump?

Can anyone please confirm is these dumps are valid or provide some other link for valid dumps, I am planning to appear for exam soon?

Took exam july. 2nd. Failed this is not valid do not use.

Wrote test 3 July. Did not pass. Dump not valid anymore it should really be looked at and updated.

Dumps 35
Twisted Dumps 7
Out of Dumps 15
Total Qustions 57
scored only 628

Dumps 35
Twisted Dumps 7
Out of Dumps 15
Total Questions 57 - hours
Scored 628 only not passed

this dump and also jenson is not valid anymore,many new ques in exam. Anyone please upload the valid dump. Thanks.

it is not still valid. The examn have new question

Also got 57 questions in 2hrs. Didn't pass. There were too many query writing questions. Dump not valid

Sweet staff!!!

Hello All,

Unfortunately I failed yesterday with 646..may be by couple of questions ...i had 57 questions in 2 hours ...whole lot of new questons as described by Mystique earlier.. i would say 30% to 40% questions are based on this dump... few exact questions and few of them twisted... few new questions on drag and drop like fill in the blank type... i would say if you prepare thoroughly nancy and jenson dumps then u can secure 50% of the questions but rest are new ones....

Hi Abi, how was your exam?

Is it still valid? Please let me know which is valid file. Planning to write soon.

Is this still valid? i have exam tomorrow. Can someone post the latest dump or atleast link? i have done this and jenson one.thanks in advance...

Not valid any more. Did exam on the 13th.

around 8 questions from this dump.

Exam was nothing like dump. So many query writing questions, about 40% from dump.

@Hotsy
Use the one by Jenson. it has around 85% questions from the exam. know all xml, how to declare xml, cursors, airline question (know all), how to create tables using persisted etc etc.

is still valid?

is still valid?

Don't relay on this dump. There is less than 20% questions from this dump. Just did my exam today
-57 questions
-12 query writing
-4 multiple answers multiple choice
-4 ranks
-4 XML
-5 drag and drops of which only the Merge drag and drop is from this dump. Drag and Drop had fill in the blank as well which neither CBT Nuggets cover nor is in this dump
-3 questions on cursers

Passed today, a whole lot of new questions. Work on cursors guys... At least 3-4 questions about cursors... But around 50-60% questions from this dump. Tnx!!!

Good morning ladies and gentlemen please guys is the any person with a VCE application to open this dummy please assist me and send me on slowthemba4@gmail.com and have a great day.

Valid. Just pass the exam in HK by 935/1000.
There is a new question asking you to retrieve the 41st - 60th rows from a record set (should use offset and fetch clause?)

Study well and understand the questions and answer then you should be able to pass. Good luck!

Valid Dump.
All the questions were from this dump.
I also got : 42 Questions | 2 hours

Passed with 900+ score.

Still valid in India

Valid Dump.
All the questions were from this 98 questions dump.
New format : 42 Questions | 2 hours
2-3 Ques- Write Query
2-3 Ques- Drag Drop
1-2 Ques - Multiple Answers
Rest all were single choice correct.

Passed with good score.

I just wrote this test and passed with 900+
42 questions.
This dump is still valid in South Africa, Although there were 6 new questions. Good luck guys

Passed today with 914. Dump still valid in UAE, Thanks

Still valid in Hungary! Passed today with 7xx points, so it contained a few new questions too.

Passed today with 871. Dump still valid in Serbia.
Some questions were from JENSON so study it as well.
GOD BLESS Nancy! Thanks a lot!!!

I just wrote this test and passed with 871.
42 questions.
I would say that all of the multiple choice questions were from here with some minor wording alterations.

Some new mix questions and the coding questions were the same minus a couple adjustments.

Overall still very valid!

Valid in US, I studied through CBT Nuggets + Nancy and passed last week with 747.
New questions:
- the already mentioned smallest field to store date (date)
- 2 new drag and drop that are not on Nancy (a function with TRY / CATCH one, and a SELECT). SELECT very easy, function more or less
- know ALL XML questions - I got 4!
- know ALL RANK questions - I got 3!

XML Tip:
- output starts with 'row' - XML RAW
- output has "" - XML AUTO
- output dont have "" - XML AUTO, ELEMENTS
- output mixed of with and without "" - XML PATH
Then you will have only 2 options, just check the columns order.

I got 9 drag and drop, so, study them as well.
Good luck and thanks to whoever got Nancy all together, very useful! THANKS!!!

Please if someone can mention the new questions come in the exam

Hi I am Amos from south Africa can u please have me out with the vce for opening the questions please

Still valid, got 780 points. CCA 6 questions that had to be written.
4-5 new questions

I just did my 70-461 exam on 10/May/2015 and passed with 890 points. I have little experience working in SQL server, I just did a short term course of SQL server and studied the whole MS book for 2 weeks and practiced PassLeader 70-461 vce dumps. So I just want to inspire guys who like me are new to SQL server, you can do it! By the way, there were about 10 questions that actually need to type the code, but I think they are not too difficult.

Still valid - passed NZ 805
Also used Jensen

Still Valid in Egypt ,Passed exam yesterday (11/5/2015) The dump is enough to pass

The code in question 42 is not working. One of the solutions is
with CTEE as
(
select C.LastName,O.OrderDate, RANK() OVER(Partition by C.CustomerID order by OrderDate desc) as rowNum
from Customers as C inner join Orders as O
ON C.CustomerID = O.CustomerID
)
select LastName,OrderDate as MostRecentOrderDate from CTEE
where rowNum = 1
order by OrderDate desc;

Question 45 has an error. In the code you should write RANK() OVER(Order by ...) that is omit the Partition by ProductCatalog.UnitPrice part.
Tried it and it works.

Juanpe, how many new questions were there?
I am planning on taking this exam with this dump. Will this be enough? I have also read the Microsoft Trainig kit for this exam, and have some experience with SQL.
Anyone? Please.

Still valid.
Passed yesterday with 892.
+/- 6 new questions though and some questions are tweaked which results in having to choose a different answer
1 of the new questions is: how to store datetime in the smallest possible way. Answer: DATE type

if there's new questions pls Mention it or at least hint about it.

Passed today with 892
Winder/Nancy are both valid, but 5/6 new questions. Winder has less mistakes in the answers, like ORDER BY MostRecentOrderDate or ORDER BY MAX(O.OrderDate) instead of the incorrect ORDER BY O.OrderDate...

One of the new questions: You need to store historical date information in the smallest storage size possible. What should you do (Use DATE/CAST/FORMAT/VARBINARY/DATETIME/appropriate collation etc) I chose DATE

One new drag and drop question with the HAVING clause.

Other questions were tweaked, like asking for the students with the lowest average number instead of the highest.

Good luck!

pass today with 700, new questions!!!

Passed today in Australia. At least 10 new questions. Some of the answers may be incorrect as I got 8**.

Very helpful dump - definitely helps for sure...

Passed 20th April...although couple of question are outside of dump but I would say if you prepare it, you definitely got the 80-90%

I passed the exam today in Germany successfully with about 90%, there were 6-7 new or modified questions (travel application)

2/3 new questions, 5 code writing and 3 drag n drops. But may be some of the answers are wrong as I got 8** and followed answers what's written
in the file.
But very helpful dump!!!Thanks

The Dump is absolutely Perfect. Valid in Bulgaria, April 2015. It helped me very much!

Passed today, dump still valid in Brasil.

Learned 70-461 136q vce and CLEARED exam yesterday with 9XX scores, about 7 new questions, total 3 D&D questions including one new!

Passed today in India. 4- 5 new questions, but this dump is enough to get passed.

Dump still valid in bangladesh. 6/7 new questions but managed to pass with this dump

Passed today.This dump is still valid in US. 5-7 New questions and new 1 drag & drop question

is the dump still valid? i haven't used the file yet..how can i like the file?

Valid in Portugal, but if you study you will be able to pass without problems.

nb.: A couple of new questions, so study...

Scored 914 today in India! Almost all the questions are from this VCE. I saw around two to three different questions here and there but if we are thorough with this VCE we can pass easily. God bless Nancy!

DUMP Still Valid ! I Passed yesterday!!! Thank YOU!!!

Just pay attention in exam because the order of answers is different.

is it valid in india

Still valid in India although there are some new questions. 1 drag and drop is converted into MCQ , read questions carefully before answering. If you study Nancy you will pass for sure.

Still valid in Maine. 3 Drag and drops (1 new), 4 write TSQL questions, and 3 new additional questions.

Passed in the JAM yesterday.
43 questions - 850/1000. Just a few new questions. exam date March 06, 2015

Passed EXAM today.. some new question but Practice Nancy is more than enough.

valid as of march 2015

Passed in the UK yesterday.
44 questions - 850/1000

2 new drag and drops.
Reordering of answer set in questions.
Switching of ASC/DESC/greater than/less than in question - make sure you READ it.

Write in SQL bits not changed and they give you the bulk of the query to add to, a syntax checker and a keyword list.

Is this dumps still valid in India?

Can someone please share the latest dumps with me?

This dump still valid, i pass with 721, 27 feb. 5 or 6 new questions.

Do anyone know how is the 70-461 second shot questions? I am failed in the first attempt and going for the second one. Please let me know if anyone know regarding the question paper. Is it the same or similar or entirely different.

Still valid in US. Passed with 89 using Nancy, Martha, and Roy dumps.

About 85% of material was on dumps. Be prepared to write a few lines to complete queries and do some drag and drop. Also be aware of questions that change keywords like "less than" which are changed from the brain dump.

Is it valid in Australia ? Please reply

Valid in US. Passed 890. Use Nancy100. 10% new questions.

Is this dump valid in 2015 in myanmar?
pls, reply.
Thanks for all.

Still valid.But some questions are different than any vce. Passed with 850/1000 today.I used nancy,martha dumps.

Can someone provide me a pdf version of it. When I run the exam it says "Stream error" something like this. Cheers.

Wrote on the 20th of October, passed, dump is valid and enough to pass but know what your doing. From South Africa.

Plaase I'd like to know how long is the exam and how many questions you faced. Thank you.

is it valid in india

Please I'd like to know if this dump is still valid and if in Italy or elsewhere there are typing questions. Thank you.

100% valid in india, passed with 914 score

Is this still valid for Nepal ?

Please can anyone help with the 10 typing questions? Is this exam valid or are the typing questions also required

Valid on UK. 962. All the questions from this dump

Dump is valid
Passed from India 925
There are 10 out of 54 Typing Questions
I had ignored them as I had seen people say that they dint get them :P

Today is my Exam guys.

Wish me luck.. :)

100% sure. Took exam on July 4th, 2014.
From India.

You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations. Which type of user should you create?
A.User mapped to a certificate
B.SQL user without login
C.Domain user
D.SQL user with login

is asked twice with different answers,
please mention which is the correct answer

Still valid. 925

Is still valid exam in pakistan???

Is this still valid exam in pakistan ???

This dump still valid in Brazil. I passed today (05/24/2014).

This dump still good! Passed today.

Guys, what are you using to Mix Questions study? Need to study the two?

Dumps are valid ! passed today with 962. all the best !

Still valid. Thx.

Valid alongside Winders scored 943 today (14/04/2014)! Cheers!

Passed today with 868 marks in Sydney Australia. This dump is 100% valid. No typing questions.

OMG ... just passed the exam today with score 8xx . this dump is still valid in Egypt

This dump is valid all the questions from this dump , no typing questions, study the xml section (5q)and one with finding the right column on employee table (5q) to make you confused.valid one 100%. also studied winder dump.

Dump is valid in Pakistan, 3 April, 2014

Is it valid in India? Kindly help

Valid in the UK. Passed with 925 on 03/03

Dumps still valid, got 800 yesterday :)

hey, is these dump still Valid in United States Planning to give next week ?

Any one has valid dumps for 70-462

85% valid in Sri Lanka. Passed with 9**. Thanks for the dump. :)

Cleared on 22/02/2014. 100% valid dump. Scored 9xx.

Hi,

I am planning to take this exam in March. The dump is still valid?

Please give me any other link.

Regards
Shah

thnx alot nanoooos .. still 95% valid
pass 925 from egypt

still valid 100% in portsaid, Egypt ^_^

it's still validddddddddddddddd
but with 6 new questions

still valid @ Egypt (962) & 1 new question

still valid in Egypt score 943 .....about 4 question different ......thank you NANCY :D

Valid 100% in Brazil, passed in 02/14/2014 with score 9xx.

still valid @ South Africa. Got 943

Passed with 887 (11.02.2014).. This dump valid..

Thanks Nancy..

Is this dump still valid in Nepal ???

Dump is still very valid in South Africa, 943 and only 1 questions shuffled.

Is it still valid in Canada. Please confirm

This dump still valid in india. all the questions only from this dump. except three new questions.options may shuffled.passed 900+ today

Dumps still valid in india.got 906......

yes..still valid in Egypt..passed with 831...no code writing,but drag and drop is there.

Passed it today in Maryland, 900+. This stuff is on point.

Passed w/ 800. Used transcender, ms forums, and:

http://mssqlonline.com/?page_id=49

100% Valid. Just cleared the exam with 1000 in INDIA.

Can anyone please confirm whether this dump is valid in Australia?

I passed using this test and this website:

http://mssqlonline.com/?page_id=49

Dump still valid in Australia. Passed today with 90% score. Read the questions carefully.

Thank you Nanosa

Pass the exam today , the exam was exactly like this dump , thanks alot.

still valid in south africa ..passed on the 4th/02/2014 with 875..still valid

Still valid in Morocco
Passed the exam (01 Feb 2014) with more than 960
Just two new qustions, but you must read the question carefully

I passed the exam today 9xx, i major change .p.createdDatetime < cte.createdDatetime.

Thanks guys. even with the materials here you need some work and practice experience to pass this exam. i initially failed it. pls read the questions carefully.. Microsoft are very smart guys they might want to fool you

great work .. passed d exam today with 756.. options are changed so look carefully...

Still valid in India. Only 1 question was there which I had not seen in the dumps. :)

Pass the exam today. 5 questions are slightly changed, no code writing. Read the question carefully

@Nico

regarding I/Q13 i think the catch is on the "You need to ensure that the documents must only be accessible via Transact-SQL Queries". With FILESTREAM you can access the documents also via the Managed API. See here for more:

https://www.simple-talk.com/sql/learn-sql-server/an-introduction-to-sql-server-filestream/

I passed in the exam today. This dump is still valid in Brazil. There are some different questions.

very good

how many question are there in the 2014 exam how manny are different from that present in the dump i want total number of question for 2014 exams has pattern changed? are there case studies and code writing

Still Valid in Texas

Valid!!!

Passed today in Sri Lanka with 9xx. Still 70% valid

ya..still valid..passed with 9xx...no code writing,but drag and drop is there.

Is this exam valid in Brazil?

I'm planning to pass this exam on February. is still valid in Canada ?

Please, Can anyone confirm if this dump still valid in Morocco for 2014

Still valid in india?

90% Valid in Pakistan... I Passed with 8xx marks...
Thanks anyway...

Is this Dump still valid in Pakistan?

still valid. Thanks
Leaon From Sri Lanka

I passed my exam last saturday, score:940 in Portugal, about 10 different questions, there was no typing questions and some of the same questions with little differences

Still valid. Thanks

Still valid in Italy ! Pass on 9 Jan 928 marks.
During exam session read carefully because there could be differences on WHERE or ORDER BY clause (expecially grouping questions). Moreover, depending non this differences, right answer should be "no answer"
Thanks everybody !

still valid. Thanks

I am going to write this exam next month , can i go with these dumps or i need some more material.

hy is this dump stil valid in south africa

hi, is this dump still valid in south africa im planning ot take it @ the end of the month.

Is the dump valid in 2014 in india? pls reply

Is this dump still valid?

Has anyone from South Africa written this exam in this 2014? If so was this dump valid?

Hi,
I am planning to take this exam. I see there are few questions in the dump to type the queries. these questions are coming in the real exam?

Still valid- Saudi Arabia
Passed the exam (25 Dec 2013) more than 870

Extremely valid passed with 812.. Only 3 questions different!
There is one new question on employee ID number!

VALID....PASSED...718/1000

PASSED.....718/1000...THANKS ...FOR POSTING THE DUMPS.....NO CODE WRITING QUESTIONS...CONCENTRATE ON THE QUESTIONS WELL...

This dump is Still Valid in México, 3 news drag and drop (very easy) questions 80% is valid.

Still valid in INDIA

Passed today withi 9xx. Only study from this dump. Very valid, only 1 new question. No code write question.

HI,
I AM PLANNING TO TAKE THIS EXAM(70-461) ON NEXT WEEK....CAN ANYBODY...PLS TELL ME HOW MANY QUESTIONS ARE THERE FOR THE EXAM AND HOW MANY HOURS.
ALSO, IS THERE ANY CODING BASED QUESTIONS??

Still Valid. Passed today.....

Still Valid in Italy. Pass over 9xx. 3/4 new questions.

This dump is still valid in South Africa. Passed today with a 8xx. Thanks a lot guys.

Still valid in Pakistan, passed today with 943

Still valid in India. Pass with 9XX.

Still Valid In Jordan , Passed 800

Still Valid in India..

Hey guys, thank you for the great comments and great vce. Wanted to see if anyone knows if this is still valid or not? Please post if it is. Thank you!

passed today 800+ ,had some twisted question ,thoery was similar, no case study no code writing...thanks alot

Good Day All. i am gonna write 70-461 next week. I would like to find out if anyone knows if the survey that you take at the beginning of the exam has any relevance to the number of questions that you are asked in the exam. Or is this number randomly generated or is there a fix range of the number of questions asked in the exam.

Thanks

Hi guys,
I'm taking exam tomorrow..just want to ask if there's any coding or typing questions?.. thanks a lot

Mixed Questions N11, Q13. I think this one should be D:
To use FILESTREAM, you must create or modify a database to contain a special type of filegroup. Then, create or modify a table so that it contains a varbinary(max) column with the FILESTREAM attribute.
When a table contains a FILESTREAM column, each row must have a nonnull unique row ID.
Example:
http://technet.microsoft.com/en-us/library/cc645583.aspx
CREATE TABLE Archive.dbo.Records
(
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
[SerialNumber] INTEGER UNIQUE,
[Chart] VARBINARY(MAX) FILESTREAM NULL
)
GO.

Hi, MixQuestions1 nr 13. I think this one should be D:
To use FILESTREAM, you must create or modify a database to contain a special type of filegroup. Then, create or modify a table so that it contains a varbinary(max) column with the FILESTREAM attribute.
When a table contains a FILESTREAM column, each row must have a nonnull unique row ID.
Example:
http://technet.microsoft.com/en-us/library/cc645583.aspx
CREATE TABLE Archive.dbo.Records
(
[Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,
[SerialNumber] INTEGER UNIQUE,
[Chart] VARBINARY(MAX) FILESTREAM NULL
)
GO.
Anyone?

still valid, 925, Poland - there is a few changes in answers

Still valid passed on 28th 8xx, there is how ever a few changes and a few wrong answers but all in all still valid in south africa

still valid, 850, Turkey

This dump is still valid all most all ,
Score 981 .
Except for the union all to union .

All valid with a few changes. Q&A Union All - changed to no dups:Answer Intesect, Grouping Sets changed from Max(date) to Min(date): swop cte and p dates. For XML