Get 100% Real Exam Questions, Accurate & Verified Answers By IT Experts
Fast Updates & Instant Download!
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: | 3 |
Free Download: | This file is outdated. Browse other 70-461 VCE Files |
Microsoft 70-461 Video Course
Top Microsoft Certification Exams
Site Search:
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.
Log into your ExamCollection Account
Please Log In to download VCE file or view Training Course
Only registered Examcollection.com members can download vce files or view training courses.
SPECIAL OFFER: GET 10% OFF
Pass your Exam with ExamCollection's PREMIUM files!
SPECIAL OFFER: GET 10% OFF
Use Discount Code:
MIN10OFF
A confirmation link was sent to your e-mail.
Please check your mailbox for a message from support@examcollection.com and follow the directions.
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.
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?
Still valid in Holland. and this file can be opened with the old certexam software.
I am going to appear the exam on next month.Is it valid now on india.
Hi Guys,
I am plaaning to appear for this exam in next 2 months. Could you please tell me still this dump is valid?
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.
hey thanks,passed with 962 marks on 27/5/2013,this dump is still valid.
What does the code cannot have object delimiters mean?
Exam A is having 43 questions.
Exam B - 38 Questions
Exam c - 10 Questions
Exam D - 4 Questions
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
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
Valid dump. Passed in Australia with 9xx
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 ?
Valid, with minor changes, in the Netherlands [17-05-2013]. Passed with 9XX
Passd for the second time with 9xx on april
Valid in Netherlands and passed with good score. Keep up the good work!!
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!!
best and valid passed with 925
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)
dump still valid, I got certified on Friday.
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
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.
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.
Thank you so much.
Passed today with 981
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!!!
Valid in india. Cleared today with 962.
Dear Medo make sure that you a full version of VCE Manager - Not Trial -
still valid in nigeria
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
Passed with 925.
Valid
Good Luck
Valid. Thanks!
1st time writing any certification, and this is the 1st exam I'm writing.
any help , Tips is highly appreciated. writing 3rd may
passed with 925 thnx
Passed today with 925. Dump is valid
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.
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
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
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
@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.
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!
@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.
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
Passed on 18.4.2013, exam still valid. 3 questions were different
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?
Exam C, Q1: Minimum permissions to delete suppliers
Correct answer: D
and for your information : Numeric and Decimal are same .
Passed with 800 Pts in Germany with sketchy learning.
Some questions vary with details like min/max changed, but overall valid.
Valid for Ecuador, passed today with 925. There is a new questions based on some things of this dump
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 .?
Wrote this exam today, 925 - Dump is valid
Passed today with 962 score.This dump is 98% valid .
There were no question relating to writing query
I second @staretzu.
Damn, not sure why it's not picking up my country which, by the way, is Romania.
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
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.
@MCP were there any question tio qrite manually query?which answer of question changed?
Passed with 900 + Marks .
Exam was 95% valid. one answer was changed.
This is valid. Sat today in the UK passed with over 900
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
Exam A, Q4. Correct answer is D however there is a misspell: Orders.CustomerXd but it should be Orders.CustomerId.
still legit
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
Valid in south africa, wrote today and passed....goodluck
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 :)
Where can i found Exam B, C & D?
Does questions repeat when u have your second shot or they are the same?
Thank u.
Still valid in Bulgaria. Pass today . 921
Still valid today in Paris, no new questions.
Merci :)
still valid in austria. Passed with 850. No need for typing queries as answers
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.
Passed Today with 906.
There was no Need to Type in Answers manually.
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
Passed 9xx , this is valid , thanks alot
Passed. Very good study material. Thanks a lot!
Valid and passed with good score
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.
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.
It is valid, passed today
Focus on Exam B, C & D
It is valid, passed today with 925/1000
Thank you very much
Also valid in France
There are some new questions, but still valid.
Absolutely valid in India - cleared with 900+
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
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 ?
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 ?
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
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
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.
Still absolutely valid in South Africa. Completed this exam today with 981. I honestly do not know which question I got wrong :(
Valid, passed today with 943
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.
Valid..
So I wrote yesterday, 11 March. Still valid. Thanks a bunch!
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/
Hey guys. Wanna ask, do they really ask you to type in code in the actual exam? Thanks.
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
Valid in Spain. Some questions are not exactly the same, pay attention and read carefully.
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!
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
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
dump is still valid
dump still valid. min new ques. thx
I'm taking the test on in 2 days. I'll report back on my experience.
It's still work. Cleared with 887 point
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)
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.)
@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.
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.)
dump 100% valid
ssome new questions but still valid
Passed today. Some new questions have been added. Also the ReportoID was in my exam
Passed today with 925/1000, Same questions
@certfreak so you're saying the questions have changed slightly?
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.
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.
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.
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?
@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.
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.
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
Dump is valid :) thanks
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
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
Just wondering, how are these dumps generated? How do you guys know that these questions will be on exams?
Passed with 925. Be careful on the slight changes in questions like min/max.
Passed with 793 totally valid
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.
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
Cleared with 812 in Belgium. 44 questions. No new questions
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)
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
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,
Exam D, Question F4
CF is not working but AE
C passes two parameters but only one is expected in F
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
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
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
cleared with 868, thank you all and especially 7thfreak
44 questions, all from this dump. options in different order
Good Luck
cleared with 868. Thanks guys.
Awesome dumps. Many thanks.
Cleared with 962.
Cleared with 906. Dump is valid.
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
Well done guys.....Can anyone please help with Exam 70-462 (Administering Microsoft SQL Server 2012 Databases) prep questions? Thank you a lot.
Passed the exam. Dump is valid.
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:)
how many questions in the exam?
Some mistake but very useful for the Exam (same questions)
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.
How was the exam ?, It was the same questions?. Have you used any other material or only this dump?
Cleared with 831;
Give me 70-462 please.. :-)
What version of vce are you using? Try to use the most recent.
i cannot open this file, i tried in in windows 7
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
I pass this exam tomorrow :) Damp valid 90%
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.
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
Add Comments