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 RECOVERYNEW FEATURESQL SERVER FEATUREPOLICY MANAGEMENTTRIGGERPERFORMANCE IMPROVEMENTSQL SERVER FUNCTIONSSECURITYSQL SERVER UTILITYSQL SERVER OPERATORSSTORED PROCEDURETRANSACT-SQLUDF (USER DEFINED FUNCTIONS)SQL Query Tasks Tested CHOOSE CORRECT OPTIONRAID LevelsLogical Backup DevicesDisaster Recovery InstallationHekatonMessage InfrastructureURL BackupStrict Isolation LevelIDENTIFY FEATUREIDENTIFY CORRECT FEATUREService Broker Dynamic Management ViewSyspolicy_policies ResultsSystem Health PolicyPost SQL Command ExecutionSys.dm_db_index_usage_stats DVMPerformance Improvement TechniqueHash Index PerformanceWindow Function BenefitConnection Permission and Encryption SupportHeavy Duty Queries and Stored ProceduresQuery HintsTruncate CommandLogical Join
