SQL Server 2014 DBA Assessment

  • $10.00


This MS SQL Server 2014 DBA assessment is designed to assess the assessment taker's knowledge and familiarity with using DBA from some of the basic understanding to some advanced level questions. It also contains questions related to new features of SQL SERVER 2014. It contains questions of the following types DATA BACKUP RECOVERY, NEW FEATURE, SQL SERVER FEATURE, POLICY MANAGEMENT, TRANSACT-SQL, TRIGGER, PERFORMANCE IMPROVEMENT, SQL SERVER FUNCTIONS, SECURITY, SQL SERVER UTILITY, SQL SERVER OPERATORS, STORED PROCEDURE, UDF (USER DEFINED FUNCTIONS)

Number of questions 39
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered DATA BACKUP RECOVERY
NEW FEATURE
PERFORMANCE IMPROVEMENT
POLICY MANAGEMENT
SECURITY
SQL Query
SQL SERVER FEATURE
SQL SERVER FUNCTIONS
SQL SERVER OPERATORS
SQL SERVER UTILITY
STORED PROCEDURE
TRANSACT-SQL
TRIGGER
UDF (USER DEFINED FUNCTIONS)
Tasks tested CHOOSE CORRECT OPTION
Connection Permission and Encryption Support
Disaster Recovery Installation
Hash Index Performance
Heavy Duty Queries and Stored Procedures
Hekaton
IDENTIFY CORRECT FEATURE
IDENTIFY FEATURE
Logical Backup Devices
Logical Join
Message Infrastructure
Performance Improvement Technique
Post SQL Command Execution
Query Hints
RAID Levels
Service Broker Dynamic Management View
Strict Isolation Level
Sys.dm_db_index_usage_stats DVM
Syspolicy_policies Results
System Health Policy
Truncate Command
URL Backup
Window Function Benefit
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)