sql server 2005 certification

Question

sql server 2005 certification

akaragiannis1979

SSC Enthusiast

Points: 125
More actions
December 17, 2008 at 12:43 am

#199008

Hello
Currently i did a seminar in SQL SERVER 2005 (Implementing a Microsoft SQL Server 2005 Database) and i am thinking to try for the Microsoft certification. I would be grateful if someone could give me some suggestions on how to pass the exam. A friend told me that some tests from Test King may be helpful. If any one has wrote the exam and have any suggestions please leave a comment.
Also if someone knows any good books that would be helpful for the exam please let me know
Thank you

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply

akaragiannis1979 SSC Enthusiast Points: 125 More actions · Answer 1

Thank you for your response. I am interesting for the microsoft sql server 2005 certification because the training course i took was based on sql server 2005. I think that the exam for the certification is the 70-431.

You said that there are many sites like Testking that can help me with the exam. I know that in order to take an exam from Testking you have to pay. Do you know any other sites that are free and are also helpful for the exam?

Also if you know about any books that are helpful please recommend. I ve learned that the self paced training toolkit of microsoft is a good book. Do you have any comments on that?

brainy SSCrazy Points: 2445 More actions · Answer 2

Sorry... I dont know any sites where you can get free exam. I feel you if you search on internet you may get some information on that.

I have also seen, many site are there where we need to pay for that to take exam simulation.

Mr James Howard Ten Centuries Points: 1158 More actions · Answer 3

I passed that one about 12 months ago... if its the same then the exam is split with multiple choice and scenario based questions so you will need to know your way around SSMS. Personally, I pasted the entire exam syllabus into a project plan and worked through the topics in books online, ticking them off when I felt confident with the subject. Microsoft had a 'second-chance' offer at the time so I figured if I was to fail it wouldnt cost me to sit it again. Thankfully I didnt need to in the end.

James Howard

mahamed_elsirty Grasshopper Points: 15 More actions · Answer 4

I PASSED EXAM 70-431 SINCE 2 WEEK

if you want to get high score study from pass4sure i upload the exame for u this version is still valid i study from this version and my score is 1940/2000

Editor's Note: URL Removed

note

if u want to exame take it before 25 decmber

good luck

because prometric is closed from 25 to 15 jan

akaragiannis1979 SSC Enthusiast Points: 125 More actions · Answer 5

Thanks for the tip my friend. In your mail you wrote that if i want to pass the exam i can use tests from the Pass4sure. I dont know if i can catch up with the exam until 25 of december. My opinion is that i want to spend some time learning some things about sql server 2005 and then try to take the exam. I also found a good book from microsoft that has lots of practices for sql server 2005.

I heard that TestKing also sells tests for the certification but i heard some rumors that questions from TestKing are not always the actual questions in the certification.

I would like to ask you (if you know of course) if Pass4Sure has the updated tests for the certification each time that you buy the test from them.

Anyway i am grateful for your help

akaragiannis1979 SSC Enthusiast Points: 125 More actions · Answer 6

Also you mention something about prometric that is from 25 of decsmber to 15 of jan. What is that?Can you you give me some more details?

Thank you

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 7

mahamed_elsirty (12/18/2008)
i upload the exame for u this version is still valid
study this pass4sure good

This site does not permit the posting of links to brain dumps or copyrighted materials

Pleas be aware that Pass4Sure, testking and many others are brain dumps - questions copied from the exams in violation of the NDA on those exams and distributed illegally. Using them or supplying them can result in all your certifications been revoked, permanently. In addition, trying to obtain the exact questions that you will be asked is cheating.

This site is a good one to check the validity of test material - http://www.certguard.com/

The Self-paced training kit from Microsoft Press is a very good resource.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

D.Oc SSCrazy Points: 2875 More actions · Answer 8

Because of Pass4Sure, testking and other brain dumps this certs doesnt worth much anymore.

Hope that MS put some limitations to this certs, as you can take exam if you have some number of years of experience in working on SQL Server, with some proof of that, of course.

But I really doubt MS would do this bcos it brings them money, a lot of money.

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

Domagoj Orec (12/21/2008)
as you can take exam if you have some number of years of experience in working on SQL Server, with some proof of that, of course.

How would you prove that in a way that it can't be faked or lied about, without adding so much admin overhead to the exams that they take thousands of dollars to write? (like the MS Master cert)

I guess I should hand some of my certs back. I wrote 2 Sharepoint exams with only a couple months of playing with the product.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

D.Oc SSCrazy Points: 2875 More actions · Answer 10

GilaMonster (12/21/2008)
Domagoj Orec (12/21/2008)
as you can take exam if you have some number of years of experience in working on SQL Server, with some proof of that, of course.
How would you prove that in a way that it can't be faked or lied about, without adding so much admin overhead to the exams that they take thousands of dollars to write? (like the MS Master cert)
I guess I should hand some of my certs back. I wrote 2 Sharepoint exams with only a couple months of playing with the product.

That is right, Master cert is gr8 example, same as CISA and CISSP certs.

c/p from CISSP Requirements: "Attest to the truth of their assertions regarding professional experience and accept the CISSP Code of Ethics"

I didn't say you should hand certs back :w00t:

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 11

Domagoj Orec (12/21/2008)
That is right, Master cert is gr8 example

Yeah, but the Master cert is $20,000 and aimed at a very small percentage of IT people. What can be done with a course and exams that maybe 100 people are going to take per year is not feasible for exams that thousands are writing.

The Master cert includes 3 weeks (I think) of classroom training, before the exams. In 3 weeks trainers can easily see if anyone lied about their experience.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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

D.Oc SSCrazy Points: 2875 More actions · Answer 12

GilaMonster (12/21/2008)
Domagoj Orec (12/21/2008)
That is right, Master cert is gr8 example
Yeah, but the Master cert is $20,000 and aimed at a very small percentage of IT people. What can be done with a course and exams that maybe 100 people are going to take per year is not feasible for exams that thousands are writing.
The Master cert includes 3 weeks (I think) of classroom training, before the exams. In 3 weeks trainers can easily see if anyone lied about their experience.

Ok, Master exam is well Master 🙂

leave the money out of the equation for MCITP 😀

-------------------------------------------------------------
"It takes 15 minutes to learn the game and a lifetime to master"
"Share your knowledge. It's a way to achieve immortality."

maechismo_8514 SSCoach Points: 17510 More actions · Answer 13

I need to pass only one exam to get my MCITP.

Its a lot of struggle to get through these exams. First thing be prepared to study atleast 3 to 4 books for each exam. From the time I decided to sit for these exams I have been living in SQL 2005.

I believe forums and community websites are a big assets to broaden your knowledge on a subject. These gives you various ways to deal with a problem and number of resources to expand your knowledge. For the 70-431 I had to prepare for 3 months since it was my first exam and was not aware of the exam model.

Books I would recommend for 70-431:

MS- Self Paced Training Kit( not that good for this exam)

Tata Mc Graw hill- all in one MCITP exam kit(Excellent)

SQL server 2005- T-SQL recipes(Excellent)

And Practice a lot in SSMS as you read through these books.

cheers !!

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 14

Krishna_DBA (12/21/2008)
Yes, using Testking, Pass4sure are brain dumps and it is not advisable to go through them unless you are confident that you have practiced a lot and grasped the subject.

Sorry, but you shouldn't be using them at all, regardless of your experience with the subject. Saying you only cheated because you know the subject well is not an excuse.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
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