SQL Server 2014 DBA Assessment

$16.00

SQL Server 2014 DBA Assessment

$16.00
description

This MS SQL Server 2014 DBA test is designed to assess the test 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)

 

Total Questions 39
Question Types Multiple Choice
Competencies Tested DATA BACKUP RECOVERY
NEW FEATURE
SQL SERVER FEATURE
POLICY MANAGEMENT
TRIGGER
PERFORMANCE IMPROVEMENT
SQL SERVER FUNCTIONS
SECURITY
SQL SERVER UTILITY
SQL SERVER OPERATORS
STORED PROCEDURE
TRANSACT-SQL
UDF (USER DEFINED FUNCTIONS)
SQL Query
Tasks Tested CHOOSE CORRECT OPTION
RAID Levels
Logical Backup Devices
Disaster Recovery Installation
Hekaton
Message Infrastructure
URL Backup
Strict Isolation Level
IDENTIFY FEATURE
IDENTIFY CORRECT FEATURE
Service Broker Dynamic Management View
Syspolicy_policies Results
System Health Policy
Post SQL Command Execution
Sys.dm_db_index_usage_stats DVM
Performance Improvement Technique
Hash Index Performance
Window Function Benefit
Connection Permission and Encryption Support
Heavy Duty Queries and Stored Procedures
Query Hints
Truncate Command
Logical Join