This SQL Server 2014 for Developers test has been designed to verify the ability of a developer to effectively work in a SQL 2014 environment. Topics covered by this test include data types, SQL programming, transaction management, tools and utilities, system stored procedures, and understanding code. This assessment is appropriate for developers that have at least a year or more of SQL Server 2014 experience. Total Questions 48 Question Types Multiple Choice Competencies Tested System Stored ProceduresTools and UtilitiesTransaction ManagementSQL ProgrammingUnderstanding Code Tasks Tested System Stored ProcedureAccess Database ObjectsDatabase Object DetailsOLE Automation ObjectsSET NOCOUNT ONSQL Server ProfilerRecreating ObjectsImport/Export DataTracking Changes to DataNew User Database CreationDatabase SchemasCTE UsageRDL File FormatRowversionQuery to View RecordsTasks in Integration Services PackageISNULL and COALESCEService Broker QueuePredicate for Full-Text SearchPerforming Mass UpdatesPrefix N for String ConstantsIndex on Date ColumnsObject in FROM ClauseTruncate TableDelayed Transaction DurabilityHekatonIn-Memory OLTP ImplementationTable-Valued Function UsageValid Data TypesData Types for Full-Text SearchTinyint Data TypeService Broker EnablementMemory-Optimized TablesModifying XML DataXMLSCName Column ValuesINFORMATION_SCHEMAQuerying XML DataEvaluate StatementsStructured Error-HandlingDynamic SQL in ProceduresTransaction ManagementAPPLY Operator UsageImplementing Database MailQuery ReturnPoor Query PerformanceQuery Review
