http://www.sqlservercentral.com/blogs/sqlrnnr/2011/06/30/70_2D00_450-study-guide/

Printed 2014/10/21 02:23PM

70-450 Study Guide

By Jason Brimhall, 2011/06/30

In my last post concerning my certification journey I said I may post a study guide.  I have thought it over and a sweetened condensed version of some of the topics covered would prove helpful.  Based on the Skills Measured page for the exam, one can determine topics to study and pretty much google for related materials.

So let’s start with the high level of skills measured.

Designing a SQL Server Instance and a Database Solution

Partition Switching

Collecting Data in regards to upgrade prep or installation and base-lining.

Best Practices

Capacity Planning

Compression

Designing a Database Server Security Solution

Encryption

Context Switching

Filestream Storage

SSRS Authentication

CLR

Designing a Database Solution for High Availability

Publishing Data

Database Mirroring

Clustering

Physical Architecture (Replication)

Designing a Backup and Recovery Solution

I won’t cover this topic at all.  This should be a high priority topic for all Database Professionals.  This is one of those areas that is best covered through practice and experience.

Designing a Monitoring Strategy

Correlate Monitoring Data – One should be acquainted with this topic.  I have heard it in interviews.  Furthermore, it really makes you a better DB professional.

Data Collectors

DMVs

Designing a Strategy to Maintain and Manage Databases

Filestream

Central Management Server

Resource Governor

Policy Based Management

Designing a Strategy for Data Distribution

SSIS Deployment

Distributed Transactions

SSIS Security

Linking Servers

 

As I said, this is a condensed version of some of the topics that I studied.  Since these topics map directly back to the measured skills published by Microsoft, they are topics well worth studying.  Whether or not they will be on your exam or not, who knows.  You should also note, that these links pretty much point back to broad-sweeping topics and are not specific in nature.  The one exception being the extra monitoring link I threw in because I feel it is important to know regardless of ability or exam preparation.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.