Question 1

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

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 need to process data on the nodes within a Hadoop cluster. To accomplish this task, you write a mapperand reducer transformation and use the Pentaho MapReduce entry to execute the MapReduce job on thecluster.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

Question 4

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 5

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

Free HCE-5920 Mock Exam – Practice Online Confidently

Buying Options: