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)

Download Free 70-461 Exam Questions

Exam 70-461 - MCSA Querying Microsoft SQL Server 2012/2014
Size: 1.64 MB
Posted Date: Sunday, November 25, 2012
# of downloads: 530
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
Sunday, November 25, 2012
# of downloads
530
Free Download
This file is outdated. Browse other 70-461 VCE Files
Comments
* The most recent comment are at the top
  • zahid
  • India
  • Aug 25, 2014

Dear all,
i am planning to give the exams of sql server 2012 (07-461), anybody plase help me from which side i can download valid dumps?

  • Aug 25, 2014
  • Herman
  • Netherlands
  • Aug 11, 2014

Still valid in Holland. and this file can be opened with the old certexam software.

  • Aug 11, 2014
  • Dhanabal
  • India
  • May 28, 2014

I am going to appear the exam on next month.Is it valid now on india.

  • May 28, 2014
  • imtiyaz
  • India
  • May 04, 2014

Hi Guys,

I am plaaning to appear for this exam in next 2 months. Could you please tell me still this dump is valid?

  • May 04, 2014
  • douglas
  • Brazil
  • Aug 05, 2013

On site is http://www.dotnetsql.com.br with various simulated English/ Port Online and free to anyone who wants to take the certification tests in microsoft Windows Server, Exchange, Sql Server, Dot.net.

Well worth checking out, because the simulated are 100% free and also show the evolution of his proofs for you to track how is the grip of their learning.

I found it very interesting, easy and no hassles!

Douglas Andrade

No site http://www.dotnetsql.com.br está com vários simulados em Portugues Online e gratuitos para quem quer tirar a certificação microsoft em provas de Windows Server, Exchange, Sql Server, Dot.net.

  • Aug 05, 2013
  • shashank aggarwal
  • India
  • May 30, 2013

hey thanks,passed with 962 marks on 27/5/2013,this dump is still valid.

  • May 30, 2013
  • anu
  • United States
  • May 29, 2013

What does the code cannot have object delimiters mean?

  • May 29, 2013
  • riyas
  • Kuwait
  • May 26, 2013

Exam A is having 43 questions.
Exam B - 38 Questions
Exam c - 10 Questions
Exam D - 4 Questions

  • May 26, 2013
  • DM
  • India
  • May 23, 2013

plz respond me asap as i'm having a voucher that will get expired on 31st of may 2013
need your help
and thanks in advance

  • May 23, 2013
  • DM
  • India
  • May 23, 2013

when i'd download this file there were only 43 questions.
how many questions you guys found (who passed this exam).
as i know exam consists of 55 questions

  • May 23, 2013
  • Ozzie
  • Australia
  • May 22, 2013

Valid dump. Passed in Australia with 9xx

  • May 22, 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
  • Leon
  • Netherlands
  • May 17, 2013

Valid, with minor changes, in the Netherlands [17-05-2013]. Passed with 9XX

  • May 17, 2013
  • None
  • United States
  • May 14, 2013

Passd for the second time with 9xx on april

  • May 14, 2013
  • S Puthran
  • Netherlands
  • May 08, 2013

Valid in Netherlands and passed with good score. Keep up the good work!!

  • May 08, 2013
  • Ojos Grandes
  • Spain
  • May 08, 2013

I passed the last monday with 9xx.
44 Questions no typing querys and no new questions but just pay attention to questions, some are changed.
Thank you ojitos azules and thanks also to Juan Carlos. Good luck to my partner's course tomorrow!!

  • May 08, 2013
  • satya
  • United States
  • May 06, 2013

best and valid passed with 925

  • 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 !!

Ans:
SELECT SalesTerritoryID,
ProductID,
AVG(UnitPrice),
MAX(OrderQty),
MAX(DiscountAmount)
FROM Sales.Details
GROUP BY SalesTerritoryID , ProductID
ORDER BY SalesTerritoryID DESC, ProductID DESC

Ans:
DECLARE @XML1 XML(Sales.InvoiceSchema)

  • May 06, 2013
  • twm
  • South Africa
  • May 06, 2013

dump still valid, I got certified on Friday.

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

Based on this dump, + user's answers + testing.. I made new version of this dump with corrections.
http://www.examcollection.com/microsoft/Microsoft.BrainDump.70-461.v2013-04-23.by.Ax.95q.vce.file.html
Have a nice day.
Ax

  • May 02, 2013
  • Ojitos Azules o Verdes o yo que sé
  • Spain
  • Apr 30, 2013

From Spain, passed today with 962.
44 Questions no typing querys.no new questions.
Congratulations to my partner's car, that passed the 462 and she'll try to pass this one last week, jajajaja.

  • Apr 30, 2013
  • Jimmy2Thongs
  • Canada
  • Apr 29, 2013

Valid in Canada. Passed with 9XX.. Some questions are not in the dump though. For example: I had questions regarding INTERSECTS & EXCEPTS. Make sure to review those as well.

  • Apr 29, 2013
  • Soumya
  • India
  • Apr 26, 2013

Thank you so much.
Passed today with 981

  • Apr 26, 2013
  • theone from United States
  • United States
  • Apr 25, 2013

This dump is valid with only a few new questions. I bought the TestKing.com version it had 50 questions and at least 10 were wrong after looking them up on the MS web site. Example Numeric has a scale not money which was the answer on TestKing..

Great VCE Passed today good luck everyone!!!

  • Apr 25, 2013
  • SS
  • India
  • Apr 24, 2013

Valid in india. Cleared today with 962.

  • Apr 24, 2013
  • Osama
  • Libya
  • Apr 24, 2013

Dear Medo make sure that you a full version of VCE Manager - Not Trial -

  • Apr 24, 2013
  • ken
  • Nigeria
  • Apr 24, 2013

still valid in nigeria

  • Apr 24, 2013
  • medo
  • Kuwait
  • Apr 24, 2013

Hello guys, is there anyone can help me !!!

after downloading the dump on my macbook and opend it i found only 5 questions ! so is that the dump ? or how i can work it the right way

please help

  • Apr 24, 2013
  • Singh
  • Canada
  • Apr 22, 2013

Passed with 925.
Valid
Good Luck

  • Apr 22, 2013
  • claus
  • United Kingdom
  • Apr 22, 2013

Valid. Thanks!

  • Apr 22, 2013
  • SA
  • South Africa
  • Apr 22, 2013

1st time writing any certification, and this is the 1st exam I'm writing.
any help , Tips is highly appreciated. writing 3rd may

  • Apr 22, 2013
  • Nimzi
  • India
  • Apr 22, 2013

passed with 925 thnx

  • Apr 22, 2013
  • Jared
  • United States
  • Apr 19, 2013

Passed today with 925. Dump is valid

  • Apr 19, 2013
  • ilounge
  • Germany
  • Apr 19, 2013

Just passed the exam today with a score of 1000. I studied extensively with the book. The practice exams from the book are a joke, but I knew that from the SQL Server 2008 exam. Many thanks for the dump, would never have scored so high without it.
A few questions were different. Question 2 from exam 4 does not have the correct syntax, all answers are wrong. Consult books online for the correct syntax.

  • Apr 19, 2013
  • Daniel
  • Hong Kong
  • Apr 19, 2013

Nice this dump, i just pass the test with 887
but you should be careful, some order of answer are changed and few new question is added.

Good Luck

  • Apr 19, 2013
  • sanjay
  • Hong Kong
  • Apr 19, 2013

Please send me the certificate which you got from microsoft after given exam of 70-461 to me on my email id daslaniya@gmail.com . who ever passed it recently . I am interested in know that what they are issueing . I am looking for any one out of mentioned below

Microsoft Certified Systems Engineer.
 Microsoft Certified Solution Developer.
 Microsoft Certified Professional Developer.
 Microsoft Certified IT Professional
 Microsoft Certified Technology Specialist

  • Apr 19, 2013
  • Sanjay
  • Hong Kong
  • Apr 19, 2013

Hi All,

I wanted to know that which certificate Microsoft issue for Passing only 70-461 exam which one out of the below or none of the below. If possible can oneplease send their soft copy to me ,want to make sure ?
Microsoft Certified Systems Engineer.
 Microsoft Certified Solution Developer.
 Microsoft Certified Professional Developer.
 Microsoft Certified IT Professional
 Microsoft Certified Technology Specialist

  • Apr 19, 2013
  • pciosa
  • Bosnia and Herzegovina
  • Apr 19, 2013

@Peter - Yes, that's right. It's a standard procedure they are obligated to follow. You are left with the piece of paper, actually it's some kind of plastic foil, and a whiteboard pen. When you're done you have to hand them over to the staff in he exam center. If you prepare the exam using this dump and understanding concepts it contains, there should be no problem for you to pass. You have 140 minutes for the exam.

  • Apr 19, 2013
  • Peter
  • Hungary
  • Apr 18, 2013

I'd like to ask how is the exam process look like?
I was told, they lock away your phone and stuff, so you cannot use anything but your own knowledge. Is it really that strict?
Thanks for the answers in advance!

  • Apr 18, 2013
  • pciosa
  • Bosnia and Herzegovina
  • Apr 18, 2013

@Anon there are 4 sub-exams in this dump - A,B,C and D and they are all valid. You will get 44 questions out of all those questions.

  • Apr 18, 2013
  • pciosa
  • Bosnia and Herzegovina
  • Apr 18, 2013

Passed today. Exam is valid just pay close attention to questions, some are changed - max became min, > became < etc. Also, take a good look at offered answers. Maybe there was one new question related to working with XML

  • Apr 18, 2013
  • Oxygen1
  • Belarus
  • Apr 18, 2013

