70-445 Questions and answers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Career » Certification » 70-445 Questions and answers

18 posts, Page 1 of 2

1 2 »»

70-445 Questions and answers

Rate Topic

Display Mode

Topic Options

Author

Message

meghna.bhargav

Posted Monday, September 08, 2008 3:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:42 AM
Points: 104, Visits: 390

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

Post #565272

Steve Jones - SSC Editor

Posted Thursday, September 18, 2008 9:30 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:19 PM
Points: 31,526, Visits: 13,863

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.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #571884

GilaMonster

Posted Thursday, September 18, 2008 9:45 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 38,062, Visits: 30,359

Transcender and MeasureUp are both good. Not cheap though.

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 #571907

Brandie Tarvin

Posted Friday, September 19, 2008 5:01 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:45 AM
Points: 6,717, Visits: 5,788

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.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #572401

meghna.bhargav

Posted Friday, September 19, 2008 5:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:42 AM
Points: 104, Visits: 390

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!

Post #572405

rayna.peneva

Posted Thursday, October 09, 2008 3:04 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:35 AM
Points: 8, Visits: 121

I wouldn't go personally for Transcender - expensive and far away from the point.... Angry

Post #583142

Brandie Tarvin

Posted Thursday, October 09, 2008 4:07 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:45 AM
Points: 6,717, Visits: 5,788

Far away from the point??? What do you mean?

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #583170

Jeff Moden

Posted Thursday, October 09, 2008 9:49 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:19 PM
Points: 33,110, Visits: 27,035

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

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #583720

Brandie Tarvin

Posted Friday, October 10, 2008 5:31 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:45 AM
Points: 6,717, Visits: 5,788

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.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #583879

GilaMonster

Posted Friday, October 10, 2008 7:04 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 38,062, Visits: 30,359

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 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 #583919

« Prev Topic | Next Topic »

18 posts, Page 1 of 2

1 2 »»

Permissions