ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

MS SQL Server 2008 Administration Test

Our MS SQL Server 2008 Administration test measures your knowledge of administering Structured Query Language Server 2008 databases. Designed for experienced administrators, but an average performer in this role should pass this test. This test covers the following topics: Administrative Tools and Utilities, Architecture, Backup and Restore, High Availability Functions, Index Management, Replication, Security, and Troubleshooting.



Scope of the Online MS SQL Server 2008 Administration Test

Administrative Tools and Utilities
CMD Utility
SQL Server Configuration Manager
SQL Server Management Studio
Architecture
Data Types
Installation
Online Database Maintenance Operations
Transaction Isolation Levels
Upgrade
Backup and Restore
Backup
Master Database Recovery
Restore
Transparent Data Encryption
High Availability Functions
Clustering
Database Mirroring
Log Shipping
Index Management
Index Management Commands
Partitioned Indexes
XML Indexes
Replication
Replication Monitor
Replication Topology
Replication Types
Security
Database Users and Roles
Principals, Securables and Permissions
Schema
Server Logins and Role
Troubleshooting
Extended Events
Performance Data Collector
Performance Monitor
Query Performance Tuning
SQL Profiler

Duration

40 minutes.

More links

Related Professions

Database Administrator, Windows System Administrator

Keywords

sql server 2008 administration assessment test, clickatest sql server 2008 administration assessment test, sql server 2008 administration test, information technology, computers, IT industry