+ Reply to Thread
Results 1 to 10 of 10
  1. Member
    Join Date
    Jul 2014
    Location
    SOUTH AFRICA
    Posts
    40

    Certifications
    MCSA,MCSE,SQL 2012
    #1

    Default Taking 461 in Four weeks time

    Hie

    I am planning to take my first exam 461 next month but i am feeling a bit nervous so i heard its tough.To those who did 461 and passed please help me on how you made it.Which topics needs more attention mostly from exam objectives and did you use dumps?Thanks.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #2
    I used the Microsoft Querying SQL Server 2012 Training kit, SQL Server 2012 Express, AdventureWorks and YouTube.

    Also, you should never use dumps. You won't learn anything. Especially on this exam, you need to know your stuff.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  4. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,380

    Certifications
    CISSP
    #3
    The training kit was enough if you practice hard. No, I did not and will not use dumps.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  5. Member
    Join Date
    Jul 2014
    Location
    SOUTH AFRICA
    Posts
    40

    Certifications
    MCSA,MCSE,SQL 2012
    #4
    Thank you Nacho and Carl.You inspired me a lot i need to know my staff for sure.Besides XML which other topics you think needs a lot of attention?

    Thanks
    Reply With Quote Quote  

  6. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,380

    Certifications
    CISSP
    #5
    Syntax is really important in this command. Commands/reserved words are fair game. For example, to use nolock in a query, is it FROM TABLE WITH (NOLOCK) or FROM TABLE WITH (NOLOCKS). It is (NOLOCK) of course but I seem to remember some questions that came down to that level of granularity. Also the partitioning/windowing.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  7. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    323

    Certifications
    A+,N+,OCA MySQL, ITIL-F (2012),MCTS: SQL 2008 DB Dev.
    #6
    hey Tawaz, how's the exam prep going ?
    Currently Pursuing:

    BSc Information Systems and Management (University of London International Programs)
    Reply With Quote Quote  

  8. Member
    Join Date
    Jul 2014
    Location
    SOUTH AFRICA
    Posts
    40

    Certifications
    MCSA,MCSE,SQL 2012
    #7
    So far so good man.Sitting on the 12th of Jan
    Reply With Quote Quote  

  9. Senior Member whatthehell's Avatar
    Join Date
    Jun 2006
    Location
    Orange County, CA.
    Posts
    914

    Certifications
    Server+,A+, N+, MCDST, HDI/SCA, MCP, ITIL Foundations 2011, VCA5-DCV,VCA5-Cloud, MTA 98-364
    #8
    Let us know how it goes and best of luck!
    I just sat the 98-364...though it was supposed to be basic, it was a bit more difficult than I expected (though still passed!).
    I am just beginning to study ffor 70-461 with target of roughly late January or early Feb. Going through Pluralsight videos and I purchased Itzik's books too (T SQL and 70-461 book)

    Again, Good luck!
    Reply With Quote Quote  

  10. JMT
    JMT is offline
    Junior Member Registered Member
    Join Date
    Jan 2015
    Posts
    1
    #9
    How did it go , I am just starting with this today . SO came hear to read up seems its going to be hard .
    Reply With Quote Quote  

  11. Junior Member Registered Member
    Join Date
    Mar 2015
    Posts
    2
    #10
    Hi guys,

    my first post here, been browsing the forums for awhile, a lot of useful stuff on here.
    Special thanks to nachodba for his advice. Goods stuff there man.

    One question for all of you getting ready for 70-461 how long did the prep usually take? Of course depending on your current experience level it will vary, that's understandable. But it would be nice to know what to expect in terms of time line.

    Also did any of you guys use Pluralsight as one of your sources? How would you rate them?
    I plan to use Itzik's book for 70-461 and Pluralsight should that be ok to get enough practice or do I need to add to it?
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks