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

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 3

You have completed a successful installation of a Pentaho server on Linux.

You now need to write a script to run the Pentaho server as a service.

Which two files should you call from the script? (Choose two.)

Choose 2 answers

Options :

A : start-pentaho.sh

B :

start-pentaho-debug.

C :

import-export.sh

D :

stop-pentaho.sh

Answer: A,B

Question 4

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 5

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

Higher Test Marks with Free Online HCE-5920 Exam Practice

Buying Options: