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


70-461


70-461

Author
Message
dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)SSChasing Mays (645 reputation)

Group: General Forum Members
Points: 645 Visits: 1958
Microsoft and Prometric are currently offering a "Second Shot" promotion. If you feel confident on the subject matter you can take the exam, and if you don't pass, you'll have a better idea of the level of knowledge required for you second free attempt.
Richard Warr
Richard Warr
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2578 Visits: 1983
Koen Verbeeck (9/18/2013)
The exam itself doesn't give a certification though, you also need 70-462 and 70-463 to get the MCSA certificate.


Well, if it's your first one you DO become a MCPS and can print off the appropriate certificate for that. It's not a "proper" certification as Koen says but it's better than nothing.

Passed mine last week - it was much harder than the practice tests you get with the book so don't rely too much on those.

_____________________________________________________________________
MCSA SQL Server 2012
Scott_4
Scott_4
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: 118
Exactly right. Go to the Certification Site - build yourself a document with EACH item separated - look up examples and actually do them.

Repetition is where it's at - actually doing the work, not just reading about it.

s
Richard Warr (10/7/2013) ... Passed mine last week - it was much harder than the practice tests you get with the book so don't rely too much on those.

dzenan.dzevlan
dzenan.dzevlan
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 74
ErikvanD (6/18/2012)
cbtnuggets.com just has a video series out on 461 which could be a good starting point to get an overview. I am preparing for the exam myself and will sure have a look at these too.


Do you have T SQL code that is used in cbt nugget 70 461 series.
Regards
KatieAndEmil
KatieAndEmil
SSC Rookie
SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)

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

I hope you don't mind if I share slightly off the topic reply... I just wanted to let you know that we are organizing Christmas BI Competition and one of the categories will relate to Microsoft exams including 70-461.

To make it more interesting we have decided to provide Christmas Gift for the person who wins the competition and that is £100 (or $150).

For more information visit Christmas BI Competition.

p.s. After we had to take down 70-461 practice test (Microsoft T&Cs) we have decided to provide online classes and webinars for 70-461 that we hope to release in first part of 2014.

Take care
Katie & Emil
MKEDataGuy
MKEDataGuy
Old Hand
Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)

Group: General Forum Members
Points: 320 Visits: 108
I recently passed Exam 70-461. I used the Exam Training Kit from Microsoft Press. I was able to order the book earlier this year... March or April time frame. It's by Itzik Ben-Gan, Dejan Sarka and Ron Talmage. I think it goes a fairly good job of covering the material on the exam. I also bought a developer edition of SQL Server, so I could install it at home and try out the new language features, etc.

For Microsoft certification exams in general, I tend to take the practice tests in certification mode to see if I'm ready. If I can get 100% on several practice exams in a row, then I feel I'm in good shape for the exam. That said... The exam questions are always more difficult, then the practice questions.

Thanks,
MKE Data Guy
manub22
manub22
SSC-Enthusiastic
SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)

Group: General Forum Members
Points: 137 Visits: 1861
I would suggest not to rely on DUMPS if you really want to add value to your carrier.

You can check my blog post for 70-461 exam: http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/

All the best!!!


~manoj | LinkedIn | Facebook | YouTube
Blog: SQLwithManoj.com

Siberian Khatru
Siberian Khatru
SSC-Enthusiastic
SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)

Group: General Forum Members
Points: 106 Visits: 366
So, I failed the 70-461 exam on Tuesday and in retrospect, I know why. Even though I've been an accidental DBA since roughly 2001, There are many things we simply don't use at my job and I gave those subjects short shrift PLUS I trusted the practice exams provided in the 70-461 Training Toolkit from Microsoft Press to be a harbinger of success. Wrong move there...in my opinion it was like jumping from Kindergarten level questions to Junior in college level comparing the practice exams in that book to the real questions.

What I am wondering now prior to my free retake:

- Was the test I took a fair representation of what I can expect on my free retest from a subject matter perspective? The last Microsoft Certification test I took (and passed) was VB6 back in 1999, so testing is something I am just getting reacquainted with now.

- I was a bit nervous when I signed my NDA, so let me ask here.
-- Can I discuss general subject matter asked in the test without the specifics of the test itself?
-- Can I reveal my score (number relevant to 700, number of questions, etc.) itself to determine how close I was?
-- Lastly, can I reveal the areas with which I had trouble, based on my printout after the test so I can ascertain how best to prepare those areas?
FridayNightGiant
FridayNightGiant
SSChasing Mays
SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)SSChasing Mays (602 reputation)

Group: General Forum Members
Points: 602 Visits: 1844
It is OK to reveal your score if you want to or discuss the top 3 weakest areas from your score record.

You shouldn't discuss anything to do with the format of the exam, the types of the questions asked, the actual questions or answers etc.

Try installing SQL on your own PC/Laptop and playing with the things you aren't sure of. You can buy the developers version cheaply or install a 180 day trial.

Try the course below on the MVA if you haven't already
https://mva.microsoft.com/training-courses/querying-with-transact-sql
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: 47299 Visits: 44392
Siberian Khatru (1/7/2016)
- Was the test I took a fair representation of what I can expect on my free retest from a subject matter perspective?


Probably yes. You'll get a different set of questions from the (large) pool of questions for the exam.

-- Can I discuss general subject matter asked in the test without the specifics of the test itself?


I would suggest you don't.

-- Can I reveal my score (number relevant to 700, number of questions, etc.) itself to determine how close I was?


Score, yes. Number of questions, no. Besides, that'll change from one exam to another iirc

-- Lastly, can I reveal the areas with which I had trouble, based on my printout after the test so I can ascertain how best to prepare those areas?


Areas, yes. Any details on anything you were asked in those sections, no.


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


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