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

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

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

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

Higher Test Marks with Free Online HCE-5920 Exam Practice

Buying Options: