+ Reply to Thread
Page 1 of 2 1 2 Last
Results 1 to 25 of 31
  1. Member
    Join Date
    Nov 2012
    Location
    Louisville, KY
    Posts
    81

    Certifications
    MCSE: Server Inf, Desktop Inf, Private Cloud, MCSA: Server 2012, Windows 8, MCITP: Windows 7 Administrator, MCITP: Virtualization Adminstrator, MCTS,
    #1

    Default Sitting the 70-461 tomorrow morning (01/22/2013)

    Just thought I'd share my experience.

    I have been studying for the past 2 weeks for this exam, using MSDN and the CBT Nugget series, using SQL Server 2012 SP1 Express Edition.

    I sit the test tomorrow, and hope I have what it takes to pass! I have no DBA experience, and my only experience with SQL prior to this has been through exposure of creating custom reports for SCCM/SCOM, which mainly consisted of the SELECT, WHERE, ORDER BY, and AS statements, as well as some experience with Subselect queries.

    Wish me luck!
    Reply With Quote Quote  

  2. SS -->
  3. VCDX in 2017 Essendon's Avatar
    Join Date
    Sep 2007
    Location
    Melbourne
    Posts
    4,489

    Certifications
    VCIX-NV, VCAP5-DCD/DTA/DCA, VCP-5/DT, MCSA: 2008, MCITP: EA, MCTS x5, ITIL v3, MCSA: M, MS in Telecom Engg
    #2
    You'll do just fine mate. Post back on how you go!
    VCDX: DCV - Round 2 rescheduled (by VMware) for December 2017.

    Blog >> http://virtual10.com
    Reply With Quote Quote  

  4. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #3
    How did it go? I'm going to have my exam this Sunday! I'd like to hear how it is.
    Reply With Quote Quote  

  5. VCDX in 2017 Essendon's Avatar
    Join Date
    Sep 2007
    Location
    Melbourne
    Posts
    4,489

    Certifications
    VCIX-NV, VCAP5-DCD/DTA/DCA, VCP-5/DT, MCSA: 2008, MCITP: EA, MCTS x5, ITIL v3, MCSA: M, MS in Telecom Engg
    #4
    Sunday really? I've never heard of a center being open on Sunday, where's this? Good luck BTW!
    VCDX: DCV - Round 2 rescheduled (by VMware) for December 2017.

    Blog >> http://virtual10.com
    Reply With Quote Quote  

  6. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #5
    Downtown Vancouver, BC.

    EDIT: You had me second guessing myself, but yes I just checked my confirmation email:

    Appointment Date: 27 JAN 2013
    Appointment Time: 13:00:00
    Reply With Quote Quote  

  7. Member
    Join Date
    Nov 2012
    Location
    Louisville, KY
    Posts
    81

    Certifications
    MCSE: Server Inf, Desktop Inf, Private Cloud, MCSA: Server 2012, Windows 8, MCITP: Windows 7 Administrator, MCITP: Virtualization Adminstrator, MCTS,
    #6
    First exam failure of the year. 625/1000.

    Lots of queries, and a few drag and drops that really got me. I need to do a lot more studying on topics such as performance enhancements (indexes, etc) and items such as UDFs, Triggers, and a few other things.
    Reply With Quote Quote  

  8. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #7
    Oh no! I'm sorry to hear that. Did you purchase the exam with the second shot option?

    Also, I'm a bit confused by the drag and drop questions you mentioned. Could you elaborate a bit on it?

    Thanks in advance!
    Reply With Quote Quote  

  9. Member
    Join Date
    Nov 2012
    Location
    Louisville, KY
    Posts
    81

    Certifications
    MCSE: Server Inf, Desktop Inf, Private Cloud, MCSA: Server 2012, Windows 8, MCITP: Windows 7 Administrator, MCITP: Virtualization Adminstrator, MCTS,
    #8
    To my knowledge, all vouchers are second shot until like March. All I know is that my employer buys my vouchers for me, so I never have to deal with that. Perks of working for a Microsoft Partner, but lets not forget the bonus I get for passing exams and salary increases for getting my MCITPs and MCSEs (and even my CCNA and VCP once I get those).

    No big deal, just sucks. I will take it again in a few weeks once I spend some more time with it.

    The drag and drop that sticks out in my head had like 9 options, but I only use 5. Each of the 9 options were T-SQL fragments that you had to pick the right ones and order them correctly to find the solution to the problem listed in the question.
    Reply With Quote Quote  

  10. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #9
    I see, thanks for the explanation. I was wondering about one other thing, are there questions which you need to write queries from scratch? Or was all the questions multiple choice and the drag and drop?

    Thanks!
    Reply With Quote Quote  

  11. Member
    Join Date
    Nov 2012
    Location
    Louisville, KY
    Posts
    81

    Certifications
    MCSE: Server Inf, Desktop Inf, Private Cloud, MCSA: Server 2012, Windows 8, MCITP: Windows 7 Administrator, MCITP: Virtualization Adminstrator, MCTS,
    #10
    I had 44 questions and they were all either drag and orders, or multiple choice. I may have had 6-10 drag and orders and the rest multiple choice.
    Reply With Quote Quote  

  12. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #11
    Thanks for the info, two more days! Hopefully I'll be able to pass on the first try.
    Reply With Quote Quote  

  13. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,342

    Certifications
    CISSP
    #12
    So how did you do? I will be taking this exam later this year.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  14. Senior Member knownhero's Avatar
    Join Date
    Jul 2008
    Location
    UK
    Posts
    433

    Certifications
    MCSE: SharePoint 2013, Productivity
    #13
    Josico... I'm also interested in knowing how you got on with this exam. Mine is set for Feb 22nd though still not sure if I'm fully ready for it.
    70-410 [x] 70-411 [x] 70-462[x] 70-331[x] 70-332[x]
    MCSE - SharePoint 2013

    Road map 2017: JavaScript and modern web development

    Reply With Quote Quote  

  15. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #14
    Hope you passed, but even if you didn't we'd love to hear what your advice would be for others.
    Reply With Quote Quote  

  16. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #15
    Hi all,

    Been a bit busy at work and with events after work so I haven't been able to post. Regardless, I would like to say that I passed the exam!

    My results showed that I was weakest with the performance tuning and I agree with that as I found those questions the hardest.

    As for advice for others:
    1. I found the topics and MSDN articles covered here to be useful:
    exam 70 461 querying microsoft sql server 2012 pdf vce ebook free

    2. The drag and drop was difficult in the sense that the choices were essentially the same with minor differences - essentially the options and hints.

    3. A general advice is to really take time to read the question and answers. I caught myself several times picking the wrong answer because the requirements were for the start_date and two answers were identical but the first answer in the list returned the end_date. Being lazy, I had just picked the first answer. Luckily, because I completed with time left, I was able to go over the questions one more time. I completed everything with over 1:30 hours (or so) left in the exam.

    Just to give you guys an idea of my background. I work as a help desk support but dabble with the SQL Server. I'm not a developer but have had some courses at school regarding SQL, database terminology, and relational theory.

    Good luck to everyone else!

    I'm starting 70-462 now but so far am having a hard time getting the lab set up as per the MS study kit.
    Reply With Quote Quote  

  17. Senior Member knownhero's Avatar
    Join Date
    Jul 2008
    Location
    UK
    Posts
    433

    Certifications
    MCSE: SharePoint 2013, Productivity
    #16
    Josico,

    Well done on the pass! I've got mine end of Feb and really starting to think I am not ready for it. I can read a query okay but when it comes to writing one I am struggling (no idea why). How long is this exam? I'll have to read everything super slow
    70-410 [x] 70-411 [x] 70-462[x] 70-331[x] 70-332[x]
    MCSE - SharePoint 2013

    Road map 2017: JavaScript and modern web development

    Reply With Quote Quote  

  18. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #17
    You've still got time! I'm sure if you spend some more time, you'll be ok! The exam was 2:15 hours long when I started. So I finished it in 45 minutes or so? Approximately a minute a question?

    Good luck!
    Reply With Quote Quote  

  19. Senior Member knownhero's Avatar
    Join Date
    Jul 2008
    Location
    UK
    Posts
    433

    Certifications
    MCSE: SharePoint 2013, Productivity
    #18
    I've got the second shot thing if I need it so not a huge loss if I fail the first time. I just need to study some more. Amazon have sold out on the 70-461 exam books so I have to use the CBT nuggets/Teach yourself T-SQL/Fundamentals of T-SQL books.

    I also have exposure to SQL in my work place (writing basic queries and looking at Views/SP) I'm panicking about UDF's etc.
    70-410 [x] 70-411 [x] 70-462[x] 70-331[x] 70-332[x]
    MCSE - SharePoint 2013

    Road map 2017: JavaScript and modern web development

    Reply With Quote Quote  

  20. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #19
    Congrats! That link does look really interesting. I'm going to let the videos play in the background today, I think.
    Reply With Quote Quote  

  21. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #20
    @knownhero
    I didn't have many questions about UDFs in my exam - I think there was only one? I might have just lucked out though.

    @RobertKaucher
    Yup, there quite a bit of informative information on that site.
    Reply With Quote Quote  

  22. Senior Member knownhero's Avatar
    Join Date
    Jul 2008
    Location
    UK
    Posts
    433

    Certifications
    MCSE: SharePoint 2013, Productivity
    #21
    Josico. Would you say its "easy" if you've had like a years worth of exposure to SQL with Live data. All I really do at the moment are basic queries. Ive seen the views and SP's we have but not really (until now) looked in depth at them.
    70-410 [x] 70-411 [x] 70-462[x] 70-331[x] 70-332[x]
    MCSE - SharePoint 2013

    Road map 2017: JavaScript and modern web development

    Reply With Quote Quote  

  23. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #22
    I wouldn't say that the exam will be "easy" if you have had many years of live experience - unless you were a developer during that time.

    Even with that said, unless you have been working with all the different options (some of which are new to 2012), it still won't be "easy".

    What I can say is that if you have been working with SQL for many year, it will be easier for you to get up to speed with the details and syntax of different queries and its options.

    From my experience working in a live environment, there are certain processes which are done routinely but there are many more features of SQL which are not touched.
    Reply With Quote Quote  

  24. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,342

    Certifications
    CISSP
    #23
    Thanks for the information! I am planning to take this exam soon!
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  25. Senior Member knownhero's Avatar
    Join Date
    Jul 2008
    Location
    UK
    Posts
    433

    Certifications
    MCSE: SharePoint 2013, Productivity
    #24
    Quote Originally Posted by josico View Post
    I wouldn't say that the exam will be "easy" if you have had many years of live experience - unless you were a developer during that time.

    Even with that said, unless you have been working with all the different options (some of which are new to 2012), it still won't be "easy".

    What I can say is that if you have been working with SQL for many year, it will be easier for you to get up to speed with the details and syntax of different queries and its options.

    From my experience working in a live environment, there are certain processes which are done routinely but there are many more features of SQL which are not touched.
    I've been using it now for a year at work. I've not used many of the syntax listed in the books/videos but I know of some of them. I've learnt so much reading the books etc that I now now how/what the SPs we use do. Hope to pass first time. But doubt I will.

    Thanks for all the replies.
    70-410 [x] 70-411 [x] 70-462[x] 70-331[x] 70-332[x]
    MCSE - SharePoint 2013

    Road map 2017: JavaScript and modern web development

    Reply With Quote Quote  

  26. Junior Member
    Join Date
    Feb 2012
    Location
    Vancouver, BC, Canada
    Posts
    15

    Certifications
    A+, Network+, Security+
    #25
    Don't doubt yourself. Just take your time and read the questions carefully and you'll be fine. Also, remember to skip questions you're not sure off and mark them for review. You can always go back to them when you've got the ones you know for sure. As you answer more questions you'll be more confident and the exam will "be easier".
    Reply With Quote Quote  

+ Reply to Thread
Page 1 of 2 1 2 Last

Social Networking & Bookmarks