Preparation Tools and Resources

Search here for prep resources for specific exam topics and add any exam prep resources that you have found helpful in preparing for this exam.

General preparation material

Prep resources by objective

Microsoft Certification PREP Talk: Exam 467

In this episode of Prep tips from certification experts, James Seymour, Certification Planner, and Matthew Roche, Senior Program Manager in the SQL Server product group, discuss the relevancy of the skills being measured in Exam 467.

1  Plan Business Intelligence (BI) Infrastructure

1.1  Plan for performance

  • <<Add your resources here>>

1.2  Plan for scalability

  • <<Add your resources here>>
  • <<Add your resources here>>

1.3  Plan and manage upgrades

  • <<Add your resources here>>
  • <<Add your resources here>>

1.4  Maintain server health

  • <<Add your resources here>>
  • <<Add your resources here>>

2  Design BI Infrastructure

2.1  Design a security strategy

  • <<Add your resources here>>
  • <<Add your resources here>>

2.2  Design a SQL partitioning strategy

  • <<Add your resources here>>
  • <<Add your resources here>>

2.3  Design a backup strategy

  • <<Add your resources here>>

2.4  Design a logging and auditing strategy

  • <<Add your resources here>>
  • <<Add your resources here>>

3  Design a Reporting Solution

3.1  Design a Reporting Services dataset

  • <<Add your resources here>>
  • <<Add your resources here>>

3.2  Manage Excel Services/Reporting for SharePoint

  • <<Add your resources here>>
  • <<Add your resources here>>

3.3  Design a data acquisition strategy

  • <<Add your resources here>>
  • <<Add your resources here>>

3.4  Plan and manage reporting services configuration

  • <<Add your resources here>>
  • <<Add your resources here>>

3.5  Design BI reporting solution architecture

  • <<Add your resources here>>
  • <<Add your resources here>>

4  Design BI Data Models

4.1  Design the data warehouse

  • <<Add your resources here>>
  • <<Add your resources here>>

4.2  Design a schema

  • <<Add your resources here>>
  • <<Add your resources here>>

4.3  Design cube architecture

  • <<Add your resources here>>
  • <<Add your resources here>>

4.4  Design fact tables

  • <<Add your resources here>>
  • <<Add your resources here>> 

4.5  Design BI Semantic Models

  • <<Add your resources here>>
  • <<Add your resources here>> 

4.6  Design and create MDX calculations

  • <<Add your resources here>>
  • <<Add your resources here>> 

5  Design an ETL Solution

5.1  Design SSIS package execution

  • <<Add your resources here>>
  • <<Add your resources here>>

5.2  Plan to deploy SSIS solutions

  • <<Add your resources here>>
  • <<Add your resources here>>

5.3  Design package configurations for SSIS packages

  • <<Add your resources here>>
  • <<Add your resources here>>