September 8, 2008 at 3:35 am
Hi evreyone
This is the request to all of you who have passed and studying for the certification exam 70-445. I have a training kit but i want sample important questions with answers which will give better idea and more vigilance while doing preparations!
if any one has such , can you please provide them to me , I will be highly grateful !
Thanks
-Meghna
September 18, 2008 at 9:30 am
The training kit should give you an idea of the types of questions and perhaps someone will chime in.
Exact questions and potential answers, should not be posted as that violates the NDA of the exam.
September 18, 2008 at 9:45 am
Transcender and MeasureUp are both good. Not cheap though.
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
September 19, 2008 at 5:01 am
I prefer Transcendor myself. Plus Microsoft's website for certification usually has a 10 question "sample" you can look at.
If you get more cert study books, aside from the training Kit, those also usually have a practice test or a set of questions on a CD/DVD that you can install on your PC and play with, but they're usually more multiple choice then actual Sim / Case Study style.
September 19, 2008 at 5:12 am
i started studying and that training kit seems interesting , it covers most of the core concepts which is only required to clear this exam!
try that folks!
October 9, 2008 at 3:04 am
I wouldn't go personally for Transcender - expensive and far away from the point....:angry:
October 9, 2008 at 4:07 am
Far away from the point??? What do you mean?
October 9, 2008 at 9:49 pm
As a side bar, this is why I hate certifications. They mean nothing because you can get the answers to most of the questions one way or the other and some (many, apparently) would rather spend the time memorizing the answers than learning the skill. 😉
I've had two certified DBA's where if practical knowledge about SQL Server and-T-SQL were gasoline, they wouldn't have enough to run a sugar-ant's mini-bike through a matchbox. Yes, there are some good ones with certifications... but they probably would have been good even without the certification because they practice their trade instead of book-memorization.
It generally takes me 2 to 4 questions when I'm interviewing someone to figure out if they've ever done anything worthwhile in SQL Server more than being in the same room with a study guide. They're not difficult questions, either. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
October 10, 2008 at 5:31 am
Oh, yes. I've been on the interviewer side of the table myself. It makes me appreciate that I was smart enough to build myself a SOHO and actually work things through when I was studying for my certs.
Of course, coming from a retail background, I had a lot more to prove than a lot of people who were already in IT. @=)
I've actually stumped people with simple backup & restore questions of all things. You'd think *that* particular subject matter would be basic to everyone's DBA knowledge.
October 10, 2008 at 7:04 am
Brandie Tarvin (10/10/2008)
I've actually stumped people with simple backup & restore questions of all things. You'd think *that* particular subject matter would be basic to everyone's DBA knowledge.
Oh, please... Just take a look at all the backup/restore questions we get here
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
October 10, 2008 at 7:12 am
True enough. @=)
October 23, 2008 at 1:26 pm
Jeff Moden, would you be kind enough to put here your those FEW INTERVIEW QUESTIONS?
Just wanted to check my own capability.
Thanks,
Usman
October 23, 2008 at 1:50 pm
Brandie Tarvin (10/10/2008)
I've actually stumped people with simple backup & restore questions of all things. You'd think *that* particular subject matter would be basic to everyone's DBA knowledge.
You could probably stump me with them :w00t:. That's because I am a DB Consultant, and not a DBA most of the time: I rarely have to get my hands dirty with the everyday operational tasks.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 23, 2008 at 8:56 pm
Heh... no... if I posted the questions here, they'd be no better than certification exams. Sorry.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 24, 2008 at 3:48 am
Jeff may disagree with me on this, but here's my take on interviews.
Know your stuff, but if you can't answer the question, be honest about it. Tell the interviewer that you don't know. I've told prospective employeers before that "I don't know the syntax, I usually check BOL before I do it" or "I haven't played with that functionality before" or things like that, depending on the question.
In my book, there's nothing wrong with those kinds of answers. And if the interviewee seems to know the other stuff, but is weak in an area or two, I'm willing to let them learn on the job, so long as they're not trying to BS their way through the interview.
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply