Talend Beginner Quiz

 



1) A scheduling tool from BMC software

1. CONTROL M
2. Autosys

Show Answer

 
 
2) Custom code can be created by using ____ components

1. tjava
2. tjavarow
3. tJavaflex
4. A,B&C

Show Answer

 
 
3) t<DBNAME>SPcomponent is used to call Database procedure

1. True
2. FALSE

Show Answer

 
 
4) A flat file cannot be used as the following

1. Source
2. Target
3. Aggregator
4. Lookup

Show Answer

 
 
5) An Active Transformation :

1. Does not change the number of rows that pass through it
2. Represents the data flow between sources and targets
3. Can change the number of rows that pass through it
4. Creates a target definition based on a source definition

Show Answer

 
 
6) Is it possible to lookup operations using Tmap component instead of tJoin

1. True
2. FALSE

Show Answer

 
 
7) To concatenate first name and last name of an employee, which transformation would be used ?

1. Aggregator component
2. tJoin compoent
3. Tmap component
4. Normalizer component

Show Answer

 
 
8) How to place your component in a job?

1. Click it in the palettle and then click in the design workspace
2. click in the Repository and then click ind the design workspace
3. Drag it from the Repository to the design workspace
4. Click it on the Edit Menu

Show Answer

 
 
9) From which view in Talend open studio would you read the comments attached to a component?

1. The problems view
2. The compoent view
3. The job view
4. Both A & B

Show Answer

 



10) How do you run a job in Talend studio?

1. Click on the run button in the run view
2. click the start button in Run view
3. Click the Run button in the job view
4. Click Run on the File Menu

Show Answer

 
 
11) In which user interface element do you find Business Models, Job Designs, and Metadata?

1. The job view
2. The Repository
3. The design workspace
4. The palette

Show Answer

 
 
12) How to add text information to a job?

1. Edit comments box in the Documentation tab on the component view for different components
2. Import a text and attach it to the job
3. Edit the components box in the Documenation tab on job view
4. Add a note component to the design workspace

Show Answer

 
 
13) Which component in Talend help to measure (execution time) between two components

1. Chronometer
2. Flowmeter
3. LogCatcher

Show Answer

 
 
14) tDie component helps to handle the exception in Talend job

1. True
2. FALSE

Show Answer

 
 
15) Which component help to create dummy records in Talend job

1. tlogrow
2. tRowgenerator
3. Tmap component

Show Answer

 
 
16) What type of files can be imported for flat-file source/target definitions in the repository ?

1. Fixed-width
2. Delimited
3. Fixed-width and delimited flat files that do not contain binary data
4. Binary

Show Answer

 
 
17) Is it possible to run a Talend Job with out TAC server ?

1. True
2. FALSE

Show Answer

 
 
18) During the export of a Talend job it will create

1. Windows batch file
2. SH file
3. Both

Show Answer

 
 
19) Context can be build ______and attached to the job

1. in the job
2. in the repository
3. in the context file
4. All the above

Show Answer

 



20) What is SVN ?

1. Is a software versioning and version control system
2. Talend Execution server
3. Adminstration server
4. None

Show Answer

 
 
21) Which component is used to sort data ?

1. tSortRow
2. tExternalSortRow
3. Both
4. None

Show Answer

 
 
22) What are the operations which tMap allows ?

1. data transformation on any type of fields,data multiplexing and demultiplexing
2. fields concatenation and interchange,data rejecting
3. field filtering using constraints
4. All the above

Show Answer

 
 
23) Is Talend supports Multi schema input ?

1. True
2. FALSE

Show Answer

 
 
24) How do you ensure that a subjob completes before a second subjob runs

1. connect the second subjob to right of the first subjob in the desing workflow
2. connect the second subjob to the first subjob with an OnsubjobOk or Onsubjoberror trigger
3. connect the second subjob to the first subjob with an iterate row
4. You cannot specify the run sequence of jobs

Show Answer

 
 
25) tMap component accepts ______ number of inputs

1. 1
2. 2
3. 3
4. N’ number of inputs

Show Answer

 
 
26) How to generate sample records in Talend

1. tRowGenerator
2. tRowcount
3. tRow
4. None of them

Show Answer

 
 
27) Is it possible to reject the record by using tJoin

1. True
2. FALSE

Show Answer

 
 
28) Tmap component supports the following match model

1. Unique match
2. First Match
3. All Match
4. All the above

Show Answer

 
 
29) Is Talend supports XML as input source

1. True
2. FALSE

Show Answer

 
30) Is it possible to pass value to variable dynamically

1. Yes
2. No

Show Answer

 
 
31) There is no option to export the context script while exporting the job

1. TRUE
2. FALSE

Show Answer

 
 
32) What color is the first component of a job is highlighted with

1. Red
2. Green
3. Yellow
4. Purple

Show Answer

 
 
