question archive Q1) Where are scheduled SSIS packages executed ? A
Subject:Computer SciencePrice:2.87 Bought7
Q1) Where are scheduled SSIS packages executed ?
A. Visual Studio B.SQL Server Agent Job C.SSIS Maintenance Deployment D.Scheduling manager D.Variables
Q2. What are the two ways to provide security
A.User Encryption and System Encryption B.Package Encryption and Password Protection C.Control Flow Encryption and Data Flow Encryption D. None of the Above
Q3. Which of the following is NOT a Package Configuration Type?
A.XML configuration file B.Environment Variable C.Derived Configuration D.Parent package variable E.SQL Server table
Q4. Importing a package from within SQL Server Management Sudio is what type of deployment?
A.Encrypted Deployment B.Task Deployment C.Push Deployment D.Pull Deployment
Q5. Deploying a package into a server by running the Package Installation wizard, is which type of deployment?
A.Task Deployment B.Push Deployment C.Pull Deployment E.Encrypted Deployment
Answer:
Q1. Where are scheduled SSIS packages executed ?
B.SQL Server Agent Job
Q2. What are the two ways to provide security
B.Package Encryption and Password Protection
Q3. Which of the following is NOT a Package Configuration Type?
C.Derived Configuration
Q4. Importing a package from within SQL Server Management Sudio is what type of deployment?
D.Pull Deployment
Q5. Deploying a package into a server by running the Package Installation wizard, is which type of deployment?
B.Push Deployment