SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


70-461 - Done, but more difficult than expected


70-461 - Done, but more difficult than expected

Author
Message
winston Smith
winston Smith
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4397 Visits: 2071
Just passed the 70-461 SQL Developer Exam Today.

This exam is much harder than I expected.
Its quite syntax heavy, and asks a lot of questions on correct syntax, things that if SSMS didnt like the syntax it would take 30 secs to g00gle the proper syntax. Syntax memorization isnt a real test of knowledge IMO but regadless, its in the exam. correct syntax on index creation, table altering, view creation, grouping, xml, windowing, xml, xml and more xml all came up.

Lots of XML, know the different ways to convert rows to XML, and the differences between those ways to get xml out of tabular data.
Know your windowing functions well.
Know grouping very well.
Know UDF's well, different types and syntax.
Types of triggers and their usage.

Pretty much everything that the exam covers came up so not many shortcuts.
I used the microsoft training book as prep. book is great, but the sample exam is worse than useless. I wouldnt use it AT ALL if doing this again.

Best of luck to all taking this exam.
dan-572483
dan-572483
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3703 Visits: 2000
I did fairly well on the practice exam last Friday (even with CNN playing in the background), so thanks for deflating my confidence. ;-)
GilaMonster
GilaMonster
SSC Guru
SSC Guru (231K reputation)SSC Guru (231K reputation)SSC Guru (231K reputation)SSC Guru (231K reputation)SSC Guru (231K reputation)SSC Guru (231K reputation)SSC Guru (231K reputation)SSC Guru (231K reputation)

Group: General Forum Members
Points: 231640 Visits: 46354
Just a warning, discussing what's in the exam is a violation of the NDA that you accepted when writing that exam, so watch what you say about the contents of the exam.

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


winston Smith
winston Smith
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4397 Visits: 2071
No worries, I intended to, and stayed very general, much less detailed than other posts on this site about the exam, but I won't mention anything further on the exam.
Dird
Dird
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1261 Visits: 821
Not being funny but it's a SQL exam...
DDL (index creation, table altering, view creation), queries with grouping, various join types is what you would expect, no? If it's as bad as Oracle's SQL exam it would probably include lots of generic functions that are used once in a blue moon but somehow make it into the exam~

no idea about "windowing" or xml though :x

Dird


Dird
Steven.Howes
Steven.Howes
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1662 Visits: 2354
Thanks for the advice about the prep book practice exam. I tend to use those to get in to exam answering mode. Maybe I'll spring for a different exam test suite. Of all the exams this is the one I'm worried least about, The BI exam that's a totally different story. Looking forward to the material, dreading the exam.
TheComedian
TheComedian
SSChasing Mays
SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)SSChasing Mays (601 reputation)

Group: General Forum Members
Points: 601 Visits: 510
Just passed the 70-461 today so wanted to add my 2 cents.

I actually didn't find it as bad but then again I was expecting it to be murder after reading OP's comments. I wouldn't say that the questions in the Training Toolkit CS are useless but the exam questions are definitely harder. What I would do is read the book carefully, which is great by the way, do all the exercises and practice questions and then do the practice exam since it's more of a warmup than an actual exam simulation.

I can't say anymore because of the Terms and Conditions signed but I would say that it's challenging but doable.
db808
db808
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 68
I'm reading the Training Kit Book and there are sections with a "key" icon. What are the relevance of these verses the sections labled "exam hints"

Also is 2 hours more than enough time for the 200 question exam?
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: General Forum Members
Points: 64394 Visits: 13298
db808 (10/30/2013)
I'm reading the Training Kit Book and there are sections with a "key" icon. What are the relevance of these verses the sections labled "exam hints"

Also is 2 hours more than enough time for the 200 question exam?


If you know your T-SQL, 2 hours is enough time.
I did it in a bit over an hour.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
RTaylor2208
RTaylor2208
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2747 Visits: 1264
db808 (10/30/2013)
I'm reading the Training Kit Book and there are sections with a "key" icon. What are the relevance of these verses the sections labled "exam hints"

Also is 2 hours more than enough time for the 200 question exam?


200 Questions? Do you mean test questions as when I sat my exam there was only 44.

MCITP SQL 2005, MCSA SQL 2012
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