Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

MS SQL Server 2014 Administration

Description:

Our MS SQL Server 2014 Administration test measures your knowledge of administering Structured Query Language Server 2014 databases. Designed for experienced administrator, this test includes the following topics: Architecture, Backup and Restore, Command Line Tools and Utilities, Database Management, Graphical Tools and Utilities, High Availability, Security, and Troubleshooting.

FREE

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Architecture
Cloud
Data Types
Installation
System Databases
Transaction Isolation Levels
Backup and Restore
Database Backup
Database Recovery Advisor
Database Restore
Server Recovery
Command Line Tools and Utilities
DBCC
Dynamic Management Views
Powershell
SQLCMD Utility
T-SQL
Database Management
Database Mail
Import and Export Operations
Index Management
Upgrade
Graphical Tools and Utilities
Database Engine Tuning Advisor
SQL Profiler
SQL Server Configuration Manager
SQL Server Management Studio
High Availability
AlwaysOn
Clustering
Log Shipping
Replication
Security
Encryption
Principals, Securables and Permissions
Schema
Server Logins and Role
Users and Database Roles
Troubleshooting
Client Connections
Extended Events
Performance
Query Performance Tuning
Server Services