Become a GOLD member of Deccansoft and get access to 40+ courses!!
NewBatches/Webinars
Packages
Gold Membership
Bestseller
Microsoft Azure Suite & Suite Plus
Power Platform Acadamy
New
Azure DevOps Expert & Expert Plus
MS.NET Foundation For Beginners
MS.NET Full Stack Developer
UI / Web Development
SQL Server & MSBI Tools
Software Testing
Courses
MS.NET Courses (Includes Live Project)
Complete C#, OOPs and Windows Programing
ASP.NET MVC Online Training
ASP.NET WebForms
ASP.NET Core
WCF incl. Web Services and Remoting
WPF incl. MVVM and Prism
LINQ and Entity Framework
Live Project Training for Developing Enterprise Application
Live Project using Ntier Arch (.NET5 + EF Core + Angular)
Gold Membership
CareerStep IT Program
Client-side UI Technologies
Building Static Web Pages using HTML and CSS
JavaScript and HTML DOM
jQuery, AJAX and JSON
Building Interactive Web Pages using HTML5 and CSS3
BootStrap + Live Examples
AngularJS + Live Project
Angular + Typescript
ReactJS
KnockoutJS
Xamarin
SQL Server + MSBI
SQL Server 2017
Querying Data with Transact-SQL(70-761)
SQL Server Integration Service (SSIS)
SQL Server Reporting Service (SSRS)
SQL Service Analysis Service (SSAS)
Cloud Computing / Azure / AWS
AZ-900: Microsoft Azure Fundamentals
Azure Suite (AZ-104+AZ-204+AZ-305+ AZ-500)
AZ-104: Microsoft Azure Administrator
AZ-204: Developing Solutions for Microsoft Azure
AZ-305: Microsoft Azure Architect Technologies and Design
AZ-400: Microsoft Azure DevOps
DP-203: Data Engineering on Microsoft Azure
Amazon Web Services (AWS)
Testing Tools
Manual Testing
Selenium Testing with Java(Live Training)
SharePoint
SharePoint 2013
Microsoft Power Platform
Microsoft Power Platform
Data Analytics using PowerBI (DA-100)
DevOps
Docker
Kubernetes
Microservices using .NET Core
Others
C and Data Structure
Core Java
OOPs and C++
Advance Java
Python Programming
Complete Azure Training
Pricing
Videos
Testimonials
Azure Certification
Contact Us
Login
Login or Register
×
Sign In
Register
Forgot Password?
How did you find us
WhatsApp
YouTube
LinkedIn
Facebook
Telegram
Twitter
Google
Referred by Friend
Refresh
Input symbols
By clicking Register, you accept to the
terms and conditions
and that you have read our
privacy policy.
Recover Password
×
Submit
Enquiry Now
Where did you come to know about us
WhatsApp
YouTube
LinkedIn
Facebook
LinkedIn Ad
Email
Twitter
Google
Referred
Other
Refresh
Input symbols
Data Flow Task
Interview Questions and Answer
1. You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on Server A. The package includes a data flow and is executed on Server B. The destination table has its own identity column. The destination data load has the following requirements: ?1. The identity values from the source table must be used.?2. Default constraints on the destination table must be ignored.?3. Batch size must be 100,000 rows. You need to add a destination and configure it to meet the requirements. Which destination should you use?
Options:
a. OLE DB Destination with Fast Load.
b. ADO NET Destination without Bulk Insert.
c. OLE DB Destination without Fast Load.
d. SQL Server Destination.
Reveal Answer
2. How many types of SSIS connection managers are there?
Options:
a. 4
b. 5
c. 6
d. 19
Reveal Answer
3. You are creating a SQL Server 2008 Integration Services (SSIS) data flow which moves information to a SQL Server 2008 database for Company.com. You should make sure that data flow refreshes the existed data in the SQL Server database through utilizing data in your data flow. Which is the correct answer?
Options:
a. You should utilize Data Conversion Transformation
b. You should utilize SQL Server Destination
c. You should utilize OLE DB Destination
d. You should utilize Dynamic Management View (DMV)
Reveal Answer
4. What does a control flow do?
Options:
a. To control workflow
b. To control events
c. To control data flows.
d. To control lookup
Reveal Answer
5. SSIS 2008 configuration types?
Options:
a. Five
b. Four
c. Three
d. One
Reveal Answer
6. Which section of your package manages the overall process flow for the entire package?
Options:
a. Data Flow
b. Connection Manager
c. Control Flow
d. Package Explorer
Reveal Answer
7. Which of the following Data Flow tasks require that the data be sorted prior to their execution?
Options:
a. Pivot
b. Merge Join
c. Conditional Split
d. Pivot & Merge Join
Reveal Answer
8. Which of the following is not a valid Evaluation Operator for a Precedence Constraint?
Options:
a. Expression
b. Constraint
c. Variable
d. Expression or Constraint
Reveal Answer
9. Which Data Flow Destination would be the most appropriate for sending a quick dump of data to a customer?
Options:
a. Raw File
b. OLE DB
c. Recordset
d. Excel
Reveal Answer
10. Database maintenance tasks can be performed directly in SSIS packages.
Options:
a. True
b. False
Reveal Answer
11. Which of the following is not an option when configuring Error Outputs on Data Flow Tasks?
Options:
a. Fail Component
b. Ignore Failure
c. Redirect Row
d. Log Failure
Reveal Answer
12. You can use Expression to set the values of SSIS variables?
Options:
a. True
b. False
Reveal Answer
13. Which of the following is only available as a Data Flow Destination and not a source?
Options:
a. Excel
b. Raw File
c. OLE DB
d. Recordset
Reveal Answer
Packages
Gold Membership
Microsoft Azure Suite &Suite Plus
Azure DevOps Expert &Expert Plus
MS.NET Foundation For Beginners
MS.NET Full Stack Developer
UI / Web Development
SQL Server & MSBI Tools
Software Testing
Resources
Blog
Deccansoft
AzureA2Z
Wall of Fame
On-Job Tech Support
About
About BestDotNetTraining
About Trainer
Testimonials
FAQ
Other links
About Us
Contact Us
Leave us a feedback
Sitemap
Privacy Policy
Terms & Conditions
Proudly Powered by