SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


70-466


70-466

Author
Message
pollypranbora
pollypranbora
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 115
Can anyone give me any guidance on training kits for 70-466 exam?Thanks in advance for your help.
TheComedian
TheComedian
Mr or Mrs. 500
Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)

Group: General Forum Members
Points: 559 Visits: 510
I'm actually interested in this myself. Just got my MCSA for SQL Server 2012 today and want to move on to the MCSE (BI Edition). There don't appear to be any training kits available from Microsoft at the moment. So can somebody please tell me:

1) Is there a target date for when the training kits for 70-466 and 70-467 will be released? If nobody knows, do you know a contact at Microsoft from whom I can inquire this?
2) If Microsoft isn't planning on releasing the training kits, is there any third party that will or that will at least give some preparation for this exam? No course though, my employer is not willing to dish out 2.000 + Euros for this.
3) Can anybody at least recommend any book(s) for this exam?

I'm not willing to write these exams without any prior preparation since if I am to ask my employer to sponsor me, I want to be sure that I can provide results.
tim.squires
tim.squires
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 437
We are also interested in finding prep material for both 466 and 467.

There are people in my org that have recently completed 461, 462 and 463 and now have their MCSA: SQL Server 2012 certification.

They are eager to move on to 466 and 467 to get the MCSE: Business Intelligence cert but cannot find any study material.

Seems odd since (I think) these exams have been out there for more than a year.

Anyone have any helpful suggestions?
Steve Jones
Steve Jones
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: Administrators
Points: 146414 Visits: 19430
Haven't found much on these exams. I did find this advice: http://byobi.com/blog/2013/04/passed-70-466-and-70-467-exams-study-guides/

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
r.arnold
r.arnold
SSC Rookie
SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)SSC Rookie (32 reputation)

Group: General Forum Members
Points: 32 Visits: 38
From the Microsoft certification site (http://www.microsoft.com/learning/en-us/sql-certification.aspx):

Q.How will the updates for SQL Server 2014 impact official Microsoft training and certifications?
A.SQL Server 2014 certifications will only be offered at the MCSE level. The new product features focus on performance tuning and high availability and are best suited for the MCSE level. As a result, the following updates are planned:

•The MCSA: SQL Server 2012 credential and associated exams (461/462/463) will remain in market without any alterations. No MCSA: SQL Server 2014 credential will be offered.

•In March 2014, the MCSE: Data Platform (464/465) and MCSE: Business Intelligence (466/467) exams will be appropriately updated with SQL Server 2014 topics. The exam numbers will remain the same.

At least one month prior to the update, details on the original and revised exam objectives will be made available for review in the Skills measured section of each exam detail webpage.

•Also in March 2014, recertification options for maintaining the MCSE credentials will be made available.



I suspect that this is the reason why none of these training kits (464,465,466,467) have been published yet since they intend on updating the objectives and exam content in a few months.
TheComedian
TheComedian
Mr or Mrs. 500
Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)Mr or Mrs. 500 (559 reputation)

Group: General Forum Members
Points: 559 Visits: 510
Passed the 70-466 after 3 months. Thanks everybody for your help.

Steve - The list in the link is a bit exhausting but I prepared with the following materials:

- Microsoft SQL Server 2008 MDX Step By Step
- Microsoft SQL Server Analysis Services 2008 Step by Step
- Pro Sql Server 2012 BI Solutions - A very straight forward, step by step general overview of BI with SQL Server
- Professional Microsoft SQL Server 2012 Reporting Services - very detailed book on SSRS (both Sharepoint and Native mode)
- Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model - I had no experience with the Tabular model prior to this book and even though DAX is extremely difficult to grasp compared to the Multidimensional Model and MDX, this book does a good job of guiding you through. Just make sure to read it twice, since the material is difficult.
- Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide ( http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx#MicrosoftSQLServerAnalysisServicesMultidimensionalPerformanceandOperationsGuide ) - This book is very abstract and will over prepare you for the performance based questions
- The following whitepaper: http://www.microsoft.com/en-us/download/details.aspx?id=137

Overall there is a lot to know for the exam: SSRS - both Native and Sharepoint mode, SSAS - both Multidimensional and Tabular, Data Warehouse architecture so I would suggest that anybody takes their time.
Graham Whiteman
Graham Whiteman
SSC Journeyman
SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)SSC Journeyman (89 reputation)

Group: General Forum Members
Points: 89 Visits: 123
I have just found a package by www.quickcert.com, has anyone had any experience with these? The main benefit I see is that they should focus on what you need to know.
Unfortunately due to time constraints, I can't afford to spend time in material that is less relevant.

http://www.quickcert.com/microsoft/mcse-business-intelligence-195888m
Cody Konior
Cody Konior
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1045 Visits: 1110
Graham Whiteman (6/16/2014)
I have just found a package by www.quickcert.com, has anyone had any experience with these?


No but if you do a search they have a t-e-r-r-i-b-l-e reputation.
wood.kieran
wood.kieran
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 76
I know this is an old question. However my reply maybe helpful for someone.
I passed the 70-466 exam with the help of; - http://www.selftestsoftware.com/certtestprep/practice-test/microsoft/70-466.kap.

Continual reference to; - https://www.microsoft.com/learning/en-us/exam-70-466.aspx

Books; -

SQL Server Analysis Services 2012 Cube Development Cookbook
By: Baya Dewald; Paul Turley; Steve Hughes
Publisher: Packt Publishing
Pub. Date: December 26, 2013
Print ISBN-13: 978-1-84968-980-9

Microsoft® SQL Server® 2012 Analysis Services: The BISM Tabular Model
By: Marco Russo, Alberto Ferrari, and Chris Webb
Publisher: Microsoft Press
Last Updated: 19-APR-2015
Pub. Date: July 15, 2012 (Estimated)
Print ISBN: 978-0-7356-7009-9

Professional Microsoft SQL Server 2012 Reporting Services
By: Paul Turley; Robert M. Bruckner; Thiago Silva; Ken Withee; Grant Paisley
Publisher: Wrox
Pub. Date: June 5, 2012
Print ISBN: 978-1-118-10111-7

Working through the following tutorials; -

https://msdn.microsoft.com/en-us/library/hh231701.aspx?f=255&MSPPError=-2147217396

https://msdn.microsoft.com/en-us/library/bb522859(v=sql.105).aspx

I hope this helps.

Kind Regards,

Kieran.
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