Pass Your Microsoft 70-461 Exam Easy!

Is it still valid? can someone confirm?

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

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

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

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;

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

Still valid in Poland, I passed with 868 today.

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

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?

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

Thanks

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

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

dump is still valid!!!

valid in Brazil. scored 943

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

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

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"

valid but 10/44 new questions not from this dump

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

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.

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.

Dumps are still valid. passed with score of 962.

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

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

@ 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

valid- 925 points

@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

Q17 is incorrect:
GROUP BY LastName
ORDER BY OrderDate

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

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

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

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 ?

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

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

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

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.

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.

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

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

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 ?

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

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
)

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

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

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

Valid, pass today with 981
Thanks

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

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.

Also. NO freetext answers.

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

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

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)

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

passed today, only 1 new question, dump still valid

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

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

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

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)

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

This Dump is valid in Brazil

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

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

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

Thanks All

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