Pass Your Microsoft 70-457 Exam Easy!

Exam A Q33 correct answer is C in my opinion.
It states that the string has to be appended to the column.
Script in D would add the string to the beginning not the end of the column.

Thanks. Did study the whole toolkit but the real questions were valuable. The questions are being updated and different variations of questions occur so knowledge of the content is still needed.

Passed the exam 833&900 using this dump about 3~5 new question.
this dump is more then enough!!

Hello all, there are 2 same question with different answer, i mean Q13 of Exam B and Q36 of exam A, Which are correct of
A) SELECT Territory, Year, Profit,
LAG(Profit,1,0) OVER (PARTITION BY Territory Order by Year) as PrevProfit FROM Profit . OR
B) SELECT Territory, Year, Profit,
LEAD(Profit,1,0) OVER (PARTITION BY Territory Order by Year) as PrevProfit FROM Profit. ??
----------
Thanks for your answers.
The previous was incorrect

Hello all, there are 2 same question with different answer, i mean Q13 of Exam A and Q36 of exam B, the correct query is
A) SELECT Territory, Year, Profit,
LAG(Profit,1,0) OVER (PARTITION BY Territory Order by Year) as PrevProfit FROM Profit . OR
B) SELECT Territory, Year, Profit,
LEAD(Profit,1,0) OVER (PARTITION BY Territory Order by Year) as PrevProfit FROM Profit.
----------
Thanks for your answers.

Passed from a week ago with 733 for part 1 (querying) and 866 for part 2 Administration) , some Querying questions (part 1) are out of the dump, you should not study this dump based on memorizing the answer's letters and order because the choices order is not similar to the order in the dump.

The exam is two parts, the first one is related to Querying topics and the second one is related to the Administration ones, the Administration part answers are more accurate than the development ones, also all Administration questions are from the dump.

Thanks for Derek and AnotherInbox :) :)

Hi Guys,
I have a quick question,
I have DBA certification in 2005 and 2008, to become DBA in 2012 how many exams.what are the exams?

Thank you

i passed the exam few days ago. this dump is more then enough. All the question came from this dump. Good luck to every one

Exam B, Q3: the answer with WHERE .. AND.. (D) is correct because it is the most susceptible to use the non-clustered index on the PurchaseTime column. The one with WHERE CONVERT .. = CONVERT .. will not use the index, because the WHERE predicate is not a search argument (SARG), i.e. it manipulates the filter column.

I mean Q38, EXAM A

Q.38 I think answer should be F, transactional replication. This is the only one that provide a secondary database that is accessible for reporting, has minimum latency and allows supplementary indexes to be created. AlwaysOn availability group secondary replicas are read-only, so any of the options that mentions them will produce strictly read-only databases, so no indexes other than what already exists in the primary DB will be possible.

70-457
Exam A is based on 70-461 SQL Server 2012 Querying Database
Exam B is based on 70-462 SQL Server 2012 Administartion
70-458
Exam A is based on 70-462 SQL Server 2012 Administartion
Exam B is based on 70-463 SSIS 2012
70-457
Each exam is of 80 minutes - 25 Questions
Exam A and B of Azads reorganized dump is more important.
But should study other sections too for be on safer side.
There is no absolute short cut to any exam.
You need to know the concepts very well.
Before giving exam go to the links provided and have proper understanding.
Few answers are definitely incorrect.
Check for comments by other candidates.
Also be ready for new questions or variations.
Do not memorize answers or oreder of answers.
Relate answer to the requirements in the question.
Books on Exam 70-461 and 70-462 are already out.
Book on Exam 70-463 is releasing on 70-463.

Thanks for the great effort in this dump, but i think the answer of question 28 in Exam A is incorrect, the question is related to the CTE (Common table expression) and the correct answer is B not A

I used the dump for 70-462 exam. 100% valid in Australia. Thanks for the great job.

Still valid, but many new questions. Especially in the query part of the exam! You may fail that part if you only learned the dump.

In reponse to Myself's question:

Yes, I passed using this dump alone.

Approx 9 questions appeared in the exam I took that were either new or were worded differently.

Raji, Congratulations on passing.

This dump has A to E exams, wich one one would you say has the most questions that showed on the exam?

Hi

I have cleared the exam today, 50 Questions was asked (Part1 - 25q and Part2 25q), I studied only this dump and I cleared with 83.3% on Part1 and 90% on Part2.

Propa Spaz, did you pass using this dump? You said 9 questions were new, is that correct?

18 should be: DECLARE @XML1 XML (Sales.InvoiceSchema)

@Cibek: Yes I think you have to put in a query in the real exam. Certexam maybe does not support that, therefore i may look a little bit weird.

I've got a question,
I face question like Exam A Q19 or Exam A Q20, Appear just option A, and in the answer the correct query, I think in that case, we must to write the correct query right?? In the real Exam do we face question like that? Or all answers should be a, b, c,,, ??
Thanks a lot for help.

