Become a GOLD Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. Orders the work flow of SSIS package
b. Used to perform ETL (Extract, transform, Load) operation
c. It encapsulates the data flow engine that moves data between sources and destinations
Reveal Answer
Options:
a. Tasks
b. Container
c. Precedence constraints
d. All the above
Reveal Answer
Options:
a. For Loop Container
b. While Loop Container
c. Sequence Container
d. Generic Container
Reveal Answer
Options:
a. C#.NET
b. VB.NET
c. T-SQL
d. Java
Reveal Answer
Options:
a. Only variables included in one of these lists can be referenced from a script task
b. These lists are not a feature of the Script Task
c. These lists are used to declare new variables that will be available to subsequent control flow tasks
Reveal Answer
Options:
a. Script Task
b. Expression Task
c. File System Task
d. Data Exploration Task
Reveal Answer
Options:
a. It requires variable to perform operations
b. It does not requires variables to perform operations
c. It requires variables but does not perform operations
Reveal Answer
Options:
a. Sequence Container
b. For Loop Container
c. For Each Loop Container
d. generic container
Reveal Answer
Options:
a. Script Task
b. Backup Data Base Task
c. Backup Sql Task
d. None of the Above
Reveal Answer
Options:
a. By using Transfer Database Task
b. By using Copy Database Task
c. By using Script Task
d. All the Above
Reveal Answer
Options:
a. Copying directories and data files from one directory to another
b. Downloading files from an FTP location
c. All the Above
d. None of the Above
Reveal Answer
Options:
a. Deletes entries in the history tables in the SQL Server msdb database
b. Performs different types of SQL Server database backups
c. Runs SQL Server Agent jobs
d. Checks the allocation and structural integrity of database objects and indexes
Reveal Answer
Options:
a. Expression
b. Constraint
c. All of the above
d. None of the above
Reveal Answer
Options:
a. Event Handlers
b. Control Flow Tasks
c. Data Flow Tasks
d. Maintenance Tasks
Reveal Answer
Options:
a. For loop based on conditions and for each loop based on objects collections.
b. For loop based on objects collections and for each loop based on objects collections
c. None
d. Both a and b
Reveal Answer
Bestdotnet google plus