Passed on 18.4.2013, exam still valid. 3 questions were different

  • Apr 18, 2013
  • mm
  • Canada
  • Apr 17, 2013

Hi,
I just failed the exam but the questions were all in this collections.
I wonder if I retake the exam the same question will be in my test?
Has anyone retake this exam?

  • Apr 17, 2013
  • Unknown
  • Pakistan
  • Apr 16, 2013

Exam C, Q1: Minimum permissions to delete suppliers

Correct answer: D

and for your information : Numeric and Decimal are same .

  • Apr 16, 2013
  • Teppich
  • Germany
  • Apr 16, 2013

Passed with 800 Pts in Germany with sketchy learning.
Some questions vary with details like min/max changed, but overall valid.

  • Apr 16, 2013
  • Diego
  • Ecuador
  • Apr 16, 2013

Valid for Ecuador, passed today with 925. There is a new questions based on some things of this dump

  • Apr 16, 2013
  • mitul
  • United States
  • Apr 16, 2013

Hi all,
I failed my exam the first time. I am taking my exam in 10 days. I want to make sure if this dumps are valid or no? And do i need to purchase the VCE software in order to view all qustions .?

  • Apr 16, 2013
  • Kylix
  • South Africa
  • Apr 16, 2013

Wrote this exam today, 925 - Dump is valid

  • Apr 16, 2013
  • MCP MT
  • Pakistan
  • Apr 15, 2013

Passed today with 962 score.This dump is 98% valid .
There were no question relating to writing query

I second @staretzu.

  • Apr 15, 2013
  • staretzu
  • United Kingdom
  • Apr 15, 2013

Damn, not sure why it's not picking up my country which, by the way, is Romania.

  • Apr 15, 2013
  • staretzu
  • United Kingdom
  • Apr 15, 2013

Hi guys,

Just scored 981 on this exam. I want to conform that this dump helped me a lot. In my opinion, if you know basics of SQL and you get to pass this dump, you will pass the exam as well.
Let me share my experience on this exam:

I had around 44 questions, on one I didn't answer correctly, I suspect it's the question 4 from Exam D, the one with 2 answers out of 6 (checkboxes), re creating a stored procedure and execute it. I still don't know what the correct answer for that is.

About 3-4 of the questions (top) had some small modifications (e.g. min date instead of max, etc.) as follows:
- Exam C, Q.10: Duplicates must NOT be retained. In this case you need to use UNION instead of UNION ALL
- Exam A, Q.28: Retain only the OLDEST Products row. In this case the answer was similar to the correct answer from the dump, only that it had MIN(creationdate) instead of MAX

One question had quite a major change. It's Q5 from Exam C. The answer from dump is A, drop UDF and use CTE. In my test there was no CTE, instead there was a new answer where there was a inner join (the correct one) however I cannot remember exactly.

Another thing to mention is that the category of questions were in a row i.e. all questions related to FOR XML hint were one after another. BTW if someone finds hard to understand the FOR XML questions, let me know, I have an easy way to get you to remember.

There were no FreeHandSQL question.

Cheers,
Mihai

  • Apr 15, 2013
  • MCP from Pakistan
  • United Arab Emirates
  • Apr 14, 2013

there were no writing queries but it would be better if you do practice by writing more n more SQL as this gives you hands on to understand the query syntax.

  • Apr 14, 2013
  • TK
  • Pakistan
  • Apr 14, 2013

@MCP were there any question tio qrite manually query?which answer of question changed?

  • Apr 14, 2013
  • MCP
  • United Arab Emirates
  • Apr 14, 2013

Passed with 900 + Marks .
Exam was 95% valid. one answer was changed.

  • Apr 14, 2013
  • Betty
  • United Kingdom
  • Apr 13, 2013

This is valid. Sat today in the UK passed with over 900

  • Apr 13, 2013
  • From Europe
  • United States
  • Apr 11, 2013

Hi, I passed today. In my opinion this exam is not easy.
Each question required hard think how Microsot ft see it and what they prefer.
I use sql 10 years. In my opinion are 20 wrong answeres. I made today 3 mistakes. Base only on download is riskly.

Please visit my page abot cnc.
www.TurboCNC.com

  • Apr 11, 2013
  • staretzu
  • United Kingdom
  • Apr 11, 2013

Exam A, Q4. Correct answer is D however there is a misspell: Orders.CustomerXd but it should be Orders.CustomerId.

  • Apr 11, 2013
  • john doe
  • New Zealand
  • Apr 11, 2013

still legit

  • Apr 11, 2013
  • Jim
  • India
  • Apr 11, 2013

Still valid in India. Passed exam with score 9xx today. Few changes in 2 questions. newest records changed to oldest records , max changed to min.
Thanks for the dumps

  • Apr 11, 2013
  • Lady jay
  • United States
  • Apr 09, 2013

Valid in south africa, wrote today and passed....goodluck

  • Apr 09, 2013
  • Noman
  • Pakistan
  • Apr 09, 2013

