Question 1

You have multiple transformations that read and process data from multiple text files. You identity a series of steps that are common across transformations and you want to re-use them to avoid duplication of code. How doyou accomplish this?

Options :

A :

Use the "Mapping (sub-transformation)' step containing the series of steps.

B :

Use the ETL Metadata Infection' stop containing the series of steps.

C :

Use the "Get data from XML' step to read the series of steps

D :

Use the 'Job Executor1 step containing the series of steps

Answer: B

Question 2

You are developing the PDI solution for a customer. The customer requires that a set of SQL statements are

executed on each connection to the database.

Which method will satisfy this requirement?

Options :

A : Use JNDI to specify the SQL statements.

B : Use the Advanced section in the Database Connection window to enter the SQL statements.

C : Use the Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.

D : Use the Database Connection wizard and specify SQL statements.

Answer: C

Question 3

You have a PDI job with an Oozie JobExecutor entry and you want this job entry to finish before the nextjob

entry starts.

How do you accomplish this task?

Options :

A :

Use a Simple Evaluationentry

B :

Add the timeout property in the Advanced Options pane.

C :

Use a Wait For entry

D :

Set the Enable Blocking option

Answer: C

Question 4

Which statement is true for a transformation?

Options :

A : Transformation steps are executed in parallel.

B : Atransformation must have a start step.

C : A transformation step processes one row at a time.

D : A transformation step can have only one incoming hop and one outgoing hop.

Answer: B

Question 5

You need to process data on the nodes within a Hadoop cluster. To accomplish this task, you write a mapper

and reducer transformation and use the Pentaho MapReduce entry to execute the MapReduce job on the

cluster.

In this scenario, which two steps are required within the transformations? (Choose two.)

Choose 2 answers

Options :

A : the Madoop Fie Input step

B : the Hadoop File Output step

C : the MapReduce Input step

D : the MapReduce Output step

Answer: A,C

Smartly Prepare Exam with Free Online HCE-5920 Practice Test

Buying Options: