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

1  Plan Business Intelligence (BI) Infrastructure

1.1  Plan for performance

  • <<Add your resources here>>
  • <<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>>
  • <<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>>