Infosys Certified Microsoft SSIS Developer
Practice with real exam-pattern questions for Infosys Certified Microsoft SSIS Developer. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Microsoft SSIS Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Microsoft SSIS Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
What is the extension of a package in SSIS project?
- ✓ .pkg Correct
- B .pckg
- C .dtxs
- D .dtsx
- Question 2
When a database source is used in SSIS to extract data, SQL data types are converted into equivalent SSIS data types. Which of the following terms best describes this behavior?
- ✓ Implicit Conversion Correct
- B Explicit Conversion
- C Data Adaptation
- D None of the above
- Question 3
While copying data from source with Text DT_STR as data type to destination with Unicode String DT_WSTR as data type, _________ transformation is required.
Choose the appropriate option to fill up the blank.
- ✓ Derived Column Correct
- B
Data Conversion
- C
Copy Column
- D
No transformation required
- Question 4
Which tab in SSIS designer is used to configure various tasks?
- ✓ Connection Configuration Correct
- B Task Manager
- C Control Flow
- D Data Flow
- Question 5
How many different categories can components of a Data Flow task be broadly categorized into?
- ✓
1 - Transformations
Correct - B
3 - Sources, Transformations, Destinations
- C
2 - Sources & Destinations
- D
More than 5
- ✓
- Question 6
Which transformation should be used to combine two data sets when the data sets are not necessarily sorted?
- ✓ Merge Correct
- B Union
- C Union All
- D All of above
- Question 7
How can the quotes in a flat file be eliminated from being uploaded to a SQL Server table?
- ✓ By specifying ROW DELIMETER as quotes in FlatFileConnection Manager Correct
- B By specifying COLUMN DELIMETER as quotes in FlatFileConnection Manager
- C By specifying TEXT QUALIFIER property as quotes in FlatFileConnection Manager
- D By specifying TEXT QUALIFIER property as quotes in OLE DB Connection Manager
- Question 8
Which of the below are properties of synchronous transformations?
- 1:1 relation between input & output rows
- Block data flow in pipeline
- Share the same buffer set/memory between input & output
- Execute slower than asynchronous transformations
- ✓ i only Correct
- B i and iv only
- C i and iii only
- D ii and iv
- Question 9
Which of the following is used to create data movement using source, transformation, and destination components in a package?
- ✓
Connection manager
Correct - B Control Flow Task
- C
Execute SQL Task
- D Data Flow Task
- ✓
- Question 10
Which of the below options decides when and in which order the tasks in SSIS must be executed?
- ✓ Precedence Constraint Correct
- B Priority Constraint
- C Data Flow
- D Order in which tasks were placed in Control Flow tab
More in DNA
Infosys Certified Databricks Analyst
Infosys Certified Snowflake Advanced Developer
Infosys Certified Tableau Desktop Advanced Developer
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.