Infosys Certified Microsoft SSIS Advanced Developer
Practice with real exam-pattern questions for Infosys Certified Microsoft SSIS Advanced 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 Advanced Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Microsoft SSIS Advanced Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Mr. Darekar’ s client uses SQL server 2008. But now his client has bought a new Server machine with new Hardware configuration and has got SQL server 2012 installed on it. Client has decided to discontinue with SQL server 2008 but wants to use existing databases in new SQL Server 2012. So Mr. Darekar has been asked to move all existing databases available on SQL Server 2008 to SQL server 2012. Which Task/Transformation in SSIS will be the best option to do the same?
- ✓Transfer Database Task with copy optionCorrect
- BCopy Database Task
- CDatabase Transformation
- DTransfer Database Task with move option
- Question 2
Mr. Shinde is defining a package to perform an ETL job. After successful execution of package Mr. Parekh should be notified about it. Which feature of SSIS can be used to fulfil this expectation?
- ✓SMS AlertCorrect
- BSQL warning
- CEmail
- DNot Possible
- Question 3
You are creating an SSIS project. You want to track progress of SSIS package execution. Which option will you use to do the same after deploying package?
- ✓Progress TabCorrect
- BEvent Handling
- CLogging
- DExecution Status
- Question 4
Which transformation is used to convert row data into columns.
- ✓PIVOTCorrect
- BUNPIVOT
- CROW TO COLUMN
- DCOLUMN TO ROW
- Question 5
Which of the following authentication is not supported by SMTP connection manager in “Send Mail Task” ?
- ✓Anonymous authentication.Correct
- BWindows authentication.
- CBasic authentication.
- DAll of the above.
- Question 6
Which of the following specifies the effect of setting Append and Truncate options to true in export column transformation?
- ✓Creates a new file and writes the data to the file.Correct
- BAppends the data to the existing file.
- CFails design time validation.
- DRun time error.
- Question 7
Which of the following is not true about pivot transformation?
- ✓Converts the unique values from one column in the expression into multiple columns in the output.Correct
- BConverts the duplicate values from one column in the expression into multiple columns in the output.
- CPerforms aggregations wherever required.
- DUsed for normalization.
- Question 8
Mr. James who is an SSIS developer has been assigned a task to copy EMPLOYEE table from default instance of SQL server 2012 to given named instance of SQL server 2012. Which Task will be the best option to do the same?
- ✓Transfer Database TaskCorrect
- BTransfer Table Task
- CTransfer SQL Server Objects Task
- DAll of the above
- Question 9
Which of the following combinations of operations are mutually exclusive in character map transformations?
- ✓lowercase, uppercaseCorrect
- Blowercase, halfwidth
- Cuppercase, fullwidth
- DAll of the above
- Question 10
Which of the following could be used to change casing (Uppercase to Lowercase or vice-versa) of data in a particular column of an Excel source?
- ✓Data Conversion or Derived ColumnCorrect
- BAggregate or Data Conversion
- CData Conversion only
- DCharacter Map or Derived Column
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.