Question 1

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 2

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 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 have a PDI job with an Oozie JobExecutor entry and you want this job entry to finish before the nextjobentry 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 5

You are developing the PDI solution for a customer. The customer requires that a set of SQL statements areexecuted 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

Free HCE-5920 Mock Exam – Practice Online Confidently

Buying Options: