EMT Practice Test

1. Question Content...

---

Question1: Which statements are true about using the Implicit Context Load feature in Talend Studio?
Choose? answers

Question2: You need to set up a server in your Talend environment that enables several members of your team to collaborate on a project.
Which application must you enable before working on a remote project?

Question3: You are building a Job to run outsode Talend Studio that must run on both Linux and Windows.
Which action should you take when building the Job?

Question4: Which types of SQL templates does Talend Studio provide?
Choose 2 answers

Question5: Which method allows you to execute the compiled Job Talend Studio?

Question6: You designing a Job that can run in two contexts, Test and Production. You want to run it as a standalone job outside Talend Studio.
How do you accomplish this?

Question7: You are using the tMap component to configure a mapping.
What do the tables on the left side of the Map Editor window represent?

Question8: You have a Job that uses a tFileInputDelimited component to extract data from an input file. You built a spate subjob, called W, to handle the condition when the input file is empty.
Which condition syntax is correct for the Run if connection?

Question9: You have a tMap component configured with a single input row1and three outputs: CA, NY, Rejects. The input row1 consists of two columns. Name and State, containing the following data:

All outputs map only the Name column from row1, but CA employs a filter expression, CA.equals(row1.state), while Ny employs a filter expression, NY. Equals(row1,State). All Rejects have no such configuration.
Under these conditions, how does data flow to the outputs?

Question10: What is the generic Input component used for in a Joblet design?

Question11: A Job has two contexts defined: lest (the default) and Prod, and two context variables defined: path and server.
Which expression should you use to reference the path?

Question12: Which methods car you use to specify the schema in a tFilelnputDelimited component?
Choose 3 answers

Question13: You need to create a centralized metadata connection to database server for an application.
Which steps should you take before building a Job that reads from that database?
Choose 3 answers

Question14: Which statements ate true about a tWarn component?
Choose 2 answers

Question15: You want to use the value of a context variable you defined to configure a component, but you do not remember the exact name. You decide to use the auto-completion feature in Talend Studio Studio to get assistance.
Which keystrokes can you use to trigger auto-completion?

Question16: Where can you specify the remote JobServer to execute a Job?

Question17: Where can you simultaneously define primary keys for the Update and Delete operations in a tMysqlOutput component?

Question18: Which exceptions car be caught using tLogCatcher?
Choose 3 answers

Question19: Which options can you use to add a Joblet to your talend Job?
Choose 3 answers

Question20: You are building a complex Job and want to explore different optionsfor optimizing execution timesusing parallelism.
How can you identify execution times to verify the effectiveness of your changes?
Choose 2 answers

Question21: What determines the name of the tMap output row that delivers join rejects?

Question22: Which file should you edit to enable SSL for a JobServer?

Question23: You have a tMap component whose main input provides the following data:

There is also a lookup table with the following data:

An inner join is configuredbetween the State column of the main input with the State Code column of the lookup table.
What happens when the row containing the name Andrew laylor is processed?

Question24: A data professional would like to combine multiple data sources into a relational database to improve their business efficiency.
Which data integration initiative can help them achieve this?

Question25: Using the following input file format as an example:

Which tFileinputDelimted component parameters should you configure to parse the input file correctly?
Choose 3 answers