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  Design Database Structure

1.1  Design for business requirements

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

1.2  Design physical database and object placement

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

1.3  Design a table and index partitioning strategy

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

1.4  Design a migration, consolidation, and upgrade strategy

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

1.5  Design SQL Server instances

  • <<Add your resources here>>

1.6  Design backup and recovery

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

2  Design Databases and Database Objects

2.1  Design a database model

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

2.2  Design tables

  • <<Add your resources here>>

2.3  Design for concurrency

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

2.4  Design T-SQL stored procedures

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

2.5  Design a management automation strategy

  • <<Add your resources here>>

2.6  Design for implicit and explicit transactions

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

3  Design Database Security

3.1  Design an application strategy to support security

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

3.2  Design database, schema, and object security parameters

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

3.3  Design instance-level security configurations

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

4  Design a Troubleshooting and Optimization Solution

4.1  Design a maintenance strategy for database servers

  • <<Add your resources here>>

4.2  Troubleshoot and resolve concurrency issues

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

4.3  Design and implement a High Availability solution

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

4.4  Design a solution to monitor performance and concurrency

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

4.5  Design a monitoring solution at the instance level

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