Note:

Use VCE Exam Simulator only to play VCE files properly.

Praveen

• Canada
• Sep 16, 2014
• 

Is it still valid? can someone confirm?

Roberto

• Brazil
• Jan 21, 2014
• 

Still valid...Around 4 new questions. Passed with 948

Dandanagg

• United States
• Sep 28, 2013
• 

Dump is valid , wrote on sep 24 and scored 925.Thanks everyone.

THOTA PRASANNA LAXMI

• India
• Sep 13, 2013
• 

I have written the exam on sep$th 2013 and passed the exam with 868 marks.All the questions re from this dump

chris

• Switzerland
• Aug 08, 2013
• 

Q17: answer is wrong, orderDate must be in the select list, when you want to order it. maybe they want something like this as an answer:

WITH temptable as
(SELECT c.Lastname, MAX(o.OrderDate) as MostRecentOrderDate
FROM Customers c inner join Orders o
ON c.CustomerID = o.CustomerID
GROUP BY c.LastName)
SELECT * FROM temptable
ORDER BY MostRecentOrderDate DESC;

Thang

• Netherlands
• Jul 12, 2013
• 

Thanks 7thfreak, Ax. Just pass with 981, still valid here.

mnich1986@gmail.com

• Poland
• Jul 11, 2013
• 

Still valid in Poland, I passed with 868 today.

guest1988

• Indonesia
• Jul 03, 2013
• 

still valid here in jakarta. got 1 new question though.

Mark

• United States
• Jun 26, 2013
• 

For the question on this dump "To answer, type the correct code in the answer area" Am I actually writing the code or selecting the best answer?

Haxx0r

• United Kingdom
• Jun 21, 2013
• 

Still valid :) some new questions but this is enough to pass.

Thanks

jose

• Spain
• Jun 14, 2013
• 

right questions, 840/1000!. are still valid, except a new question

Jose

• Spain
• Jun 14, 2013
• 

preguntas correctas, 840/1000 !!!. siguen siendo valida, excepto una pregunta nueva.

bobby

• India
• Jun 11, 2013
• 

dump is still valid!!!

oliver rodrigues

• Brazil
• Jun 04, 2013
• 

valid in Brazil. scored 943

GermanSQLSmurf

• Germany
• Jun 04, 2013
• 

Passed today 925,dump helped alot. Everything in, some minor changes.min to max,latest to oldest etc.

Tareq

• United Arab Emirates
• Jun 04, 2013
• 

@ Scuz: thnx :)
@ Guy: read scuz comment, the answer is there.

Scuz

• New Zealand
• Jun 01, 2013
• 

Tareq, there are 95 questions in total in this dump. If you select 'Take a selected exam', it will select only 44 questions to simulate the real exam. You have option of taking the entire 95 questions under 'Take XXX questions from the entire exam file"

Tonyk

• Poland
• May 31, 2013
• 

valid but 10/44 new questions not from this dump

TO

• United Arab Emirates
• May 30, 2013
• 

Hello !
how many questions there are in the real test ??

Garfield

• Switzerland
• May 29, 2013
• 

Valid. Scored 9xx.

All the questions included in the dump.
However, answered all the questions as indicated in the dump, so some of them are incorrect. Still passed.

Tareq

• United Arab Emirates
• May 28, 2013
• 

Hi guys, as it says in ur comments that this dump covers the whole real exam questions, but in the dump there is only 43 questions 10 of them are writing codes, so how come it covers the real exam since the real exam contains between 45 and 55 questions.? kindly advise.

mili

• United States
• May 28, 2013
• 

Dumps are still valid. passed with score of 962.

Dan

• Italy
• May 27, 2013
• 

Valid dump, passed with 943. No answer to write. A few difference in formulation of answers. EG: B, Q36 has an option more. C, Q8, has an option left.
2 new questions, but very similar to these in the dump.
1) Asks for correct type for a fixed precision with 6 scale digits with options: biging, varchar, real, decimal.
2) In Employee table, question is about which field should have a self-referenced foreign key.

Bel lavoro Ax, grazie ;)

reinmarb

• Czech Republic
• May 27, 2013
• 

Valid in CZ. One new question and some new options for anothers, but pretty much valid.

Gupta

• Bahrain
• May 25, 2013
• 

