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


70-461


70-461

Author
Message
Scott_4
Scott_4
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 122
Study hard and this test is not terrible. I passed it on the second attempt.

I created a list of every topic that MS says can be on the test. I then used books and googling to find examples, and to do these things myself (very important).

I passed at 85%.

Good luck to me on 70-462 (which is not so nearly as natural to me as TSQL).

s
scott.fountain
scott.fountain
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 35
I just took the 70-461 exam and passed.

Concerning the 2012 Certification book, yes, the practice questions there are easier than what's on the exam.

However, with respect to the 2008 Certification book, I thought the 2008 practice questions were harder than the exam questions.

Point here being is that it might not hurt to pick up the 2008 Certification book.

Myself - I have three years experience with SQL development. Like Microsoft, I wouldn't recommend this exam to someone with less than 12 months application experience. That would be cruel. Nevertheless, there's a lot to be learned from the certification books.

My best advice is to look over the book and ask yourself what areas do you have experience with and what areas you do not. For instance, my work experience has me working with XML techniques, cursor vs. while loop decisions, temp table vs. table variable, and Dynamic SQL experience. Not to mention, I like reading up on performance and tuning techniques.

No, I'm not a guru, but as mentioned before, these are the areas that I do a lot of work with.

However, my work experience has me falling short with Schemabinding methods, Instead-Of triggers for Views, and error handling. So yeah, these were chapters that I applied a little more focus towards.

A good study plan would be knocking out a chapter during the weekdays and one chapter on the weekend.
DiegoPeña
DiegoPeña
SSC Veteran
SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)SSC Veteran (253 reputation)

Group: General Forum Members
Points: 253 Visits: 236
When you say 2008 Certification book you mean the one for the Exam 70-433?
scott.fountain
scott.fountain
SSC Journeyman
SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)SSC Journeyman (76 reputation)

Group: General Forum Members
Points: 76 Visits: 35
Yes, 70-433 (2008 Database Development) - sorry about that. But yes, it made for an awesome companion book to 70-461.

And while its out of this forum's scope, if someone is new to SSIS, the first several chapters of 70-448 (SQL 2008 BI Exam) is worth looking at.

Not to mention, I've had people tell me that the 70-432 book (2008 Implementation and Maintenance) makes for an awesome companion to 70-462.
KatieAndEmil
KatieAndEmil
SSC Veteran
SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)SSC Veteran (281 reputation)

Group: General Forum Members
Points: 281 Visits: 135
Hi

I'm giving away for free 70-461 Full Practice Test. For Instruction how to get it visit our LinkedIn Group Discussion

Reason why we give it away is because Microsoft discourages people to provide the practice tests if the person took the exam... These questions are NOT actual exam question (we don't violate any terms & conditions) and we use them for training/interviews but questions are specifically adjusted to cover 'skills measured' for 70-461.

The test will be taken down from our website in several days time (better be safe than sorry Wink... and plans to cover all exams for MCSE: BI (which I have)... went to the bin BigGrin

I hope you will like it.

Take care
Emil
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)

Group: General Forum Members
Points: 111834 Visits: 13338
KatieAndEmil (8/13/2013)
Hi

I'm given away for free 70-461 Full Practice Test. For Instruction how to get it visit our LinkedIn Group Discussion

Reason why we give it away is because Microsoft discourages people to provide the practice tests if the person took the exam... These questions are NOT actual exam question (we don't violate any terms & conditions) and we use them for training/interviews but questions are specifically adjusted to cover 'skills measured' for 70-461.

The test will be taken down from our website in several days time (better be safe than sorry Wink... and plans to cover all exams for MCSE: BI (which I have)... went to the bin BigGrin

I hope you will like it.

Take care
Emil


Wut? That sucks.


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
tester123 34641
tester123 34641
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
Points: 58 Visits: 2
Hello

is there a prerequisite exam for 70-461 that must be taken first ? I work in the field already and use SQL extensively I feel that I can pass the exam with minimal effort , but I did not know if I need a pre-req first

Thanks
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)SSC Guru (111K reputation)

Group: General Forum Members
Points: 111834 Visits: 13338
tester123 34641 (9/18/2013)
Hello

is there a prerequisite exam for 70-461 that must be taken first ? I work in the field already and use SQL extensively I feel that I can pass the exam with minimal effort , but I did not know if I need a pre-req first

Thanks


No, you can take the exam whenever you want.
The exam itself doesn't give a certification though, you also need 70-462 and 70-463 to get the MCSA certificate.


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
tester123 34641
tester123 34641
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
Points: 58 Visits: 2
Yes. Great! Thanks for the quick reply
Scott_4
Scott_4
SSC-Enthusiastic
SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)SSC-Enthusiastic (143 reputation)

Group: General Forum Members
Points: 143 Visits: 122
It's not nearly as easy as you think though ...

s
tester123 34641 (9/18/2013)
Yes. Great! Thanks for the quick reply

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