Reminder: Some of the content contained on these wiki pages is contributed by members of the community and Microsoft provides no specific endorsement for any third party resources listed here. Please review the Code of Conduct and Terms of Use for detailed guidelines.

Database Certification Exam Prep Resources

Rate This:

467: Designing Business Intelligence Solutions with Microsoft SQL Server

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

  • Skills Measured (Microsoft Learning)
  • Chris Barker's Curah site
    • Content Chris Barker (MCT Regional Lead, NZ) presented at TechEd New Zealand on this topic

  • <<Add your resources here>>

Learning plans and classroom training

Prep resources by objective

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 high availability and disaster recovery 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>>