Become a GOLD Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. Import and Export
b. Copy and Import
c. Export and Bulk Insert
d. None of the mentioned
Reveal Answer
Options:
a. Prior to SSIS, Data Transformation Services (DTS) in SQL Server 2000 performs the tasks with fewer features
b. SSIS is used to perform operations like loading the data based on the need, performing different transformations on the data like doing calculations
c. Business Intelligence Development Studio (BIDS) is a tool which can be used to develop only SSIS packages
d. All of the mentioned
Reveal Answer
Options:
a. Plan for capacity by understanding resource utilization.
b. SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
c. Baseline source system extract speed
d. All of the mentioned
Reveal Answer
Options:
a. Software Contention
b. Application contention
c. Processor contention
d. None of the mentioned
Reveal Answer
Options:
a. SSIS moves data as fast as your network is able to handle it
b. It is important to understand your network topology and ensure that the path between your source and target have both low latency and high throughput
c. Integration Services can be tuned beyond the speed of your source
d. All of the mentioned
Reveal Answer
Options:
a. Process Bytes
b. Public Bytes
c. Private Set
d. All of the mentioned
Reveal Answer
Options:
a. Page sec
b. Page Reads
c. Memory reads
d. All of the mentioned
Reveal Answer
Options:
a. Making use of parallelism
b. Not making use of parallelism
c. Package uses few single-threaded tasks
d. None of the mentioned
Reveal Answer
Options:
a. Network Bytes
b. Network Transfers
c. Memory reads
d. None of the mentioned
Reveal Answer
Bestdotnet google plus