Talend Data-Integration-Developer Talend Data Integration Certified Developer Exam Practice Test

Page: 1 / 14
Total 55 questions
Question 1

Which Action on table operations are supported by a tMysqlOutput component?

Choose 3 answers



Answer : A, B, E

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]


Question 2

Which factors can affect the context in which a Job is run?

Choose 2 answers



Question 3
Question 4
Question 5
Question 6

Which methods car you use to specify the schema in a tFilelnputDelimited component?

Choose 3 answers



Answer : B, D, E

The methods that you can use to specify the schema in a tFileInputDelimited component are:

Add the component then drag and drop a generic schema metadata item onto the component. This method allows you to reuse an existing schema that is stored in the Metadata section of the Repository. A generic schema is a schema that is not associated with any specific file format or connection type. You can create a generic schema by right-clicking on Generic Schema in the Repository and selecting Create Generic Schema.

Drag a File delimited metadata item from the Repository onto the design workspace. This method allows you to create a new tFileInputDelimited component with a predefined schema that is based on a specific delimited file. A File delimited metadata item is a metadata item that contains information about a delimited file, such as its path, format, encoding, field separator, etc. You can create a File delimited metadata item by right-clicking on File delimited in the Repository and selecting Create File delimited.

Add the component, open the Component view, select the Built-in schema type, then click the Edit schema button. This method allows you to create a custom schema for the tFileInputDelimited component within the Component view. A built-in schema is a schema that is defined locally for a specific component and cannot be reused by other components. You can edit a built-in schema by clicking on the Edit schema button in the Basic settings tab of the Component view.


Question 7

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



Answer : B, C, E

Using the following input file format as an example:

<OCR>Name, Phone Abraham Smith, 510-555-5555 ... Steven Doe, 613-555-5555 </OCR>

The tFileInputDelimited component parameters that you should configure to parse the input file correctly are Schema, Field separator, and Header. The Schema parameter defines the structure and type of the data in the input file. You can use a built-in schema or a repository schema to specify the columns and their properties. The Field separator parameter defines the character that separates each field in a row of data. In this case, it is a comma (,). The Header parameter defines the number of rows to be skipped at the beginning of the file. In this case, it is 1, as the first row contains the column names.


Page:    1 / 14   
Total 55 questions