Pass Your Microsoft 70-461 Exam Easy!

Get 100% Real Exam Questions, Accurate & Verified Answers By IT Experts

Fast Updates & Instant Download!

Certification Exam: 70-461 (MCSA Querying Microsoft SQL Server 2012/2014)
70-461 Premium Bundle

$79.99

Microsoft 70-461 Premium Bundle

Premium File: 254 Questions & Answers

Last Update: Nov 27, 2020

Training Course: 147 Video Lectures

PDF Study Guide: 1225 Pages

70-461 Bundle gives you unlimited access to "70-461" files. However, this does not replace the need for a .vce exam simulator. To download VCE exam simulator click here
Microsoft 70-461 Premium Bundle
Microsoft 70-461 Premium Bundle

Premium File: 254 Questions & Answers

Last Update: Nov 27, 2020

Training Course: 147 Video Lectures

PDF Study Guide: 1225 Pages

$79.99

70-461 Bundle gives you unlimited access to "70-461" files. However, this does not replace the need for a .vce exam simulator. To download your .vce exam simulator click here

Download Free 70-461 Exam Questions

Exam 70-461 - MCSA Querying Microsoft SQL Server 2012/2014
Size: 1.64 MB
Posted Date: Tuesday, April 23, 2013
# of downloads: 377
Free Download: This file is outdated. Browse other 70-461 VCE Files
Exam
70-461 - MCSA Querying Microsoft SQL Server 2012/2014
Size
1.64 MB
Posted Date
Tuesday, April 23, 2013
# of downloads
377
Free Download
This file is outdated. Browse other 70-461 VCE Files
Comments
* The most recent comment are at the top
  • Praveen
  • Canada
  • Sep 16, 2014

Is it still valid? can someone confirm?

  • Sep 16, 2014
  • Roberto
  • Brazil
  • Jan 21, 2014

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

  • Jan 21, 2014
  • Dandanagg
  • United States
  • Sep 28, 2013

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

  • Sep 28, 2013
  • 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

  • Sep 13, 2013
  • 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;

  • Aug 08, 2013
  • Thang
  • Netherlands
  • Jul 12, 2013

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

  • Jul 12, 2013
  • mnich1986@gmail.com
  • Poland
  • Jul 11, 2013

Still valid in Poland, I passed with 868 today.

  • Jul 11, 2013
  • guest1988
  • Indonesia
  • Jul 03, 2013

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

  • Jul 03, 2013
  • 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?

  • Jun 26, 2013
  • Haxx0r
  • United Kingdom
  • Jun 21, 2013

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

Thanks

  • Jun 21, 2013
  • jose
  • Spain
  • Jun 14, 2013

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

  • Jun 14, 2013
  • Jose
  • Spain
  • Jun 14, 2013

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

  • Jun 14, 2013
  • bobby
  • India
  • Jun 11, 2013

dump is still valid!!!

  • Jun 11, 2013
  • oliver rodrigues
  • Brazil
  • Jun 04, 2013

valid in Brazil. scored 943

  • Jun 04, 2013
  • GermanSQLSmurf
  • Germany
  • Jun 04, 2013

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

  • Jun 04, 2013
  • Tareq
  • United Arab Emirates
  • Jun 04, 2013

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

  • Jun 04, 2013
  • 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"

  • Jun 01, 2013
  • Tonyk
  • Poland
  • May 31, 2013

valid but 10/44 new questions not from this dump

  • May 31, 2013
  • TO
  • United Arab Emirates
  • May 30, 2013

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

  • May 30, 2013
  • 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.

  • May 29, 2013
  • 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.

  • May 28, 2013
  • mili
  • United States
  • May 28, 2013

Dumps are still valid. passed with score of 962.

  • May 28, 2013
  • 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 ;)

  • May 27, 2013
  • reinmarb
  • Czech Republic
  • May 27, 2013

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

  • May 27, 2013
  • 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

  • May 25, 2013
  • ad
  • Russian Federation
  • May 25, 2013

valid- 925 points

  • May 25, 2013
  • 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

  • May 24, 2013
  • 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.

  • May 24, 2013
  • 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 !!!

  • May 24, 2013
  • 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 ?

  • May 24, 2013
  • jaspreet
  • India
  • May 24, 2013

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

  • May 24, 2013
  • mitul
  • United States
  • May 22, 2013

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

  • May 22, 2013
  • 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?

  • May 21, 2013
  • 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.

  • May 21, 2013
  • 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.

  • May 21, 2013
  • 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

  • May 21, 2013
  • 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

  • May 21, 2013
  • 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 ?

  • May 20, 2013
  • 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 .

  • May 19, 2013
  • 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
)

  • May 19, 2013
  • 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

  • May 17, 2013
  • mon
  • Slovenia
  • May 15, 2013

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

  • May 15, 2013
  • Ahmad Fakhry
  • Saudi Arabia
  • May 11, 2013

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

  • May 11, 2013
  • omair
  • Pakistan
  • May 09, 2013

Valid, pass today with 981
Thanks

  • May 09, 2013
  • 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

  • May 08, 2013
  • 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.

  • May 07, 2013
  • Andreas
  • Sweden
  • May 06, 2013

Also. NO freetext answers.

  • May 06, 2013
  • Andreas
  • Sweden
  • May 06, 2013

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

  • May 06, 2013
  • passed
  • South Africa
  • May 06, 2013

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

  • May 06, 2013
  • 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)

  • May 06, 2013
  • Tamara
  • Switzerland
  • May 03, 2013

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

  • May 03, 2013
  • galapow
  • Hungary
  • May 03, 2013

passed today, only 1 new question, dump still valid

  • May 03, 2013
  • 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).

  • May 02, 2013
  • 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..:)

  • May 02, 2013
  • Ax
  • Italy
  • May 02, 2013

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

  • May 02, 2013
  • 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)

  • May 01, 2013
  • 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

  • May 01, 2013
  • DBA Brazil
  • Brazil
  • Apr 30, 2013

This Dump is valid in Brazil

  • Apr 30, 2013
  • 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 :)

  • Apr 27, 2013
  • 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

  • Apr 26, 2013
  • 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

  • Apr 25, 2013
  • 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

  • Apr 24, 2013

Add Comments

Only Registered Members Can Download VCE Files or View Training Courses

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.
Please provide a correct e-mail address
A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

Log into your ExamCollection Account

Please Log In to download VCE file or view Training Course

Please provide a correct E-mail address

Please provide your Password (min. 6 characters)

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

Autumn Sale: 20% OFF!

ExamCollection Premium

ExamCollection Premium Files

Get Unlimited Access to all ExamCollection's PREMIUM files!

  • ExamCollection Certified Safe Files
  • Guaranteed to have ACTUAL Exam Questions
  • Up-to-Date Exam Study Material - Verified by Experts
  • Instant Downloads
Enter Your Email Address to Receive Your 20% OFF Discount Code
A Confirmation Link will be sent to this email address to verify your login
We value your privacy. We will not rent or sell your email address

Autumn Sale: 20% OFF!

Use Discount Code:

EXAM2020

A confirmation link was sent to your e-mail.
Please check your mailbox for a message from support@examcollection.com and follow the directions.

Next

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.