Site Search:
70-461 Premium VCE File | |
70-461.vce - ExamCollection Verified - Instant Download 221 Questions & Answers |
|
Get Unlimited Access to ALL Premium Files | $69.99 |
Download Microsoft.BrainDump.70-461.v2013-04-23.by.Ax.95q.vce

Exam: | 70-461 - MCSA Querying Microsoft SQL Server 2012/2014 |
Size: | 1.64 MB |
# of downloads: | 377 |
Free Download: | This file is outdated. Browse other 70-461 VCE Files |



Note:
Use VCE Exam Simulator only to play VCE files properly.
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;
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
preguntas correctas, 840/1000 !!!. siguen siendo valida, excepto una pregunta nueva.
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"
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.
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
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 ?
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
Ahmad Fakhry
- Saudi Arabia
- May 11, 2013
Passed today 887 from Saudi Arabia . Still valid but some new questions are added , needs update .
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
Extremely valid. Passed with 981 today. There were slight variations but all and all, very correct.
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
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..:)
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
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
Report Comment
Verify: | |

Add Comment


How to Open VCE Files
Use VCE Exam Simulator to open VCE files.
![]() |
VCE Exam Simulator For Windows |
![]() |
VCE Simulator For Mobile For Android |
![]() |
VCE Simulator For Mobile For iPhone |
![]() |
VCE Simulator For Mac OS X |


Training Products
Premium File
- 221 Questions & Answers
- Instant Download
- $69.99


Related Blog Posts




Please fill out your email address below in order to Download VCE files or view Training Courses. Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- VCE Files Simulate Real exam environment
- Instant download After Registration.
A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Please Log In to download VCE file or view Training Course
Only registered Examcollection.com members can download vce files or view training courses.
Registration is free and easy - just provide your E-mail address. Click Here to Register


Your file is being downloaded.
All tests on this site have been created with VCE Exam Simulator.
VCE Exam Simulator is interactive testing engine developed for certification exam preparation.
Files with VCE extension can be opened with this program.
Before you can open any file on this site you will need to download VCE Exam Simulator

Log in to make your opinion count.
Only registered Examcollection.com members can rate files.
Registration is free and easy - just provide your E-mail address. Click Here to Register