This SQL Server Integration Services test focuses on the skills that are needed to use SSIS to build high-performance data integration solutions. The areas addressed by this assessment include control and data flow, error logging, package deployment and management, scripting and custom components, and variable configuration. This test is appropriate for those knowledgeable in SQL Server Integration Services with more than a year of experience. Total Questions 39 Question Types Multiple Choice Competencies Tested Control FlowVariables & ConfigurationPackage ManagementData FlowScripting & Custom ComponentsPackage DeploymentError Logging Tasks Tested SSIS ContainersWorkflow TasksPrecedence ConstraintsSQL Server Maintenance PlansAdditional Control Flow TasksControl Flow TasksBackward Compatibility TaskImport CSV File to a SQL TableMoving Table DataTransactions Support in SSISConnectionsError OutputsUnderstanding VariablesAdding a Variable to a PackageUnderstanding ConfigurationVariable TypesCreate a Package Deployment UtilityRestrict AccessRoles-Based SecurityExecuting PackagesManaging Packages with DtutilScheduling PackagesWorking with Error OutputsData Flow TransformationConnection ManagerData ViewersBest Practices for Package DesignHTML E-mail MessageForEach Loop EnumeratorSSIS ScriptingCustom ObjectsDisconnected ModeDeployment ChallengesDeploy a Package to SQL ServerProtection Level PropertyCheckpointsPackage LoggingInvalid Event Hander
Related