passed the exam with 887 marks. Its very helpful in preparation but must read q's carefully bcoz slightly changes in q/a.thx for sharing the dump :)

  • Apr 09, 2013
  • sql
  • United States
  • Apr 07, 2013

Where can i found Exam B, C & D?
Does questions repeat when u have your second shot or they are the same?
Thank u.

  • Apr 07, 2013
  • denis
  • Bulgaria
  • Apr 05, 2013

Still valid in Bulgaria. Pass today . 921

  • Apr 05, 2013
  • Paris
  • France
  • Apr 02, 2013

Still valid today in Paris, no new questions.

Merci :)

  • Apr 02, 2013
  • babyjesus
  • Austria
  • Apr 02, 2013

still valid in austria. Passed with 850. No need for typing queries as answers

  • Apr 02, 2013
  • lucy
  • Russian Federation
  • Apr 01, 2013

Successfully passed it. Dump is up to date.
As it was mentioned afore some questions have slightly changed: A28 asks to retain oldest product (not the newest ) & etc..
Some questions have the same answers but in different order.

As for me - there was no need to type answers manually.

This dump seems to be mangled with some text recognition tool. True MS exam doesn't contain all misprints met in this dump.

  • Apr 01, 2013
  • agnt
  • Germany
  • Mar 28, 2013

Passed Today with 906.
There was no Need to Type in Answers manually.

  • Mar 28, 2013
  • MuhammadBilal
  • Pakistan
  • Mar 28, 2013

it was surely a very good study material helped alot in the exam. Questions were changed as well as answers though it was good all over
Thanks

  • Mar 28, 2013
  • guynextdoor
  • Sri Lanka
  • Mar 27, 2013

Passed 9xx , this is valid , thanks alot

  • Mar 27, 2013
  • jimt
  • United States
  • Mar 26, 2013

Passed. Very good study material. Thanks a lot!

  • Mar 26, 2013
  • suresh
  • United States
  • Mar 26, 2013

Valid and passed with good score

  • Mar 26, 2013
  • SQL Developer
  • India
  • Mar 25, 2013

Am unable to open the vce file using the visual_certexam_suite. Getting the below error message :
"This file was created with an older version of Visual CertExam than you have. Please download the latest version from the Visual CertExam Software Web site at www.visualcertexam.com." . I am using the latest software but still getting the error. Please suggest.

  • Mar 25, 2013
  • Vishal
  • United States
  • Mar 23, 2013

Passed the exam in US with 868. This is a fairly accurate guide but read actual exam questions very carefully. Wording on some exam questions is opposite of what is asked in the brain dump. For example, dump might ask for rows older than OrderDate but exam asks for rows newer than OrderDate, or dump asks to delete all rows for a customer with OrderDate except the newest one but exam asks to keep only the row with the oldest OrderDate and delete everything else.

  • Mar 23, 2013
  • Netcode
  • Panama
  • Mar 21, 2013

It is valid, passed today
Focus on Exam B, C & D

  • Mar 21, 2013
  • Abdelaziz
  • Egypt
  • Mar 21, 2013

It is valid, passed today with 925/1000
Thank you very much

  • Mar 21, 2013
  • G
  • France
  • Mar 21, 2013

Also valid in France

  • Mar 21, 2013
  • SQL Zen
  • Romania
  • Mar 21, 2013

There are some new questions, but still valid.

  • Mar 21, 2013
  • chitta
  • India
  • Mar 19, 2013

Absolutely valid in India - cleared with 900+

  • Mar 19, 2013
  • @abraska
  • Slovenia
  • Mar 19, 2013

Exam A - Q - 17

Fix : The more right answer would be :

SELECT
C.LastName,
MAX(O.OrderDate) AS MostRecentOrderDate
FROM Customers AS C
INNER JOIN Orders AS O
ON C.CustomerID = O.CustomerID
GROUP BY C.CustomerID, C.LastName
ORDER BY MostRecentOrderDate DESC

  • Mar 19, 2013
  • fixedanswer
  • Slovenia
  • Mar 19, 2013

Exam A , Q 20 :

I think answer is :

CREATE PROCEDURE usp_Customers @Count int
AS
SELECT TOP (@Count) LastName
FROM Customers
ORDER BY LastName

PS : any idea why everyone is using aliases even when not needed ?

  • Mar 19, 2013
  • fixedanswer
  • Slovenia
  • Mar 19, 2013

Exam A , Q 21

I think answer is (The code must not use aliases) :

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

anyone got something else ?

  • Mar 19, 2013
  • fixedanswer
  • Slovenia
  • Mar 19, 2013

Exam A, Q 19.

I think answer is :

SELECT
ProductCatalog.CatID,
ProductCatalog.CatName,
ProductCatalog.ProductID,
ProductCatalog.ProdName,
ProductCatalog.UnitPrice,
RANK() OVER (ORDER BY ProductCatalog.UnitPrice DESC) AS PriceRank
FROM
Sales.ProductCatalog
ORDER BY ProductCatalog.UnitPrice DESC

  • Mar 19, 2013
  • @abraska
  • Slovenia
  • Mar 19, 2013

