Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


70-445 Questions and answers


70-445 Questions and answers

Author
Message
Brandie Tarvin
Brandie Tarvin
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7802 Visits: 8745
True enough. @=)

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
DBABC
DBABC
SSC Veteran
SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)SSC Veteran (249 reputation)

Group: General Forum Members
Points: 249 Visits: 482
Jeff Moden, would you be kind enough to put here your those FEW INTERVIEW QUESTIONS?
Just wanted to check my own capability.


Thanks,
Usman
RBarryYoung
RBarryYoung
SSCrazy Eights
SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)SSCrazy Eights (9.4K reputation)

Group: General Forum Members
Points: 9438 Visits: 9517
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.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45147 Visits: 39923
Heh... no... if I posted the questions here, they'd be no better than certification exams. Sorry.

--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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Brandie Tarvin
Brandie Tarvin
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7802 Visits: 8745
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.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45147 Visits: 39923
Brandie Tarvin (10/24/2008)
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.


No... no disagreement there. How you answer or don't answer a question is nearly as important as the actual answer itself.

I've told this story before, but it seems very appropriate here. I was the AppDev manager and I had open billets for a GUI programmer who also knew SQL Server a bit better than average. I gave the recruiting agency a copy of a test I wanted candidates to pass before even thinking of sending them to me. The exam wasn't difficult... it was a pretty straight forward exam that anyone with a year or two of SQL experience should easily pass without studying.

Well, after a couple of days, the recruiter sent me a handful of resume`s along with each person's exams. Some did pretty well on the exam, but I was mostly disappointed because most gave some really poor and incorrect answers on 5 or 6 of the questions. You could tell they didn't know the answer but wrote a lot of rhetoric trying to convince me they did instead of just saying "Don't know, would have to research it or look it up in Books Online".

Then, I ran across this one fellow's test... it was perfect. He had all correct answers and the additional explanations he gave were spot on. On top of that, he had teaching experience and a great background in Math. So, I picked up the phone and called him. We talked for a while about what turned out to be an impressive work and experience history, and then I asked the question... "No one else gave all correct answers and they certainly didn't give the detailed explanations you did. For example, your explanation about what a "Firehose" cursor was, was absolutely spot on. How is it that, as a GUI programmer, that you know so much about SQL?"

His answer absolutely floored me... he said, "Unbeknownst to you, they allowed all of us to take the exam home... to take it in an unsupervised fashion. I didn't know a "Firehose" cursor from a ticked off fireman. So, I looked it all up on the internet."

He appologized for the "deception" and for "wasting my time" and was on the verge of hanging up. I stopped him, of course. In fact, I hired him for a couple of reasons...

First, he was honest to the point that it could have worked against him. That's pretty damned honest and I need people to be honest enough to tell me they broke something or whatever.

Second, even though it wasn't planned that way, ALL the other applicants had the same opportunity to get the answers absolutely correct the same way this fellow did, yet they did not. They apparently didn't have the research skills or, worse, couldn't be bothered.

Joe worked for me only a couple of years before the company decided to pull up and move back to Chicago... but during that time, he continued to demonstrate not only the ability to do the correct research to get a job done, but he was absolutely honest. He broke some code, one day, and came and told me not only that he broke the code, but what he was doing to try to fix it and then stayed late to stay on schedule. Even if he didn't know how to fix it, ya gotta love absolute honesty.

YES! I want someone that knows how to write code. There are certain basics that I believe you must know. But, I've had a couple of certified geniuses apply for similar jobs that knew just about everything I needed them to know about SQL... and I didn't hire them because either they were arrogant, they tried to BS me in the interview, or they lied on their resume.

Like I said, how you answer a question is nearly as important as the answer and absolute honesty is an absolute requirement.

--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.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Lynn Pettis
Lynn Pettis
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24217 Visits: 37978
GilaMonster (10/10/2008)
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


No kidding! Alien


Cool

Cool
Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47281 Visits: 44392
Jeff Moden (10/24/2008)

YES! I want someone that knows how to write code. There are certain basics that I believe you must know. But, I've had a couple of certified geniuses apply for similar jobs that knew just about everything I needed them to know about SQL... and I didn't hire them because either they were arrogant, they tried to BS me in the interview, or they lied on their resume.

Like I said, how you answer a question is nearly as important as the answer and absolute honesty is an absolute requirement.


Agreed. A couple months before I left the bank, I was interviewing someone who, if we had hired him, would have been my replacement. His skill level was border-line acceptable and, given 2 months with him I could have got hom to a level that I'd have been happy leaving the work to him. Problem is that he had an incredibly condescension manner towards everyone, as though he was doing us a massive favour by answering and he made up answers to some questions.


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


Shiva N
Shiva N
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2345 Visits: 470
hi please provide me the Training kit on shivasssv@gmail.com

Thanks,
Shiva N
Database Consultant
Brandie Tarvin
Brandie Tarvin
SSCertifiable
SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)SSCertifiable (7.8K reputation)

Group: General Forum Members
Points: 7802 Visits: 8745
Shiva N (9/8/2014)
hi please provide me the Training kit on xxxx@xxx.xxxx


Go to Microsoft's website for training kit information. You can order one through there.

By the way, it is a REALLY BAD IDEA to put your email address on posts on the internet. It'll get scraped and people will use it to send you all kinds of spam, phishing attempts, and viruses.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search