Exam A Q17
Proposed solution is
SELECT.. FROM Customers INNER JOIN Orders.. ORDER BY OrderDate.
I created the tables and added some data and this query returns all combinations Order-Customer rather than one line per customer
So I propose.
SELECT LastName, MAX (OrderDate) AS MostRecentOrderDate
FROM Orders AS O
JOIN Customers AS C
ON O.CustomerID = C.CustomerID
GROUP BY LastName

exam C q44 -> May be I am misunderstandig the word, but "Duplicates must be retained" cries for an UNION ALL insted of UNION, doesn't it?

Passed the exam today.

There were at least 9 questions that were "unfamiliar", i.e. either new questions not in this dump or questions from the dump that were phrased/worded differently.

Exam C Q45
format (fixed length), locale(US date) , unicode
@propa text says "the first row of the file contains the first row of data" so no columns on the first row

Exam D, Q28. SQL Browsers is required in many cases related to namedinstances. Maybe if you type in the serverinstance name in the MD conf. manager it works, my vote would go to browser service. In other words the answer is correct imo.

Exam D, Q28.

Application unable to connect to database on a named instance.

Answer is either:

Start the Browser Service or
Use the Master Data Services Configuration Manager to configure the application.

I would favour "Master Data Services Config mgr"

Anyone agree/disagree?

Exam C, Q45
SQL Server Import Export wizard - Choose destination window.
No answer given to question but I would assume answer would be:
- click the unicode check box &
- click the column names in the first data row heckbox.

Anyone agree/disagree?

Exam A, Q14
requires: the view must prevent the underlying structure from being changed (solved with schemabinding)
requires: must be resolved no matter the user's schema (solved with two part naming)
Solution in the dump:
create view as select.. from table
My proposition
CREATE VIEW Sales.uv_CustomerFullName
WITH SCHEMABINDING
AS
SELECT FirstName, LastName
FROM Sales.Customers
--assuming customers is in sales

I agree on Exam A, Q28, the correct answer is b, not a. You HAVE to consider the datecolumns (from cte and targettable) and this has to be done in the correct way if you want to keep the correct rows.

Exam C, Q44
Two tables Div1Cust & Div2Cust. None of the rows in Div1Cust exist in Div2Cust.
Answer given uses "UNION" but "UNION ALL" executes more efficient and, because rows in both tables are unique anyway, UNION ALL would return same result as the UNION clause.
So wouldn't UNION ALL be a better choice than UNION?

Exam C, Q34.

Answer "SET FORCEPLAN ON" does not tie up with the actual question.

Anyone agree/disagree?

I am not certified in SQL 2008.
But, I want to get certified in SQL 2012 (BI).
I am aware I need to start with 70-461 and then 70-462 and 70-463
Can someone please guide me on the materials for 70-461, 70-462 and 70-463?

Exam A, Q 36. Profits table with columns Territory, Year & Profit.

I think the answer should use "LAG(Profit, 1, 0) OVER(PARTITION BY Territory ORDER BY Year)"
and not "LEAD(Profit, 1, 0) OVER(PARTITION BY Territory ORDER BY Year)",
as need todisplay profits for preceding years as well.

Anyone agree/disagree?

Exam A Q13 says "write results to the disk"
Proposed solution is
CREATE TABLE(.,LineItemTotal AS (ListPrice * Quantity))
My sugestion would be
CREATE TABLE(.,LineItemTotal AS (ListPrice * Quantity) PERSISTED)

The question with orderdetails/customers/orders, requires to write a sp to return all order ids AFTER a specific date, takes a varchar which is not correctly compared.
Answer is
SELECT . WHERE Orders.OrderDate > CONVERT (datetime, @Parameter1
This means and order placed during that specified date will be returned.
I would go with
SELECT . WHERE Orders.OrderDate >= DATEADD (d, 1, CONVERT (datetime, @Parameter1))
I would appreciate any comments on this issue.

@Spanish:
i think so.
Question 28 (Exam A, Q28)
Answer: "A" is wrong
I think that the "B" answer is correct
because you have to retain the only newest products

Question 28 (Exam A, Q28)
Answer: "A" is wrong
I think that the "B" answer is correct

Passed the exam 883/1000 using this dump and MSDN 2 new questions.

Question You need to create a view named uv_CustomerFullName ..
..The view must prevent the underlying structure of the customer table from being changed.
You need to add the expression "with schema binding" to be compliant with the answers.

@raj raji:
Yes, you have to purchase the software. I would recommend purchasing the package that gets you both the Manager and the Designer.

http://www.avanset.com/products/visual-certexam-suite.html

Then you'll be able to see all questions (with the Manager)and even be able to add to them, fix them, and offer feedback on them (with the Designer).

Hi

Do I need to buy the latest version of certexam software, because the once I download from this website seems to be trail version and I can see only 5 questions.

Please help sooryakumar@yahoo.com

Exam passed with 883. Thanx

Works fine here :) Thanks!

@Anotherinbox, works for me.

@raj raji:
I just downloaded and tested this file and it works in the 3.0.1 version of CertExam, which is the most current version. You need to download the latest version of the certexam software.

Is anyone else having trouble with this?

I was able to pass the exam using this dump. At this point, I'm finished modifying it, so it will be up to you guys to continue the updates. Have fun and good luck!