Exam A - Q - 17

I think answer is :

SELECT
C.LastName,
MAX(O.OrderDate) AS MostRecentOrderDate
FROM Customers AS C
INNER JOIN Orders AS O
ON C.CustomerID = O.CustomerID
GROUP BY C.LastName
ORDER BY MostRecentOrderDate DESC

  • Mar 19, 2013
  • abrashka
  • Israel
  • Mar 18, 2013

Exam A, Q-17
I think, that it must be:
order by max(o.Orderdate)
instead of: order by o.Orderdate
because o.Orderdate is not exist in select.

  • Mar 18, 2013
  • going_grey
  • South Africa
  • Mar 15, 2013

Still absolutely valid in South Africa. Completed this exam today with 981. I honestly do not know which question I got wrong :(

  • Mar 15, 2013
  • amr anwar
  • Egypt
  • Mar 14, 2013

Valid, passed today with 943

  • Mar 14, 2013
  • laflak
  • Switzerland
  • Mar 13, 2013

Valid, passed today with a 1000
You have to check some of the answers provided in the dumb.
Focus on Exam B, C & D
Some questions have changed read it carefully during the exam.

  • Mar 13, 2013
  • Assured
  • India
  • Mar 12, 2013

Valid..

  • Mar 12, 2013
  • Lynz
  • United States
  • Mar 12, 2013

So I wrote yesterday, 11 March. Still valid. Thanks a bunch!

  • Mar 12, 2013
  • Rob L
  • United Kingdom
  • Mar 11, 2013

For Exam A, Q19

You need to create a query that returns a lift of products from Sales.ProductCatalog.


The answer given contains a RANK() OVER (PARTITION BY ProductCatalog.UnitPrice ORDER BY ProductCatalog.UnitPrice DESC) as PriceRank

Surly the PARTITION BY is wrong? This will return everything with a Rank of 1/

  • Mar 11, 2013
  • Lynz
  • South Africa
  • Mar 10, 2013

Hey guys. Wanna ask, do they really ask you to type in code in the actual exam? Thanks.

  • Mar 10, 2013
  • rn
  • United Kingdom
  • Mar 08, 2013

Hello all
in exam 'a' when it says which code segment you should use..and then type your answer..do we actually need to type our answers as sometimes questions are not really clear..
thanks

  • Mar 08, 2013
  • sss
  • Spain
  • Mar 08, 2013

Valid in Spain. Some questions are not exactly the same, pay attention and read carefully.

  • Mar 08, 2013
  • HotSauce
  • United States
  • Mar 06, 2013

Passed with 868 3/6/2013. A new question or two. Of course some questions were worded in a way to make a different answer viable, such as the XML and Rank areas. Dump was extremely helpful. Thanks!

  • Mar 06, 2013
  • guru
  • India
  • Mar 05, 2013

I am confused whether to write 70-461 or 70-457..Any advice would help since I have already cleared 2008 cert on sql development

  • Mar 05, 2013
  • sep
  • United States
  • Mar 05, 2013

I had the exam last week and unfortunately I did not pass .But I decided to have the second shot.Does anybody know that the questions will be repeated?Or they know that it's my second shot and they will omit those questions and select new kind of questions from their question pool

  • Mar 05, 2013
  • Pep
  • United Kingdom
  • Mar 04, 2013

dump is still valid

  • Mar 04, 2013
  • Sara
  • United States
  • Mar 03, 2013

dump still valid. min new ques. thx

  • Mar 03, 2013
  • Todd
  • United States
  • Mar 02, 2013

I'm taking the test on in 2 days. I'll report back on my experience.

  • Mar 02, 2013
  • machoo
  • Thailand
  • Mar 02, 2013

It's still work. Cleared with 887 point

  • Mar 02, 2013
  • vaguery
  • United States
  • Mar 01, 2013

Exam C, Q1: Minimum permissions to delete suppliers

Correct answer should be (D), the PROC *without* "EXECUTE AS .. dbo."

SQL Server will *not* check child object permissions (for DELETE on the Suppliers table, in this case) if it has the same owner as the parent object (the PurgeInactiveSuppliers). Purchases.Suppliers and the newly created Purchases.PurgeInactiveSuppliers stored procedure are in the same schema, meaning there exists an "unbroken chain of ownership" for these two objects.

The only permission necessary, then, is EXECUTE permission on the stored procedure.

Reference: http://msdn.microsoft.com/en-us/library/aa905173 (written for SQL 2000, but still valid)

  • Mar 01, 2013
  • vaguery
  • United States
  • Mar 01, 2013

Exam D, Q4

Short answer: Like @Zico, I find the correct answers to be (A,E)

Reasoning:

Based upon their format you're looking for two answers: 1) the definition for the stored procedure, and 2) execution of the stored procedure.

Assuming the correct answer text simply did not make it into here, there are two possibilities for what the actual correct answers look like, depending upon which is available.

"Accepts a single input parameter" could be read as either:
1) "We can have only a *single* parameter, and it must be an input parameter," OR it could mean,
2) "There can be only a single *input* parameter," meaning that an additional output parameter is permitted.

