Talend Expert Quiz

 



1) Talend job server is using the following ports

1. command_server_port=8000;file_server_port=8001;monitoring_port=8888
2. command_server_port=8000;file_server_port=8001;monitoring_port=8002
3. command_server_port=8000;file_server_port=8001;monitoring_port=8003
4. None of them

Show Answer

 
 
2) Key Value and Key Index properties are used in _____

1. tMap component
2. Non multischema component
3. multischema input component
4. None of them

Show Answer

 
 
3) What is the default Talend administrator ?

1. administration
2. talend
3. admin
4. TALEND

Show Answer

 
 
4) Talend commandline has ________ operating modes

1. Shell
2. Server
3. Scripts
4. All of them

Show Answer

 
 
5) tMemorizeRows is generally used in scenarios where data from previous rows needs to be compared with the current row to perform the transformations.

1. True
2. FALSE

Show Answer

 
 
6) Which of the below statements helps in improving the performance

1. indexes need to be enabled before running a session
2. Drop the constraints and indexes before running the session and rebuild them after completion of session
3. indexes should be dropped but constraints should be enabled before running a session
4. disable the constraints but enable the indexes before running a session

Show Answer

 
 
7) How can you minimize the cache for a joiner transformation?

1. Make the smaller source the master source
2. Make the smaller source the details source
3. Sort the master data prior to the joiner transformation
4. sort the detail data prior to the joiner transformation

Show Answer

 
 
8) [(# of reads from disk) + (# of writes to disk)]/[(# of reads from memory cache) + (# of writes to memory cache)] is the formula for

1. hit ratio
2. miss ratio
3. a&b
4. None of the Above

Show Answer

 
 
9) Which is not valid for optimizing system bottleneck?

1. Improve network speed
2. improve CPU performance
3. increase paging
4. check hard disks on related machines

Show Answer

 
 
10) What are the Xms and Xmx parameters when starting JVMs

1. The flag Xmx specifies the maximum memory allocation pool for a Java Virtual Machine (JVM), while Xms specifies the initial memory allocation pool.
2. The flag Xmx specifies the minimum memory allocation pool for a Java Virtual Machine (JVM), while Xms specifies the initial memory allocation pool.
3. The flag Xmx specifies the maximum memory allocation pool for a Java Virtual Machine (JVM), while Xms specifies the minimum memory allocation pool.
4. None of them

Show Answer

 
11) The context file is passed to the job in which of the following files

1. Job jar file
2. bat file
3. sh file
4. classpath jar file

Show Answer

 
 
12) Can the schema of tlog catcher edited before connecting it to a component

1. Yes
2. No

Show Answer

 
 
13) Which of the following is/are reusable in Talend

1. java routines
2. metadata schemas
3. context variables
4. all of the above

Show Answer

 
 
14) how to set up dependency on routines for a job

1. Right click on Job -> Edit properties of a job
2. Right click on Job -> Set Routine Dependencies
3. Set the dependency on project setting
4. Set through context file

Show Answer

 
 
15) Where to set the JVM argument of a particular job

1. edit properties of the job
2. project setting of the job
3. context window of the job
4. Advanced settings on the run window

Show Answer

 
 
16) What are the following true about JobLet

1. Schema of the component connecting to input of joblet should be same as Joblet’s first component
2. Schema of the component connecting from output of joblet should be same as Joblet’s last component
3. Both a & b
4. None of the above

Show Answer

 
 
17) Which component of talend is used to split the xml file into multiple xml files

1. tFileInputXML
2. Txmlmap
3. Tmapxml

Show Answer

 
 
18) Job Conductor is not part of TAC administrator

1. TRUE
2. False

Show Answer

 
 
19) How do I change the local language of Talend Studio?

1. Windows -> Preferences -> Talend -> Appearance
2. Windows -> Preferences -> Talend -> Internationalization

Show Answer

 
20) How do you pass rows that do not match the inner join in a tMap component to an output table

1. Check Catch lookup inner join reject in a tMap setting of the output table
2. Check catch output reject in the tMap setting of the lookup table
3. Check Catch lookup inner join reject in thr tMap setting of the lookup table
4. Check Catch output reject in the tMap settings of the ouput table

Show Answer

 
 
21) When you connect a tMap component to a target component what rows are available

1. Main and Rejects
2. The same names as the input roes
3. Main
4. Whatever names you gave to the output tables in the configuration window

Show Answer

 
 
22) How do you run a job that has been saved to be run independently of Talend Studio

1. Extract the files from the archive and then run the batch or shell file
2. Extract the files form the archive and then pass the job name to the utility progran run_job
3. Run java from the command line passing it the name of the archive
4. Extract the file from archive and run the jar file

Show Answer

 
 
23) From which view in talend open studio would you modify the comments attched to a component

1. The Component view
2. The job view
3. The Problems view
4. The context view

Show Answer

 
 
24) How do you save a job so that it can be run independantly of Talend studio

1. click save as in file menu
2. Right-click the job in the repository and click save as
3. click export job on the file menu
4. Right-click the job in the repository and then click export job

Show Answer

 
 
25) how do you determine what project elementas are assocoated with a particular Business model shape?

1. Right-click the shape in the design workspace and then click find associations
2. Right-click the shape in the design workspace and then click find assignments.
3. click the shape in the design workspace and then click the Assignment tab in the business models view
4. click the shape in the design workspace and then click the Association tab in the component view

Show Answer

 
 
26) Choose the most accurate description of tAggregateRow component

1. The calculation specified in the functions table are performed for each unique combination of values in the columns listed in the columns table
2. The calculation specified in the opearations table are performed for each unique combination of values in the columns listed in the group by table
3. A sum of the columns listed in the opearations table is performed for each unique combination of values in the columns listed in the group by table
4. The calculation specified in the functions table are performed for each unique combination of values in the columns listed in the group by table

Show Answer

 
 
27) What component compress a target directory into a archive file

1. tDircompress
2. tDirArchive
3. tFileArchive
4. tDirzip

Show Answer

 
 
28) how do you configure a database component to use a Repository database connection

1. Right-click a database component in the design workspace and then click use an exsting connection
2. In the component view change the property type from Built-in to repository
3. Drag a connection from the repository onto a database component in the desing workspace

Show Answer

 
 
29) what is the purpose of context group

1. to enable editing mutiple variable simultaneously
2. To provide singl default value for all variable in a specific set
3. To create a hierarchy of variables
4. To organize a set of variable in the repository

Show Answer

 
 
30) when you save chnages to tMap configuration you are sometime prompted to propagate changes why

1. Because your changes affect output schema and target component should have a matching schema
2. Because your changes have not yet been saved
3. Because your changes affect output schema and source component should have a matching schema
4. Because your changes affect output schema and source component should have a matching schema

Show Answer

 
31) What are the two ways to add text information to a job

1. Edit the comments box in the documentation tab on the job view
2. import a text file and attach to the job
3. Add a note component to the design workspace

Show Answer

 
 
32) In what format does Talend open studio generate job documentation

1. HTML
2. plain text
3. CSV
4. XML

Show Answer

 
 
33) Which of the following is not a valid action for a table  in a tMysqlOutput component

1. drop
2. create if not exists
3. create
4. drop and create

Show Answer

 
 
34) Which component do you use to stop a running job under specific condition

1. tDie
2. tKill
3. tWarn
4. tStop

Show Answer

 
 
35) What output rows are available for a tUniqueRow component

1. Uniques and lookup
2. Main and duplicates
3. Unique and duplicates
4. Main and Rejects

Show Answer

 
 
36) In the tMap configuration window which schemas do you modify with the schema editor

1. the schema of any two tables
2. The schema of one input table or one output table
3. The schema of the choosen input table or choosen output table
4. The schemas of any two attched components

Show Answer

 
 
37) how do you change the name of an output table in tMap configuration

1. click the name of the table in tMap configuration window and then click the rename button
2. change the name of the corresponding output row in the design workspace
3. you cannot change the name of the existing output table
4. click the name of the table in tMap configuration and edit it

Show Answer

 
 
38) what is the difference between built-in context variable and repository context variable

1. A built-in context variable is predefined and accessible from multiple jobs whike a repository context variable is specified to a single job
2. A built-in context variable is predefined in Talend studio while you define a repository context variable yourself
3. A built-in context variable is specific to a single job while a repository context variable can be imported into multiple jobs
4. context variable are stored in different location otherwise both are identical

Show Answer

 
 
39) how do you ensure that a subjob completes before a second subjob runs

1. connect the second subjob to the first subjob with an onSubjobok or onSubjobError trigger
2. you cannot specify the run sequence of subjobs
3. connect the second subjob to the first subjob with an iterate row
4. connect the second subjob to the right of the first subjob in the design workspace

Show Answer

 
40) What is the significance of tLoqateAddressRow component in Talend?

1. Component for search address
2. Component for mailing on correct address
3. Component for check address
4. Component to get local address

Show Answer

 
 
41) Can we use Binary transfer mode in  SFTP

1. YES
2. NO

