70-463 Exam v. Training Kit

  • How do the test exam questions from the 'Implementing a Data Warehouse with Microsoft SQL Server' training kit compare to the actual real 70-463 exam? is it worth purchasing?

  • I don't know for the 463 as I haven't taken it yet but I did for the 461. They are ok, I don't think they are necessary with Bol and experience.

    Mike

    How to Post Performance Problems[/url]

    How to Post Best Practices[/url]

  • Thanks, I also tried the training kit questions for 70-461 and found them to be excessively easy when compared with what was asked in the actual 70-461 exam. Just wondering now how the official 70-463 training kit questions pair up to the exam.

  • Passed 70-463 yesterday. Went with the offical training kit and Knight's 24 hour trainer.

  • Congratulations!

    Hey, I'm starting this soon, would that be the Knights 24 Hour BI trainer, or the SSIS 24 Hour trainer?

    Cheers,

    Paul.

  • Knight's 24 hour SSIS:

    http://books.google.co.uk/books/about/Knight_s_Microsoft_SQL_Server_2012_Integ.html?id=jOM7XE5pbPoC&redir_esc=y

    Basically this book and the training kit greatly helped me. It was an interesting exam for me.

    Best of luck.

  • Once you've done a few training kits and actual exams, it is apparent that the people who write the training kits don't talk to the people who write the exam questions, and may not have taken the exam themsleves. Instead, Microsoft publishes a list of topics that will be convered on an exam, and Training Kit creators create training materials than cover these topics. This is because Microsoft wants people who actually have experience with the product rather than just crammed for the test. There is no promise or guarentee that a training kit will contain the answer for every question on the exam. If you're very experienced in all topics that are on the exam objective list, you probably don't need a training kit.

    That said, I've just ordered the 70-463 book myself, because that will be my next exam and I've at little exposure to data warehousing in my career. Hopefully, setting it up at home and trying out the scenarios in the book will help me get familiar enough with it to pass the exam.

  • Yes, the book is worth purchasing, but you can also refer to the MSDN BoL. Check here you will get the links to the required study material to go thru.

    Link: http://sqlwithmanoj.com/2013/12/05/preparing-for-70-463-exam-implementing-a-data-warehouse-with-microsoft-sql-server-2012/[/url]

  • manub22 (4/16/2015)


    Yes, the book is worth purchasing, but you can also refer to the MSDN BoL. Check here you will get the links to the required study material to go thru.

    Link: http://sqlwithmanoj.com/2013/12/05/preparing-for-70-463-exam-implementing-a-data-warehouse-with-microsoft-sql-server-2012/[/url]

    It was nice the first 20 times you posted this. Now it's more like spam. Give it a break, please.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • My apologizes @jeff and other users.

    I thought to reply on some related threads, but didn't realized that I was doing this too much.

    Sorry for spamming.

  • SSC Rookie - I realize it's been a while since you passed the 70-463 exam but I was wondering what your thoughts were on the official training kit you used. I'm studying for that exam but I'm not getting a warm-fuzzy on the comments I've read about that book. Most say it's really bad and doesn't really prepare you for the test as well as the exercises not working properly. Thanks.

  • hey,

    Well the book is pretty old now, so if you go though the errata I'd imagine a lot of the mistakes will be reported. If you use a pencil, you better have a sharpner on you as well!

    The book is dry, I mean real dry. A good move it so watch the MVP videos, the guys that do that are entertaining, and you'll learn alot in a shorter time.

    Get yourself the transcender exams for it, I found them to be decent enough, the added advantage with those is that you get good links to info in the answers. I tend to use them last to see where I'm at.

    But, at the very least, read the book with a pot of coffee in you. With the errata, most of the exercises may now work,and if they do not, you may just learn more finding out why (even if it is frustrating ), because almost nothing will work first time in the real world.

    Good luck. Stay away from dumps.

    Regards,

    D.

  • Thanks. Much appreciated.

  • I passed today... 716! I was so happy and relieved.

    The training kit is very dry and the MVA videos are more comedy than instruction videos :doze:

    The MVA videos provide a basic outline, while the training kit, hmm... you'd want the patience of a saint with some of the blocks of text. I ran into some errors with the exercises, some due to my setup which I could fix, others I just abandoned. BUT do the exercises anyway, install everything you can, SQL Studio, SSIS, DQS, MDS. It's important to practice particularly the items you don't have experience with.

    I bought the MeasureUp online practice exams and I really liked the layout and the explanations. However, there was low to medium crossover with the real test. While the dump questions were more similar to the test for obvious reasons but the answers can be bogus, try verify them yourself.

  • I started with the MVA videos but decided they weren't going to help me that much for the time involved.

    Congrats on the exam!

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply