Infosys Certified Talend Open Studio for Data Integration Developer
Practice with real exam-pattern questions for Infosys Certified Talend Open Studio for Data Integration 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 Talend Open Studio for Data Integration Developer practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Talend Open Studio for Data Integration Developer certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
Choose the best performance optimization.
i. use tFilterRow to remove rows as early as possible
ii. use tFiterColumn to remove columns as early as possible
iii. use store on disk option
iv. split Talend job to smaller subjobs
- ✓ i, ii, iii, iv Correct
- B i , ii, iv
- C i, ii, iii
- D i, iii, iv
- Question 2
The Best practice is to create variables in tMap and use the variables to assign the value to Target fields.
- ✓ True Correct
- B False
- Question 3
Ms. Amy wants to pass the parameter and variables from parent job to child job. She is wondering, how to do this in Talend? Suggest her the steps to be followed.
i. create Parent Job and Child job
ii. Assign context variable to child job
iii. In Parent job pass the context variable to parameter
iv. Assign the value for parameter
v. Execute the job
- ✓ i, ii, iii, iv, v Correct
- B i, ii, iv, iii, v
- C i, iii, ii, iv, v
- D i, iv, ii, iii, v
- Question 4
Mr. Jack is wondering whether he can dynamically choose the Database name and Database username for different groups like PRD, ADM, QA for executing different jobs.
- ✓ yes, it is possible with context group variable Correct
- B not possible in Talend
- C yes, it is possible with parameter
- D none of the options are valid
- Question 5
In Talend, what are the different export type options are available?
i. Autonomous Job
ii. Axis Webservice(WAR)
iii. Axis Webservice(ZIP)
iv. JBOSS (ESB)
v. PETALS (ESB)
- ✓ i,ii,iii,iv,v Correct
- B i,iii,iv,v
- C i,ii,iv,v
- D i,ii,iii,iv
- Question 6
Ms. Jessy, the ETL developer is working on the Talend Open Studio for Data Integration. She observes that data is being passed from MS SQL Server Source is having data type mismatch. So, help her in identifying the component?
- ✓ tConvertType Correct
- B tSplitRow
- C tAssert
- D None of the options are valid
- Question 7
Ms. Jessica is working on the data integration process. There are two tables, namely, “Product” and “Sales”. She is wondering how to join these two tables with Talend open studio tool?
- ✓ tJoin Correct
- B tJoinRow
- C tDeNormalize
- D None of the options are valid
- Question 8
Mr. Arun is working on TOS- Data Integration tool. He wants to apply filter condition based on profit amount > 50000 and also, he needs store rejected record in another target. Which component will be used for this job?
- ✓ tFilterRow Correct
- B tFilter
- C tFilterColumn
- D None of the options are valid
- Question 9
Mr. Arun works on TOS ETL tool. He has the requirement to convert the gender column Male as M and Female as F. Identify the component that replace gender column.
- ✓ tReplace Correct
- B tConvert
- C tReplaceRow
- D None of the options are valid
- Question 10
Ms. Amy has 100000 rows, she wants to read only first 50000 rows for denormalizing. Suggest her the component, which will have option to specify the input rows count.
- ✓ tDenormalizeSortedRow Correct
- B tDenormalizeRow
- C tSortRow
- D None
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.