| Author |
Topic |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2008-04-01 : 07:35:54
|
| Can anyone tell me how many questions there are in the exam and what the pass rate is please.Also can anyone tell me the nature of the questions that are asked or anything else that might help please.Kind RegardsRob |
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-04-01 : 08:06:08
|
| Thank you nrif anyone else has any helpfull information i would be very greatfulI am hoping to take my exam in the middle of the year |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-01 : 08:12:16
|
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx
E 12°55'05.25"N 56°04'39.16" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-04-01 : 09:33:26
|
| http://weblogs.sqlteam.com/mladenp/archive/2007/05/10/60199.aspx_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-01 : 09:50:33
|
| I recently took it. It had first section of 40 questions which is purely objective type and second section consisting of 12 simulations. The total time for exam was 2 hrs 45 mins. Simulation was mostly dealing with usage of management studio. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-04-01 : 10:28:18
|
| Hello visakh16How did you get on, did you pass?what subjects would you say it mostly focused on? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-01 : 10:39:41
|
| I passed with 88% marks. The objective portion had questions from installation of SQL server,upgradation,configuring mirroring,logshipping,... I think you can buy self paced training kit from MS to help you on this. The simulations were mostly performing simple configuration operations on SSMS like creating index, adding user roles,schemas,Analysing views,...If you have a good understanding of SSMS and its various uses then this will be really easy. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-04-01 : 10:46:19
|
| Thank you,I have the self study book and have been going through it for some time now, i have just started on XML (not nice) Im hoping to take the exam june - july. I am understanding everything i read and practice, just want to be ready. I have been looking for a trainee job, do you think the MCTS will make me more of a good candidate for a job, do companys look at MCTS certs? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-01 : 11:06:02
|
Hard to tell. I think MCITP is more appealing.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-04-01 : 11:09:37
|
| Well that is what i plan to do next, but admin side, not developer. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-01 : 11:21:04
|
Anyway, MCITP is not possible without giving 70-431  Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-04-01 : 11:26:36
|
| I am doing the MCTS at the momment after doing some SQL 2000 Exams moved onto this one, I am also going to carry on to the MCITP after gaining the 70-431...but so far it doesn't seem that bad I do believe that its 40 multi choice questions and then 12 sims in SSMS 70% pass rate neededGood luck anyway. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-04-01 : 11:26:41
|
| LOLthats why im taking the MCTS firstThanks for the advise tho |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-04-01 : 11:27:58
|
| thank you Neil.Do you think companys look at candidates with MCTS? |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2008-04-01 : 12:15:28
|
| Yep for definate, I am in a company now working as an Analyst using SQL, Excel but I was taken on because I was doing the exams, and will be moving onto a Junior position after completing the MCTS , the MCITP is a good way to get into a junior position as it shows at least you have a good knowledge about the same as someone with a years experience.I know one thing for sure dependent on the company, but alot of people like the fact that you are showing willing to improve your skills etc in your own time and your own choice not just because the company is going to pay for them |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-04-01 : 12:18:27
|
| where do you work? London? |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2008-04-01 : 12:24:52
|
| No just checked. you live miles away LOL |
|
|
|
sqlupid
Starting Member
4 Posts |
Posted - 2008-06-12 : 18:39:03
|
| HiIve just got the Microsoft 70-431 book and after doing a few exercises im a bit worried. Im a 100% complete newbie to sql and all the scripting scares the hell out of me, is there much of this in the exam? Im hopeing most things can be done in the SSMS with a few clicks if i have to remember all them scripts i might as well give in now :-(, |
|
|
|
|
MCTS 70-431 Help