@ mili & @GV1x
I verified Q 33 based your link to msdn it says:
------------------------------------------
1) .WRITE (expression,@Offset,@Length)
If @Offset is NULL, the update operation appends expression at the end of the existing column_name value
2) If you must use TOP to apply updates in a meaningful chronology, you must use TOP together with ORDER BY in a subselect statement. The following example updates the vacation hours of the 10 employees with the earliest hire dates.
Transact-SQL

UPDATE HumanResources.Employee
SET VacationHours = VacationHours + 8
FROM (SELECT TOP 10 BusinessEntityID FROM HumanResources.Employee
ORDER BY HireDate ASC) AS th
WHERE HumanResources.Employee.BusinessEntityID = th.BusinessEntityID;
GO
-------------------------------------------
so no doubt answer is C update .write.null,0) from..

Guys whats your opinion

ad

• Russian Federation
• May 25, 2013
• 

valid- 925 points

mili

• United States
• May 24, 2013
• 

@GV1x-- i think the answer is write for Q33 . please go through the link below (read all details.) i had hard time finding the same ,but now its clear.


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

Gv1x

• Belgium
• May 24, 2013
• 

Q17 is incorrect:
GROUP BY LastName
ORDER BY OrderDate

=> You can't order by an item which is not in the group by.

Gv1x

• Belgium
• May 24, 2013
• 

Q33: who have already seen something like: Summary.WRITE(N'This is in a draft stage', NULL, 0) ???

- .WRITE doesn't exist in TSQL !!!

Gv1x

• Belgium
• May 24, 2013
• 

The answer to Q19 is incorrect according to me:
"The query must return the ranking of rows in a column named PriceRank"
=> So the solution should be: RANK() OVER(ORDER BY UnitPrice DESC) as PriceRank
- Why the proposed solution use a partition for the rank function ?

jaspreet

• India
• May 24, 2013
• 

@mitul
thanks alot. but i got those. and cleared the exam. :)

mitul

• United States
• May 22, 2013
• 

@jaspreet : I have pdf available.send me ur email address on mitul1910@gmail.com

oliver rodrigues

• Brazil
• May 21, 2013
• 

Exam A Q16 the answer still uses two-part names. the correct would be "from details" and not "from sales.details" . am I right?

Nes

• South Africa
• May 21, 2013
• 

Passed with 8**. Dump is valid but there are a few questions where you are required to drag and drop. One related to Merge (so learn the merge function) another related to a view with schemabind and one related to a inline table valued function where you have to define the function and build up the select query. Other than that only a few new questions but you will pass with this dump. Don't learn this in parrot fashion. Make sure you understand the reason for the answers that are provided.

Tentical

• May 21, 2013
• 

Took exam today and passed with score 9xx. No written query questions. a couple of changes to wording on some questions. Eg. MIN instead of MAX.

jaspreet

• India
• May 21, 2013
• 

i'm unable to open it even using vce suite. dont know wats wrong.
please help. can anybody send me the pdf version of these dumps. i'm takin this exam tomorrow. please help

Viento

• Peru
• May 21, 2013
• 

Still valid, no questions to write, just mark and order, passed with 793 without knowing anything of SQL with this exam. :P

Adrien

• France
• May 20, 2013
• 

Exam A , Q 21

I think answer is not :

SELECT OrderID
FROM dbo.Orders
WHERE OrderDate > CONVERT(DATETIME, @Parameter1)

Because for @Parameter = '20080504', the function CONVERT(DATETIME, @Parameter1) give this datetime : 2008-05-04 00:00:00
Therefore the OrderDate 2008-05-04 12:00:00 is returned.

I propose this :
SELECT OrderIDe
FROM Sales.Orders
WHERE OrderDate >= DATEADD("day", 1, @Parameter1)

Someone to confirm ?

An

• United Kingdom
• May 19, 2013
• 

Today I completed this certification , two new questions came .Question related to self referential integrity and some other question .

J,jon

• Switzerland
• May 19, 2013
• 

correct if i'm wrong:
exam A, Q 12
typing error

(
SELECT OrderID,OrderDate,SalesTerrirotyID,TotalDue
FROM Sales.OrdersByTerritory
WHERE SalesTerritoryID = @T
)

correction === >
(
SELECT OrderID,OrderDate,SalesTerritoryID,TotalDue
FROM Sales.OrdersByTerritory
WHERE SalesTerritoryID = @T
)

Ax

• Italy
• May 17, 2013
• 

Still valid.
Passed today with score 1000!
Pay attention to answer. Some changed or reversed.
A new question about roll up and cube.
No writing answer.
5 question about xml.
Have a nice day world!!!
Ax

mon

• Slovenia
• May 15, 2013
• 

valid (925/1000). got one new question .

Ahmad Fakhry

• Saudi Arabia
• May 11, 2013
• 

Passed today 887 from Saudi Arabia . Still valid but some new questions are added , needs update .

omair

• Pakistan
• May 09, 2013
• 

Valid, pass today with 981
Thanks

Jerry

• United States
• May 08, 2013
• 

Valid. Passed 906/1000. About 80% of the exam had questions from this dump. Some list-reorder questions. Tnx

Ed

• United States
• May 07, 2013
• 

Passed. Dump valid; a few list-reorder questions, no query writing.
4-5 For XML questions. A few min/max, union/union all variants that others have mentioned. No spatials.

Andreas

• Sweden
• May 06, 2013
• 

Also. NO freetext answers.

Andreas

• Sweden
• May 06, 2013
• 

Extremely valid. Passed with 981 today. There were slight variations but all and all, very correct.

passed

• South Africa
• May 06, 2013
• 

Passed last week in south africa, dump is valid, thanks..

Andy

• Taiwan
• May 06, 2013
• 

I passed with 850, total 44 questions, this dump is still valid, but I am not lucky..meet two questions to write query about Exam A Q16 and Exam A Q18 !!

<Exam A Q16>
SELECT SalesTerritoryID,
ProductID,
AVG(UnitPrice),
MAX(OrderQty),
MAX(DiscountAmount)
FROM Sales.Details
GROUP BY SalesTerritoryID , ProductID
ORDER BY SalesTerritoryID DESC, ProductID DESC

<Exam A Q18>
DECLARE @XML1 XML(Sales.InvoiceSchema)

Tamara

• Switzerland
• May 03, 2013
• 

to J.Carlos
Thank you for your explanation,
I wish you many luck for your future Exams

galapow

• Hungary
• May 03, 2013
• 

passed today, only 1 new question, dump still valid

Modulus

• United States
• May 02, 2013
• 

I passed today, this dump is still valid! There were no questions where you had to type. There were 4-5 drag and drop questions (all in this dump).

Kai

• United States
• May 02, 2013
• 

Thanks for the updated version - knew something was not right especially Exam C Q1. There is still typos - minor ones such as @CustomerRatIng which is supposed to be @CustomerRating. Minor..:)

Ax

• Italy
• May 02, 2013
• 

Hi,
there are NO question to write during the exam.

J.Carlos From Spain

• Spain
• May 01, 2013
• 

Hello Tamara.
I passed this exam yesterday, in this type of questions, you have to type the querys, for that reason there is only one answer.If you click show the answer these are the answers that you should type. In the question above you should type.

DECLARE @XML1 XML (Sales.InvoiceSchema)

Tamara

• Switzerland
• May 01, 2013
• 

I also have the same problem,
some question they have only one answer
example:

Q18, Exam A=

You have an XML schema collection named Sales.InvoiceSchema. You need to declare a variable of the XML type named XML1. The solution must ensure that XML1 is validated by using Sales.InvoiceSchema.
Which code segment should you use?
To answer, type the correct code in the answer area.

only one answer, "A"
please help

DBA Brazil

• Brazil
• Apr 30, 2013
• 

This Dump is valid in Brazil

Modulus

• United States
• Apr 27, 2013
• 

Some of the questions do not include multiple choices.
For example Exam A, Q14.
Is this just me or do some of the questions not have multiple choices?
Thanks a lot for creating this :)

sou

• India
• Apr 26, 2013
• 

I passed with 981 yesterday.

Total 44 questions were there
For me,there was no question to write query.
Different types of ForXML syntax(5 queations) were there.

Question were all similar in in the dumps given. Read questions carefully before answering

AJ

• United States
• Apr 25, 2013
• 

Ax, Is this updated old versions with correct answers? Thanks
Anyone commenting these days about how the the test is....

Thanks All

Ax

• Italy
• Apr 24, 2013
• 

I made this VCE starting from:
http://www.examcollection.com/microsoft/Microsoft.BrainDump.70-461.v2012-11-24.by.7thfreak.95q.vce.file.html
with correction and type errors.
I hope tha's usefull for all.
Ax