If correct answers exist for both, prefer the former ("First case," below), since it more closely matches the literal question text.

The problem is that (F) uses "RETURNS @Result." "RETURN_S_" (with an "S") is used by a user-defined function to indicate its return data type, *not* for a stored procedure's return value. A stored proc would be just "RETURN @val," with no "S."

The second problem is that nothing will retrieve the value from (F). We're looking for:

DECLARE @Result INT
EXECUTE @Result = dbo.GetCustomerRating 1745

But none of the answer contain that. (B) lacks the requisite variable assignment.

(A) needs the name of its first parameter fixed (it's "@Customer" even though "@CustomerID" is used within its body), then (E) works perfectly. To retrieve an output variable from a stored procedure using T-SQL, the receiving variable must also be marked with OUTPUT. (For this reason, I guarantee that (C) is flat wrong.)

  • Mar 01, 2013
  • Pep
  • United Kingdom
  • Feb 27, 2013

@vaguery Thanks for those updates, how did it go for you, was the dump still valid for your exam? I will be taking this in a few days time.

  • Feb 27, 2013
  • vaguery
  • United States
  • Feb 27, 2013

Corrections to a few of the code-writing questions (which, incidentally, I *did* have on my exam).

Note about Database Diagrams for the following: tables in the "dbo" schema show up as simply "Tablename." If they belong to another schema, it shows in parentheses after the table name. (See the image in Exam A, Q15 for an example, i.e., "Orders (SALES).")

Exam A, Q14: Create View in Sales

The *view* must be in the "Sales" schema, but the "Customers" table is in the "dbo" schema (see above). Therefore, the query should look like the following:

CREATE VIEW Sales.uv_CustomerFullName
WITH SCHEMABINDING
AS
SELECT FirstName, LastName
FROM dbo.Customers

Note the change to "dbo" on the last line.

Exam A, Q21: Stored Proc w/ casting varchar to datetime.

One of the requirements bullets states:
"The objects called in Procedure1 must be able to be resolved by all users."

Exam A, Q14 says something similar, but more explicitly:
"The view must be able to resolve all referenced objects, regardless of the user's default schema."

I interpret this to mean that it wants to include the schema name in the procedure:

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

(Added "dbo." to the FROM clause.)

  • Feb 27, 2013
  • ivan
  • Tunisia
  • Feb 25, 2013

dump 100% valid
ssome new questions but still valid

  • Feb 25, 2013
  • Simon
  • United Kingdom
  • Feb 23, 2013

Passed today. Some new questions have been added. Also the ReportoID was in my exam

  • Feb 23, 2013
  • Sadek
  • France
  • Feb 18, 2013

Passed today with 925/1000, Same questions

  • Feb 18, 2013
  • Dean
  • United Kingdom
  • Feb 17, 2013

@certfreak so you're saying the questions have changed slightly?

  • Feb 17, 2013
  • CertFreak
  • Australia
  • Feb 17, 2013

Passed today with 900+. Same questions. You need to pay attention as there are slight changes such as min vs max, keep duplicates vs remove duplicates, etc. Thanks 7thfreak and exam collection for this amazing study resource.

  • Feb 17, 2013
  • wicho
  • Peru
  • Feb 16, 2013

I've passed. Thanks for this useful information.

Feedback: like 4 or 5 questions to make the code or arrange the code like Exam C. 44 questions in total.

Several questions have the same scenario and the question was different the answers look the same, you have to read very carefully specially in the rank questions.

  • Feb 16, 2013
  • fiote
  • Brazil
  • Feb 15, 2013

Passed with 943.

1 New question in the EmpID-EmpNum-ReportsToID series.
Q: Which column should be set as Self-Referential-Foreign-Key.
Ans: ReportsToID

Not a single min/max change, but the answers were logically out of order.

@Philip, Not a single question asking to actually writing sql. All multiple choice or "organize the code" like in the dump.

@Crhis, Exam B Q16 popped up in my exam. The DATEADD was correctly with 3 parameters.

  • Feb 15, 2013
  • Philip Ashmore
  • Feb 15, 2013

To the people who have taken this exam (if you come back to read the comments) did you actually get asked to write any queries while in your exam?

  • Feb 15, 2013
  • fiote
  • Brazil
  • Feb 14, 2013

@Chris, (A) can not be the correct answer.

The question says "column named OrderTime that stores the DATE and the TIME each order is placed".

(A) SELECT Count(*) FROM SalesOrders WHERE OrderTime = CONVERT(DATE, GETDATE())

That convert would return '2013-02-14 00:00:00' and the OrderTime of a day (lets say, today) ranges from '2013-02-14 00:00:00' to '2013-02-14 23:59:59'.

That WHERE would only returns orders from midnight, so it's not what we want!

If D is NOT missing a parameter by typo (like it was wrong intentionally), this question don't have a correct answer.

  • Feb 14, 2013
  • Chris
  • Belgium
  • Feb 13, 2013

Sistem is correct. Exam B Q16 answer is wrong.
1st. The supplied answer of D. does not event pass the parser as dateadd() expects 3 params, not 2. e.g. how many days do we add???

Even with the fixed syntax, the actual plan shows 51% vs 49% for answer A, thus D. is less optimal than A.

correct answer - A.

  • Feb 13, 2013
  • chris
  • Belgium
  • Feb 13, 2013

Question Exam A, Q33 - supplied answer is wrong.
Correct answer is C!
The answer given will not append but write in the beginning of the string.
Answer C appends to the end of the file as requested in the question

  • Feb 13, 2013
  • Asad
  • United States
  • Feb 12, 2013

Dump is valid :) thanks

  • Feb 12, 2013
  • Sistem
  • Italy
  • Feb 11, 2013