33) What is the default date format in Talend

1. MM-DD-YYYY
2. DD-MM-YYYY
3. YYYY-MM-DD

Show Answer

 
 
34) We can generate the following output format in tLogrow component

1. Basic
2. Table
3. Vertical
4. All the above

Show Answer

 
 
35) Java source code is compiled into __________

1. source code
2. .Exe
3. .Obj
4. Bytecode

Show Answer

 
 
36) Which of the following tool used to execute java code

1. Java
2. Javadoc
3. javac
4. rmic

Show Answer

 
 
37) Java programming promises progmmer “Write once, Run Any where ”

1. True
2. FALSE

Show Answer

 
 
38) Which of the following is smallest integer data types ?

1. Long
2. int
3. byte
4. short

Show Answer

 
 
39) Charater data type cannot store the following values

1. Letter
2. Special Character
3. String
4. Digit

Show Answer

 
40) what is Literal in java programming ?

1. Special type of data type
2. Source code representation of a fixed value
3. Special type of class
4. Non of them

Show Answer

 
 
41) Platform independent code file created from source file is understandable by ________

1. Compiler
2. Applet
3. JRE
4. JVM

Show Answer

 
 
42) JVM is a_________

1. Assembler
2. Debugger
3. Interpreter
4. Compiler

Show Answer

 
 
43) Bytecode is given as input to _________

1. JRE
2. Assembler
3. Linker
4. JVM

Show Answer

 
 
44) From which tab in component view would you specify whether the configuration is built-in or repository.

1. Basic settings
2. Dynamic settings
3. Advanced settings
4. Documentation

Show Answer

 
 
45) In which user interface do you place the components of your job

1. The Repository
2. The design workspace
3. The Job view
4. The Palette

Show Answer

 
 
46) Which of the following information is required for creating a new Talend job? Select all of them

1. Name
2. Description
3. Purpose
4. All the above

Show Answer

 
 
47) How do you create a row between two components

1. Right-click the source component and then click the target component
2. Drag the source component onto the target component
3. Drag the target component onto source component
4. Right click the source component click row followed by the row type and then click the target component.

Show Answer

 
 
48) From which tab in a component view would you specify the component label?

1. Basic settings
2. Advanced settings
3. Documentation
4. View

Show Answer

 
 
49) From which user interface element do you choose a component for your job?

1. The Palette
2. The Repository
3. The design workspace
4. The Componet view

Show Answer

 
50) Which of the following in design workspace indicate an error with a component

1. A yellow exclamation point
2. A green “I”
3. A red “X”
4. A red exclamation point

Show Answer

 
 
51) How do you create a new version of a job

1. Right-click the job in the repository and then click create new version
2. Right-click the job in the repository and then click open another version
3. Change the version number From the file menu
4. change the version number in the job view

Show Answer

 
 
52) From which view in Talend open studio would you define a variable value

1. The job view
2. The component view
3. The Context view
4. The Run view

Show Answer

 
 
53) From which view in talend open studio would you read the comments attached to a component

1. The component view
2. The Problems view
3. The Job view
4. The contect view

Show Answer

 
 
54) What is the purpose of a Main row

1. To pass a single row of data from one component to another
2. To connect elements in a Business Model
3. To allow data to flow one component to another
4. To strictly visually present the processing order

Show Answer

 
 
55) how would you modify the job description in Talend open studio

1. The Run view
2. The component view
3. Edit the properties of the job via the Repository(right click on the job)
4. The Job view

Show Answer

 
 
56) how do you prevent a subjob from running without deleting it?

1. Right-click an open area in the subjob and then click Deactive current subjob
2. Right-click a component in the subjob and then click Deactive current subjob
3. Click a component in the subjob and then click Deactive current subjob on the file menu
4. Right-click an open area in the subjob and then click ignore current subjob

Show Answer

 
 
57) how do you change the text label on a component in the design workspace? Select all of them

1. From the view tab in the components view
2. Righ-click the component in the design workspace and then click rename
3. From the label tab in component view
4. Click the label in the design workspace twice & From the view tab in the components view

Show Answer

 
 
58) From which user interface do you create jobs?

1. The design wrkspace
2. The Repository
3. The Palette
4. The Job view

Show Answer

 
 
59) In which user interface do you find Business models, Job designs and Metadata

1. The design workspace
2. The palette
3. The Repository
4. The job view

Show Answer

 
60) Which of the following parameters is required for a  tFileinputDelimited component ? Select all of them

1. Field separator
2. Header
3. File Name
4. All the above

Show Answer

 
 
61) What is the default value of the Field separator parameter for a tFileinputDelimited component

1. A comma
2. A colon
3. A pipe
4. A semicolon

Show Answer

 
 
62) How do yu reference the value of a context variable in a configuration parameter

1. Enter the value of the script code displayed in the context view
2. $contectname
3. varname
4. context.varname

Show Answer

 
 
63) what expression converts a string to upper case

1. StringHandling.UPCASE(string)
2. UPCASE(string)
3. UPPERCASE(string)
4. UPPERCASE(string)

Show Answer

 
 
64) how do you join two input columns in the tMap configuration window

1. Drag a column from one input table to a column in another input table
2. shift click two columns from separate inout tables and then click join
3. Drag two columns from separate input tables to an output table
4. right-click a column from one input tabel and the click join

Show Answer

 
 
65) In the tMap configuration window what do the tables on the left represent

1. the schemas of the input rows
2. The expressions to apply to the input data
3. The schemas of the output rows
4. The expressions to apply to the output data

Show Answer

 
 
66) Talend is written in which language

1. Ruby
2. Python
3. HTML
4. Java

Show Answer

 
 
67) Can we change background color of job designer

1. YES
2. NO

Show Answer

 
 
68) Can we assign an variable which will be assessed in all talend jobs?

1. NO
2. YES

Show Answer

 
 
69) Which Component to use to use our custom code?

1. tfileinputexcel
2. tlog
3. tjava
4. tdie

Show Answer

 
 
70) For sorting data generally which component we use?

1. tsortrow
2. txmlinput
3. tmap
4. taggregaterow

Show Answer

 
71) We should use Repository option for the data which we use repeatedly

1. True
2. FALSE

Show Answer

 
 
72) Identify incorrect option : tmssqloutput component has “Action on table”

1. Drop table if exists and create
2. Clear table
3. Insert or Update
4. Truncate table

Show Answer

 
 
73) Identify incorrect option : tmssqloutput component has “Action on data”

1. Insert
2. Update
3. Delete
4. Default

Show Answer

 
 
74) Which date format is default in talend?

1. dd-MM-yyyy
2. MM-dd-yyyy
3. MM-dd-yyyy hh:mm:ss
4. yyyy-dd-MM

Show Answer

 
 
75) Can we change generated code directly?

1. NO
2. YES

Show Answer

 
 
76) Which component is useful to Normalize the data ?

1. taggregaterow
2. tmap
3. tgeneraterow
4. tnormailze

Show Answer

 
 
77) We should use Built-in for the data which we use rarely

1. True
2. FALSE

Show Answer

 
 
78) tDenormalizeSortedRow is bundled in a group of all input sorted rows. It helps in saving the memory by synthesizing sorted input flow.

1. True
2. FALSE

Show Answer

 
 
79) Java Heap memory error is due to virtual memory error

1. True
2. FALSE

Show Answer

 
80) Where we can create Local conext in job?

1. tcontextLoad
2. tbuffer
3. Create context in that perticular job
4. Metadata->Create Context

Show Answer

 
 
81) If we want to have 1 single inner job then which component is useful?

1. Database Components
2. tmap
3. tjava
4. tjoin

Show Answer

 
 
82) Identify incorrect option: tmap support following Joins

1. Inner Join
2. Cross Join
3. Left Outer Join

Show Answer

 
 
83) What is use of Routines

1. Create Run time variable
2. Create Database Connection
3. Create Functions
4. Write a piece of Java code for business requirement

Show Answer

 
 
84) Can we create own custom component ?

1. YES
2. NO

Show Answer

 
 
85) Can we have many inputs/outputs in tmap

1. One
2. Two
3. Five
4. Many

Show Answer

 
 
86) Can we have myny outputs in tjoin

1. One
2. Two
3. Five
4. Many

Show Answer

 
 
87) tJoin supports join model

1. Cross join
2. Outer join
3. Left Outer Join
4. Unique Join

Show Answer

 
 
88) How does one perform aggregation operations or functions on data in Talend?

1. tAggregatesortedrow
2. trowgenerater
3. tlog
4. txmlinput

Show Answer

 
 
89) Check syntax is correct or not->  result= 1==1 ? True : false

1. True
2. FALSE

Show Answer

 
90) Component serves as a REST Web service client that sends HTTP requests to a REST Web service provider and gets the responses

1. trowgenerater
2. tlog
3. tsystem
4. trest

Show Answer

 
 
91) Identify incorrect Triggers which are used to transfer control from one component to another component.

1. On Subjob Ok
2. On Subjob Error
3. Iterate
4. Run If

Show Answer

 
 
92) how to validate source data with output schema?

1. tfileinputexcel
2. tfilelist
3. tlog
4. tSchemaComplianceCheck

Show Answer

 
 
93) How to Split Rows to Columns ?

1. tpivottocolumnsdelimited
2. No component available
3. tjava
4. tlog

Show Answer

 
 
94) How to generate user define data in talend?

1. tlog
2. tjava
3. trowgenerater
4. tfilepinputdelimited

Show Answer

 
 
95) Can we send parameters from Parent job to child job?

1. TRUE
2. FALSE

Show Answer