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

Rating:

2 liked this dump 0 disliked
Click here to Like Dislike

Guaranteed Exam Answers from Pass4sure
Comments

* The most recent comments are at the top.

Note:

Use VCE Exam Simulator only to play VCE files properly.


Praveen

  • Canada
  • Sep 16, 2014
  • Report Comment

Is it still valid? can someone confirm?


Roberto

  • Brazil
  • Jan 21, 2014
  • Report Comment

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


Dandanagg

  • United States
  • Sep 28, 2013
  • Report Comment

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


THOTA PRASANNA LAXMI

  • India
  • Sep 13, 2013
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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


mnich1986@gmail.com

  • Poland
  • Jul 11, 2013
  • Report Comment

Still valid in Poland, I passed with 868 today.


guest1988

  • Indonesia
  • Jul 03, 2013
  • Report Comment

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


Mark

  • United States
  • Jun 26, 2013
  • Report Comment

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
  • Report Comment

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

Thanks


jose

  • Spain
  • Jun 14, 2013
  • Report Comment

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


Jose

  • Spain
  • Jun 14, 2013
  • Report Comment

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


bobby

  • India
  • Jun 11, 2013
  • Report Comment

dump is still valid!!!


oliver rodrigues

  • Brazil
  • Jun 04, 2013
  • Report Comment

valid in Brazil. scored 943


GermanSQLSmurf

  • Germany
  • Jun 04, 2013
  • Report Comment

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
  • Report Comment

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


Scuz

  • New Zealand
  • Jun 01, 2013
  • Report Comment

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
  • Report Comment

valid but 10/44 new questions not from this dump


TO

  • United Arab Emirates
  • May 30, 2013
  • Report Comment

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


Garfield

  • Switzerland
  • May 29, 2013
  • Report Comment

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
  • Report Comment

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
  • Report Comment

Dumps are still valid. passed with score of 962.


Dan

  • Italy
  • May 27, 2013
  • Report Comment

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
  • Report Comment

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


Gupta

  • Bahrain
  • May 25, 2013
  • Report Comment

@ 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
  • Report Comment

valid- 925 points


mili

  • United States
  • May 24, 2013
  • Report Comment

@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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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


mitul

  • United States
  • May 22, 2013
  • Report Comment

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


oliver rodrigues

  • Brazil
  • May 21, 2013
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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


Ahmad Fakhry

  • Saudi Arabia
  • May 11, 2013
  • Report Comment

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


omair

  • Pakistan
  • May 09, 2013
  • Report Comment

Valid, pass today with 981
Thanks


Jerry

  • United States
  • May 08, 2013
  • Report Comment

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
  • Report Comment

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
  • Report Comment

Also. NO freetext answers.


Andreas

  • Sweden
  • May 06, 2013
  • Report Comment

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


passed

  • South Africa
  • May 06, 2013
  • Report Comment

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


Andy

  • Taiwan
  • May 06, 2013
  • Report Comment

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
  • Report Comment

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


galapow

  • Hungary
  • May 03, 2013
  • Report Comment

passed today, only 1 new question, dump still valid


Modulus

  • United States
  • May 02, 2013
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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


J.Carlos From Spain

  • Spain
  • May 01, 2013
  • Report Comment

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
  • Report Comment

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
  • Report Comment

This Dump is valid in Brazil


Modulus

  • United States
  • Apr 27, 2013
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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
  • Report Comment

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

Name: *
E-mail: *

This e-mail will not be published.

Comment: *

Comment will be moderated and published within 1-4 hours.

Rate file: * Like!     Dislike
Verification: * Secure Code
Type the characters from the picture.  
VCE Exam Simulator Free DemoVCE Exam Simulator Free Demo
Read about VCE Exam Simulator
Download VCE Exam Simulator

Training Products

Premium File

  • 221 Questions & Answers
  • Instant Download
  • $69.99

Get Unlimited Access to the all ExamCollection PREMIUM VCE files!
Prep4sure - Professional IT Certification Training
BrainDumps - Get Real Exam Questions
Actual Tests - Lifetime Access to IT Exams

Related Blog Posts

Site Search:

Close
Only Registered Members Can Download VCE Files

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
Email Address:

A confirmation link will be sent to this email address to verify your login.
Already Member? Click Here to Login

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

E-mail:
*  
Password:
* Forgot password?
 

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

Close
DO YOU HAVE A VCE PLAYER?
Play VCE files with Avanset VCE Simulator

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

Download VCE Player
I already have it
Close
Like this VCE file?

Log in to make your opinion count.

E-mail:
*  
Password:
* Forgot password?
 

Only registered Examcollection.com members can rate files.

Registration is free and easy - just provide your E-mail address. Click Here to Register

Close

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


Enter Your Email Address

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