Designing Business Intelligence Solutions with Microsoft SQL Server
I want to know that where can we find the study guide or training kit for the certification on MCSA: SQL Server 2012 and then MCSE: Business Intelligence. I have browsed in Microsoft site but couldn't found . Also, I searched in Microsoft Virtual Academy but I couldn't found the detail on those topics.
It will be helpful if someone can tell me where do i found such guide materials for this course in other to study and get certified.
I am enrolling on Database track for MCSA . One can learn more through mva.microsoft.com/.../querying-microsoft-sql-server-2012-databases-jump-start
Just passed the 70-466 exam this morning and getting everything together to write 70-467 in about three weeks.
This is the list of resources I am using.
70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012
This is an architecture level exam covering the whole stack (DB Engine, Data Warehouse Design/Implementation, SSIS, SSRS, SSAS, MDS/DQS, Sharepoint integration, etc). For experienced Microsoft BI practitioners, this exam is much easier to prepare for…and that’s because you can’t really prepare for it! The material covered in this exam can only be obtained from actual experience and deliberate practice.
For this exam, you’ll need to understand how the various pieces of the Microsoft BI stack fit together in a solution. And you’ll need to have a deep enough understanding to determine the best solution (from a list of other valid, but less optimal, solutions) for a given task based on information (infrastructure, business requirements, technical requirements, etc) in the case studies.
That said, read the following whitepapers and use MSDN to confirm your understanding of a few features:
• Microsoft BI Authentication and Identity Delegation
• Manage Kerberos Authentication Issues in a Reporting Services Environment
• Reporting Services Scale-Out Architecture (SQL CAT Blog Series)
• Scale-Out Querying for Analysis Services