Show Answer

 
 
42) Can we use Binary transfer mode in  FTP

1. YES
2. NO

Show Answer

 
 
43) Identify Incorrect option:How to add third party libraries in talend project?

1. Window -> Preferences -> Java -> User Libraries
2. Use the tLibraryLoad component
3. Use Routines “Edit Routine Libraries” option
4. Use Global Context

Show Answer

 
 
44) Can we use expression on columns while providing joining condition in tmap?

1. YES
2. NO

Show Answer

 
 
45) Can we use expression on columns while providing joining condition in tJoin?

1. YES
2. NO

Show Answer

 
 
46) Can we call shell script using which component

1. tJava
2. tJavarow
3. tsystem
4. tmap

Show Answer

 
 
47) How to transpose rows to columns using component

1. tbuffer
2. tPivottooutputdelimited
3. taggregaterow
4. tlog

Show Answer

 
 
48) hHow we can send files from local machine to FTP server

1. tsendmail
2. tfilelist
3. tftpget
4. tftpput

Show Answer

 
 
49) What are two ways to include or import these external jar and library files.

1. Using tLibraryLoad component
2. by using tmap
3. by using tjava,tjavaflex compoent

Show Answer

 
50) Component used for Processing Multi schema files

1. tfileinputexcel
2. tFileInputMSDelimited
3. tfileoutputexcel
4. tlog

Show Answer

 
 
51) It loads the entire XML file into memory before parsing and It uses Object based Model for parsing XML.

1. Dom4J Parser
2. SAX Parser
3. No component available

Show Answer

 
 
52) It parses the XML file Node by Node and It uses Event based Model for parsing XML

1. Dom4J Parser
2. SAX Parser
3. No component available

Show Answer

 
 
53) How to pass Context parameters to Talend Job through command line

1. Using Context Group
2. Not possible
3. tlog

Show Answer

 
 
54) It transforms data flow into a list and allows to transform processable flow into non processable data

1. trowgenerater
2. tfixedflowinput
3. tflowtoiterate
4. tjava

Show Answer

 
 
55) Identify incorrect option : Useful Configuration and Log globle variables available in talend

1. pid
2. rootPid
3. isParentJob
4. isChildJob

Show Answer

 
 
56) Can we Set/change Workspace default location is given file :osgi.instance.area=provide your workspace path

1. True
2. FALSE

Show Answer

 
 
57) How to solve “GC overhead limit exceeded” error

1. Not possible
2. dobule click on -Xmas and incrise the size upto GB eg. -Xmas2G or -Xmas-100M
3. Restart machine
4. remove number of tlog components

Show Answer

 
 
58) NoClassDefFoundError: org/apache/commons/codec/binary/Base64 is related with

1. commons-codec.jar
2. All .dll files
3. All .xml files
4. Virtual memory problem

Show Answer

 
 
59) Can we Set Encoding to tMySQLOutPut: “useUnicode=true&characterEncoding=utf8″

1. True
2. FALSE

Show Answer

 
60) We can call shell script by using component called

1. tmap
2. tJavarow
3. tjoin
4. tsystem

Show Answer

 
 
61) How to generate Column into Rows with Talend

1. tDenormalize
2. tnormalize
3. tbufferinput
4. tlog

Show Answer

 
 
62) Component is usefule to add a reason code and message to the rejected output

1. tfileoutputdelimited
2. tFileInputMSDelimited
3. tfileoutputexcel
4. tRules

Show Answer

 
 
63) tScriptRules is a third-party Talend Open Studio component that applies a set of Javascript rules to an input flow

1. True
2. FALSE

Show Answer

 
 
64) In talend Open Studio, Component is used to load XML into a database column

1. tfileinputxml
2. tfileoutputxml
3. tWriteXMLField
4. Not Possible

Show Answer

 
 
65) tJDBCColumnList : Iterates on all column names in a specified table from a defined DB connection

1. True
2. FALSE

Show Answer

 
 
66) Writes a message to an LDAP server

1. tLDAPRenameEntry
2. tLDAPAttributesInput
3. tLDAPInput
4. tLDAPOutput

Show Answer

 
 
67) tGPGDecrypt : Decrypts a GnuPG-encrypted file and saves the decrypted file in the specified target directory.

1. True
2. FALSE

Show Answer

 
 
68) tNamedPipeOpen opens a named-pipe for writing data into it.

1. True
2. FALSE

Show Answer

 
 
69) tPostgresqlInvalidRows checks database rows against specific Talend Data Quality database patterns.

1. True
2. FALSE

Show Answer