Important Talend Data-Integration-Developer Exam Questions

Answer: D

Explanation:

To reuse a job named testJob from a referenced project named project_ref in your main job, you need to navigate to @Referenced project, @project_ref, Job Designs, Standard, then select testJob. A referenced project is a project that can be accessed from another project in read-only mode. You can add a referenced project to your main project by using the Project Settings window in Talend Studio. You can then browse the items (such as jobs, metadata, routines, etc.) of the referenced project in the Repository tree view under the @Referenced project node. You can drag and drop any item from the referenced project to your main job design workspace.

You do not need to use import items, create standard job, or navigate to Metadata options. These options are not used to reuse jobs from referenced projects. The import items option is used to import items (such as jobs, metadata, routines, etc.) from an archive file that can be exported from another project or workspace. The create standard job option is used to create a new job with a name and a description. The Metadata node in the Repository tree view is used to store and manage metadata definitions for various data sources (such as databases, files, web services, etc.).Reference:Talend Open Studio: Open-source ETL and Free Data Integration | Talend, [Referenced projects - 7.3]

Answer: C

Explanation:

Contexts are a way of defining different sets of values for variables that are used in a job. For example, you can define a context for testing and another context for production, with different values for the database connection parameters, file paths, etc. You can then switch between the contexts easily without modifying the job design. Contexts are not automatically defined by the types of components used in the job, nor by Talend Studio. You must define the contexts yourself in the Contexts tab of your job. You can also create context groups in the Repository and reuse them in multiple jobs.Reference:Talend Data Integration --- Software to Connect, Access, and Transform Data | Talend,

Answer: B

Explanation:

To create a Joblet from an existing Job, you can follow these steps:

Open the Job that you want to create a Joblet from.

Select the components that you want to include in the Joblet.

Right-click on the selected components and selectCreate Jobletfrom the context menu.

In theCreate Jobletdialog box, enter a name and description for the Joblet.

ClickFinishto create the Joblet.

Talend Open Studio User Guide: Creating a Joblet from a Job: https://help.talend.com/r/en-US/8.0/studio-user-guide/creating-joblet-from-job

Answer: B

Explanation:

The code viewer tab in Talend Studio provides lines of code generated for the selected component in a Job. It shows the code in the language of the component, such as Java or Perl. The code viewer tab allows the user to view and edit the code, as well as copy and paste it to another editor. The code viewer tab also displays errors and warnings related to the code.Reference:Code viewer tab

Answer: A, B, E

Explanation:

The tMysqlOutput component is used to write data into a MySQL database table. The Action on table parameter of this component allows you to specify what operation to perform on the table before loading data into it. The Action on table parameter supports the following operations:

Drop table if exists and create: This operation drops the table if it already exists in the database and creates a new one with the same name and structure as defined in the schema.

Create table: This operation creates a new table in the database with the name and structure as defined in the schema. If a table with the same name already exists, an error will be raised.

Create table if does not exist: This operation creates a new table in the database with the name and structure as defined in the schema only if there is no table with the same name already existing in the database. If a table with the same name already exists, no action will be taken.

The Action on table parameter does not support the following operations:

Replace: This is not an operation on the table, but on the data. The Replace parameter of the tMysqlOutput component allows you to specify whether to replace existing rows in the table with new rows based on a key attribute or to insert new rows only.

Drop table: This is not an operation on the table, but on the database. The Drop table parameter of the tMysqlConnection component allows you to specify whether to drop the table after closing the connection or not.Reference:Talend Open Studio: Open-source ETL and Free Data Integration | Talend, [tMysqlOutput properties - 7.3], [tMysqlConnection properties - 7.3]