Exam B, question
..The business team wants a report that displays the total number of orders placed on the current day. You need to write a query that will return the correct results in the most efficient manner.

I think The correct answer is

SELECT COUNT(*) FROM SalesOrders
WHERE OrderTime = CONVERT(DATE, GETDATE())

Becouse is TODAY and it is most efficently

  • Feb 11, 2013
  • tamara t
  • Switzerland
  • Feb 10, 2013

the question from 12 to 21 they have no answers,
or is just for me is displayed so.
i am using VCM 3.0.1, please help

  • Feb 10, 2013
  • Jerry
  • United States
  • Feb 08, 2013

Just wondering, how are these dumps generated? How do you guys know that these questions will be on exams?

  • Feb 08, 2013
  • Fred
  • United States
  • Feb 07, 2013

Passed with 925. Be careful on the slight changes in questions like min/max.

  • Feb 07, 2013
  • shaz
  • Canada
  • Feb 03, 2013

Passed with 793 totally valid

  • Feb 03, 2013
  • someone
  • Netherlands
  • Feb 03, 2013

I believe the answer in question A-Q33 is wrong. However, I am 100% not sure!
SET Summary .WRITE (N' This is in a draft stage', 0, 0) will not append the text but rather overwrite the text.
I think the correct answer should be
SET Summary .WRITE (N' This is in a draft stage', NULL, 0) will not append the text but rather overwrite.

  • Feb 03, 2013
  • Kaushika Malik
  • United States
  • Jan 28, 2013

Dumps 100% Valid in India,
Might have some wrong answers as all the questions were from the Dumps.
Cleared the Exam with 887.
Thanks examcollection.com

  • Jan 28, 2013
  • Serka
  • Belgium
  • Jan 27, 2013

Cleared with 812 in Belgium. 44 questions. No new questions

  • Jan 27, 2013
  • joker
  • United States
  • Jan 20, 2013

Exam A 'This is in a draft stage' question is supposed to be appended to the end of the nvarchar(max) column so the correct syntax should be SET SUMMARY.WRITE(N' This is in a draft stage', NULL, 0) since the append happens when the @Offset parameter is set to NULL (not zero)

  • Jan 20, 2013
  • AF
  • Bahrain
  • Jan 14, 2013

Hello Guys,
I am in a process to certifiy MCSE on SQL 2012, Anybody is having 70-463,70-464,70-465 dumps, if anyone is having kindly share the dumps.

Thanks in advance to all techiee bros...

AF

  • Jan 14, 2013
  • brosnan_007
  • Saudi Arabia
  • Jan 10, 2013

Guys, Please type the questions and the right answers, don't reference question numbers as it seems every time you open the VCE the questions are randomly ordered.

Also, did any Pass with this Dump ?

Thanks,

  • Jan 10, 2013
  • Zico
  • Germany
  • Jan 10, 2013

Exam D, Question F4
CF is not working but AE
C passes two parameters but only one is expected in F

  • Jan 10, 2013
  • Zico
  • Germany
  • Jan 10, 2013

Sorry, but I have to correct my comment concerning Exam A, question F17. The Group By must be C.LastName. Otherwise the query would not be valid.

But I have another correction: The Order By must be
ORDER BY MAX(O.OrderDate) DESC

  • Jan 10, 2013
  • Zico
  • Germany
  • Jan 09, 2013

In Exam A, question F19 the RANK-clause must not include "PARTITION BY ProductCatalog.UnitPrice". Otherwise the PriceRank would be always 1.

