Question 1

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 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 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

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 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

Higher Test Marks with Free Online HCE-5920 Exam Practice

Buying Options: