Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««56789»»

70-461 Expand / Collapse
Author
Message
Posted Saturday, May 11, 2013 11:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 11:59 AM
Points: 26, Visits: 116
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
Post #1451846
Posted Sunday, May 26, 2013 2:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 12:17 PM
Points: 4, Visits: 13
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.
Post #1456920
Posted Monday, May 27, 2013 6:22 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:48 AM
Points: 39, Visits: 190
When you say 2008 Certification book you mean the one for the Exam 70-433?
Post #1457084
Posted Monday, May 27, 2013 11:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 27, 2014 12:17 PM
Points: 4, Visits: 13
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.

Post #1457135
Posted Tuesday, August 13, 2013 12:58 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 04, 2013 12:17 PM
Points: 40, Visits: 134
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 ;)... and plans to cover all exams for MCSE: BI (which I have)... went to the bin :D

I hope you will like it.

Take care
Emil
Post #1483914
Posted Tuesday, August 13, 2013 1:00 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 12,175, Visits: 9,123
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 ;)... and plans to cover all exams for MCSE: BI (which I have)... went to the bin :D

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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1483915
Posted Wednesday, September 18, 2013 1:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 2:14 PM
Points: 2, 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
Post #1496099
Posted Wednesday, September 18, 2013 1:39 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 12,175, Visits: 9,123
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?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1496103
Posted Wednesday, September 18, 2013 1:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 18, 2013 2:14 PM
Points: 2, Visits: 2
Yes. Great! Thanks for the quick reply
Post #1496110
Posted Wednesday, September 18, 2013 1:57 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 11:59 AM
Points: 26, Visits: 116
It's not nearly as easy as you think though ...

s
tester123 34641 (9/18/2013)
Yes. Great! Thanks for the quick reply
Post #1496115
« Prev Topic | Next Topic »

Add to briefcase «««56789»»

Permissions Expand / Collapse