So the solution would be:
SELECT ProductCatalog.CatID, ProductCatalog.CatName, ProductCatalog.ProductID, ProductCatalog.ProdName, ProductCatalog.UnitPrice, RANK() OVER(ORDER BY ProductCatalog.UnitPrice DESC) AS PriceRank
FROM Sales.ProductCatalog
ORDER BY ProductCatalog.UnitPrice DESC

  • Jan 09, 2013
  • Zico
  • Germany
  • Jan 09, 2013

In Exam A, question F17 - I think - the GROUP BY should be
GROUP BY C.CustomerID
Otherwise all customer with the same lastname would be aggregated. So the answer would be
SELECT C.LastName, MAX(O.OrderDate) AS MostRecentOrderDate
FROM Customer AS C INNER JOIN Orders AS O
ON C.customerID = O.customerID
GROUP BY C.CustomerID
ORDER BY O.OrderDate DESC

  • Jan 09, 2013
  • Denali
  • United Kingdom
  • Jan 07, 2013

cleared with 868, thank you all and especially 7thfreak

44 questions, all from this dump. options in different order

Good Luck

  • Jan 07, 2013
  • rob
  • United States
  • Jan 02, 2013

cleared with 868. Thanks guys.

  • Jan 02, 2013
  • JamesBond
  • India
  • Jan 01, 2013

Awesome dumps. Many thanks.
Cleared with 962.

  • Jan 01, 2013
  • Daniel
  • Japan
  • Dec 26, 2012

Cleared with 906. Dump is valid.

  • Dec 26, 2012
  • Alek
  • United Arab Emirates
  • Dec 25, 2012

Cleared the exam with 925 marks. Dump is valid.
But please read the questions carefully as there are slightly changes in questions like Min Vs Max.
Thanks for the dumps and please share 70-462

  • Dec 25, 2012
  • IdComTech
  • South Africa
  • Dec 24, 2012

Well done guys.....Can anyone please help with Exam 70-462 (Administering Microsoft SQL Server 2012 Databases) prep questions? Thank you a lot.

  • Dec 24, 2012
  • Rajesh
  • India
  • Dec 21, 2012

Passed the exam. Dump is valid.

  • Dec 21, 2012
  • Sattu
  • India
  • Dec 20, 2012

Yesterday 20/12/2012, I attended 70-461 and scored very very very good :)

Thanks for this Dumps:) Both dumps (available here) have same question so can go with any set.
Approximately 44 questions were there, and if you are preparing properly then exam will get over within 30 min..

Best of luck for the people for exam attendees:)

  • Dec 20, 2012
  • @allwhohavetaken
  • United Kingdom
  • Dec 17, 2012

how many questions in the exam?

  • Dec 17, 2012
  • FlambyMagique
  • Luxembourg
  • Dec 17, 2012

Some mistake but very useful for the Exam (same questions)

  • Dec 17, 2012
  • SuperSuji
  • United States
  • Dec 17, 2012

Around 60% from dump; Remaining were different questions / worded different. For the Rank functions, careful about the MIN instead of MAX.
And alas! In the exam, for two questions, the choices were completely wrong (No correct answers could be selected of those). Not sure whom to complan this.

  • Dec 17, 2012
  • @SuperSuji
  • United Arab Emirates
  • Dec 15, 2012

How was the exam ?, It was the same questions?. Have you used any other material or only this dump?

  • Dec 15, 2012
  • SuperSuji
  • United States
  • Dec 12, 2012

Cleared with 831;
Give me 70-462 please.. :-)

  • Dec 12, 2012
  • Rafal
  • Poland
  • Dec 11, 2012

What version of vce are you using? Try to use the most recent.

  • Dec 11, 2012
  • Silverc0p
  • Spain
  • Dec 09, 2012

i cannot open this file, i tried in in windows 7

  • Dec 09, 2012
  • maetel
  • Italy
  • Dec 08, 2012

Passed with 961.
Pay attention because questions/answers sometimes are slightly different - e.g. "Duplicates must be retained" vs "Duplicates must NOT be retained" - so the correct answer obviously changes

  • Dec 08, 2012
  • Reload
  • Ukraine
  • Dec 05, 2012

I pass this exam tomorrow :) Damp valid 90%

  • Dec 05, 2012
  • ФИО
  • Ukraine
  • Nov 26, 2012

There is some mistake in Exam B, 16th question.
to filter out current date, you should use smth like this:
WHERE CONVERT(date, OrderDate) = CONVERT (date, GETDATE())
or this (but bad code)
WHERE CONVERT(varchar, GETDATE(), 112) = CONVERT(varchar, GETDATE(), 112).
All the variants provided are close, but syntax is crashing.

  • Nov 26, 2012
  • 7thfreak
  • India
  • Nov 26, 2012

Cleared with 962.
1 New question in the EmpID-EmpNum-ReportsToID series.
Q: Which column should be set as Self-Referential-Foreign-Key.
Ans: ReportsToID

  • Nov 26, 2012

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

Winter 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

Winter Sale: 20% OFF!

Use Discount Code:

WINTER20

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.