Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

How many tests do I need for 2012 after I get my MCITP Expand / Collapse
Author
Message
Posted Thursday, June 20, 2013 7:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:40 PM
Points: 7, Visits: 55
OK, I'm desperate to figure out how many exams I have to take after I finish the SQL 2008 exams for Database Administration. Once I get my MCITP in SQL 2008 do I have to take 1 2012 exam or 3? Boy oh boy, I'm really hoping it's only 1...

Waiting with baited breath...
Post #1466017
Posted Friday, June 21, 2013 12:52 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:15 PM
Points: 43,017, Visits: 36,179
Easiest thing, go look at the Microsoft exam certification page where they describe all the exams, list all the exam paths and all the certifications.

I think it's 3, but I'm not looking at the site and could be thinking of some other upgrade.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1466067
Posted Friday, June 21, 2013 9:46 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 93, Visits: 585
Wow, I'm really bummed. Sure looks like it's 3 more exams after finishing the 2008 MCITP. Below is the upgrade path for the SQL 2008 DBA cert. I'm still going to work hard to pass the 70-450 but it doesn't reduce the total number of exams I have to take. Drinking a skinny mocha to dull the pain...

http://www.microsoft.com/learning/en/us/sql-certification.aspx#fbid=-30rJSRheqE
If you have an MCITP: Database Administrator or MCITP: Database Developer certification, you can upgrade to the MCSE: Data Platform certification.
Step
Title
Required exam
Certification earned

1
Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
457
2
Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 2
458
3
Transition Your MCITP on SQL Server 2008 to MCSE: Data Platform
459

Post #1466267
Posted Friday, July 19, 2013 4:16 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 2:55 AM
Points: 3,352, Visits: 1,482
Hi Elizabeth

I know this post is a month old so you may have started taking the tests already, but I've just completed the last of the three upgrade exams, so thought I'd chip in.

As you've said, the three exams you need are 70-457, 70-458 and 70-459. Of the three, I found 70-458 by far the most challenging as it required some quite in-depth studying of SSIS which I had relatively little experience with. The other two were ok, and didn't require much as much study.

You can get most of the information from the Microsoft Learning website, but essentially the exams cover:
70-457 - Admin, Querying
70-458 - Admin, SSIS/Master Data Services/Data Quality Services/Data Warehousing
70-459 - Admin, Development

I used the three Microsoft MCSA books for studying, and went through all the examples for the "Implementing a Data Warehouse" book. For the other two books I read through most of the Querying book (mostly because I found it quite an enjoyable read!) and skim-read the Admin book, focussing on the bits that were new to SQL 2012 - e.g. AlwaysOn. According to the Microsoft Learning website, most of the 70-459 exam content seemed to be covered by the Querying and Admin books, so I just used those plus Books Online for any bits that weren't covered. In any case, if you read the Skills Measured you'll see that exam is more about the application of knowledge than the knowledge itself, so that's where on-the-job experience and general reading around the subject will help enormously.

I must say, I've enjoyed the whole process of studying for these exams, and learned quite a few new things along the way - which is why I force myself to go through this process every few years (roll on SQL 2014!). I thought the study books were all well-written and the exams were very fair in the sorts of questions they asked.

So good luck, and I hope you do well. Any help I can give you without breaking NDAs, I'm happy to give, so ask if you've got any more questions.

Duncan
Post #1475357
Posted Monday, July 22, 2013 6:01 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 93, Visits: 585
Duncan, thanks for the great information! I appreciate your input. Have you used any practice tests? I've used the ones from CBT Nuggets, which were way too easy and also Measure Up, which were much closer to the test questions. When I start studying for the 2012 certs I'm planning on using Measure Up.
Happy Studying!
Post #1476317
Posted Tuesday, July 23, 2013 2:37 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 2:55 AM
Points: 3,352, Visits: 1,482
Hi Elizabeth

I just used the book questions, which were ok for making sure I'd learnt everything but not for exam practice. However, I've done so many of these exams now that I kind of know what sort of questions to expect if you see what I mean, so practice exams aren't as important as they used to be.

I used to use Transcender back when I was doing the 2005 certs and those I found excellent but Transcender don't seem to do the full suite of SQL exams now. If you've found MeasureUp to be good, I'd stick with them - and particularly for the Data Warehouse stuff if you don't use it every day. You may not need it for the other two sections. However, bear in mind also that Admin is part of both exams, so as long as you're strong in that area you can probably get away with being less strong elsewhere.

As I said, I didn't find any of the exams too tricky after having done the full progression from MCDBA through 2005 and 2008, and if you're doing the upgrades you're probably in a similar position. Just focus on revising the things you did for previous exams and spending a bit more time on new SQL 2012 features.

Duncan
Post #1476412
Posted Tuesday, July 23, 2013 9:14 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 93, Visits: 585
Thanks, Duncan, all very good advice. I'm just starting on the certification path and have found the exams really hard. I'm still trying to figure out my best method for studying. Thanks again!
Post #1476645
Posted Tuesday, July 23, 2013 12:12 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 2:55 AM
Points: 3,352, Visits: 1,482
Hi

So which exams have you done so far? Are you still working on the 2008 ones?

If you've got a few to take and are not in a hurry, there's always the chance that Microsoft will reintroduce the second shot campaign. The last one finished in May, but it's always worth keeping an eye open as it makes taking the exams a lot less stressful!
Post #1476740
Posted Tuesday, July 23, 2013 12:20 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 12:22 PM
Points: 93, Visits: 585
Hi Duncan,

I've passed the 70-432 so I have a MSTS. I recently took the 70-450 and failed it by one question, which was extremely frustrating. If there was more time to retake the 70-450 I would definitely take it again. I've learned so much about 2008, so that's a plus.

I need to ramp up on SQL 2012 and BI so I'm going to work on learning the new features. I'll probably wait awhile for my next exams because we're trying to ramp up on BI and don't know much about that.

Thanks for all your input!
Elizabeth
Post #1476747
Posted Wednesday, July 24, 2013 2:20 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 2:55 AM
Points: 3,352, Visits: 1,482
Hi Elizabeth

According to the Microsoft Learning website 70-450 will be retired in January next year, which does give you a bit of time yet. The dilemma would therefore be whether you want to retake that one and do 3 more to get the MCSE, or whether you want to do the straight 2012 exams - 3 for MCSA and 2 more for MCSE. If you're moving to BI though, you may want to get the BI MCSE rather than the data platform one, which changes things again!

However, people I know who have retaken exams have generally passed second time - in large part because they get many of the same questions again and have gone away and worked out what the answers should be. So it may not be bad idea to retake 70-450 as a confidence-booster.

Good luck, whatever you decide.

Duncan
Post #1476916
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse