Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 The Yak Corral
 Just passed cert exam....

Author  Topic 

monkeybite
Posting Yak Master

152 Posts

Posted - 2004-01-30 : 16:49:41
Sooooooo, my office manager comes up to me last Friday and says "we need you to pass a MS certification exam so we can retain our partnership". I say, "ok, by when?". She replies, "Friday of next week". So I got signed up for 70-229 that day.

So, got the Transcenders that Friday, studied a little bit this week, took the test this morning, and passed with a 738.

Whew.

~ monkey

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-01-30 : 18:16:03
Congrats Monkeybite! You going to go for full MCDBA now?

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]
Go to Top of Page

monkeybite
Posting Yak Master

152 Posts

Posted - 2004-01-30 : 18:43:29
Dunno yet. Oftentimes I seriously question the validity of any type of certifications, as I've seen good and bad DBAs and developers with lots of certifications. However, I don't think it'll hurt me to get one.

It was a goal of mine last year to get the MCDBA cert, but I kinda moved on to other pursuits and lost interest.

~ m
Go to Top of Page

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2004-01-31 : 01:33:35

Congrats, man!!


Was it tough job to pass thru? I never seen/read those questions.

PS I'm not quite sure what exactly I mean by this strange semantic
construction "seen/read". Hm... there is a subtle difference in them.

PPS btw, how you'd solve this thing:
create table #t (n int primary key)
insert into #t
select 2 union all
select 4 union all
select 5 union all
select 6 union all
select 9

Result of a select should be:

n1 n2
--------
2 9
4 6
5 5
6 4
9 2
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-01-31 : 09:07:11
Is passing with a 738 on a 70-229 good or not? (Everyone else understood this?)

(Do these numbers remind anyone else of CB slang? 10-4 good buddy and all that.)

SELECT n, (select top 1 X.n from #t X WHERE X.N >=Y.N ORDER BY X.n DESC) FROM #t Y ORDER BY n
Go to Top of Page

monkeybite
Posting Yak Master

152 Posts

Posted - 2004-01-31 : 12:05:44
quote:
Originally posted by SamC

Is passing with a 738 on a 70-229 good or not?


Its 738 out of a possible 1000. Dunno if it's good or not, however the proctor seemed surprised that I passed. She said, "oh, you did very well." I guess that this testing center 1) doesnt give this exam very often, and 2) fail most of the people that do take it.

roger, 10-4, over.

~ m
Go to Top of Page

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2004-01-31 : 14:16:42
SamC--
create table #t (n int primary key)
insert into #t
select 2 union all
select 4 union all
select 5 union all
select 6 union all
select 9

SELECT n,
(select top 1 X.n from #t X WHERE X.N >=Y.N
ORDER BY X.n DESC) FROM #t Y ORDER BY n

drop table #t

n
----------- -----------
2 9
4 9
5 9
6 9
9 9
???
OK, don't worry.
Seems it really does not matter whether you seen/read/passed the exam or not.
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-01-31 : 14:53:20
Five 9s. Sometimes five 9s is a good thing. Not now, not here.

BTW I forgot.. CONGRATS monkeybite

What I'd like to see is a JOIN solution to the problem.

Let's see a solution.


Go to Top of Page

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2004-01-31 : 15:41:54
What does it mean "Let's see a solution." ???

Just post it!!
Go to Top of Page

monkeybite
Posting Yak Master

152 Posts

Posted - 2004-01-31 : 16:03:25
quote:
Originally posted by Stoad

What does it mean "Let's see a solution." ???

Just post it!!



dudes, its saturday... lets work on a solution monday when my time is billable...

thanks for the congrats!

~ m
Go to Top of Page

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2004-01-31 : 21:45:18
Lucky monkeybite - managed to avoid addicting to the sql......
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-01-31 : 23:10:23
[code]SELECT A.n, B.n
FROM (
SELECT n, (SELECT COUNT(*) FROM #t A WHERE A.N >= X.n) as RowID
FROM #t X
) A
INNER JOIN (
SELECT n, (SELECT COUNT(*) FROM #t A WHERE A.N <= X.n) as RowID
FROM #t X
) B ON B.RowID = A.RowID
ORDER BY A.n[/code]
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-02-01 : 00:59:47
quote:
Originally posted by monkeybite
dudes, its saturday... lets work on a solution monday when my time is billable...



Just as well we all don't think like that or there would be no SQLTeam

(I got 873 by the way )


Damian
Go to Top of Page

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2004-02-01 : 08:28:35
SamC--
And mine (looks a bit simpler but, in principle, the same):

select a.n n1, b.n n2 from #t a inner join #t b on
(select count(*) from #t t where t.n<a.n)=
(select count(*) from #t t where t.n>b.n)
order by 1

Damian--
873 - nice score! = 9*97
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-02-01 : 08:38:52
And surprisingly, both queries generate exactly the same execution plan.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-03 : 11:09:54
How much did it cost?

And Congrats....what's the 70-229 cover?







Brett

8-)
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-02-03 : 11:14:38
Thinking of taking it Brett?

Can it be taken on-line or only in a classroom environment?
Go to Top of Page

monkeybite
Posting Yak Master

152 Posts

Posted - 2004-02-03 : 11:22:19
The test costs $125 at the testing center I was at. You can only take the exams at MS-certified testing centers.

Here's what the 70-229 covers:
[url]http://www.microsoft.com/learning/exams/70-229.asp[/url]

I'd say that it was pretty hard. The questions can be tricky, sometimes all 5 answers are correct, and you have to choose the best one, or you choose the best 3 out of 6.

~ m
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-02-03 : 11:25:57
.....maybe....what's the lowest passing grade?

See if I can get the employeer to cough up the dough...

Yeah thanks for the link...there a some sample online tests there....



Brett

8-)
Go to Top of Page

monkeybite
Posting Yak Master

152 Posts

Posted - 2004-02-03 : 11:27:27
<yoda>700 you receive, pass you will</yoda>

~ m
Go to Top of Page

SamC
White Water Yakist

3467 Posts

Posted - 2004-02-03 : 11:46:47

Where's the online directory of testing centers?
Go to Top of Page
    Next Page

- Advertisement -