hitachi hce-5920 practice test

Hitachi Vantara Certified Specialist Pentaho Data Integration Implementation

Last exam update: Nov 18 ,2025
Page 1 out of 4. Viewing questions 1-15 out of 60

Question 1

You are preparing a server environment for an archive installation of a Pentaho server
According to Hitachi Vantara best practices which environment variable should be set?

  • A. KETTLEHOME
  • B. JAVA_HOME
  • C. PENTAHO_JAVA_HOME
  • D. SPOON HOME
Mark Question:
Answer:

C


Explanation:
Set environment variables
If you do not set the HOME environment variables, Pentaho will not start correctly. Complete the
steps in this topic to ensure that you have set the HOME environment variables properly.
Set the path of the PENTAHO_JAVA_HOME variable to the path of your Java installation, as shown:
SET PENTAHO_JAVA_HOME=C:\Program Files\Java\jdk8.x.x.x
(Optional) If you are using a JRE, then also set the JRE_HOME home environment variable.
Log off and log on again, then verify the variables have been properly set by using a command similar
to the following example:
ECHO %PENTAHO_JAVA_HOME%
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Prepare_your_Windows_envir
onment_for_an_archive_install

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

You are installing a Pentaho server and you decide to use a responsibility database other than
Postgres.
Which two database are supported in this configuration? (Choose two.) Choose 2 answers

  • A. Microsoft SQL Server
  • B. Oracle
  • C. DB2
  • D. Sybase
Mark Question:
Answer:

A, B


Explanation:
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Use_PostgreSQL_as_your_repo
sitory_database_(Manual_installation)

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

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

  • A. start-pentaho.sh
  • B. start-pentaho-debug.
  • C. import-export.sh
  • D. stop-pentaho.sh
Mark Question:
Answer:

AB


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

You have instated the Pentaho server using an archive installation. You now want to change the
server port.
Which file do you modify?

  • A. server.xml
  • B. repositories.xml
  • C. context.xml
  • D. slave-server-config.xml
Mark Question:
Answer:

A


Explanation:
Follow the instructions below to change the port through which the Pentaho Server runs:
Stop the Pentaho Server.
Navigate to the /pentaho-server/tomcat/conf/ directory.
Open the server.xml file with any text editor, and search for the value for Define a non-SSL HTTP/1.1
Connector.
Change the port number in the connector port element below from 8080 to your preferred port
number.
https://help.hitachivantara.com/Documentation/Pentaho/9.0/Setup/Customize_the_Pentaho_Serve
r#:~:text=Change%20the%20port%20numbers%20for%20the%20Pentaho%20Server,-
Follow%20the%20instructions&text=Navigate%20to%20the%20%2Fpentaho%2Dserver,to%20your%
20preferred%20port%20number
.

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

A Big Data customer wants to run POI transformations on Spark on their production Hadoop cluster
using Pentaho's Adaptive Execution Layer (AEL)
What are two steps for installing AEL? (Choose two.)
Choose 2 answers

  • A. Run the Spark application butter tool to obtain the AEL daemon zip file.
  • B. Configure the AEL daemon in Local Mode.
  • C. Run the AEL Oozie job to install the AEL daemon.
  • D. Configure the AEL daemon in YARN Mode
Mark Question:
Answer:

BD


Explanation:
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Set_up_the_Adaptive_Executio
n_Layer_(AEL)

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

Which two statements are correct about the Repository Explorer? (Choose two.)
Choose 2 answers

  • A. You can create new jobs and transformations.
  • B. You can move. rename, and delete jobs and transformations.
  • C. You can upload JDBC drivers when defining JOBC connections.
  • D. You can lock and unlock jobs and transformations.
Mark Question:
Answer:

B, D


Explanation:
https://help.hitachivantara.com/Documentation/Pentaho/7.0/0L0/0Y0/040/010

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

You are migrating to a new version of the Pentaho server and you want to import your old repository.
What are two methods to accomplish this task? (Choose two.) Choose 2 answers

  • A. Use the pan script
  • B. Use the import-export script.
  • C. Using Spoon Tools > Repository > import Repository
  • D. Use the encr script.
Mark Question:
Answer:

BC


Explanation:
https://help.hitachivantara.com/Documentation/Pentaho/6.0/0P0/0U0/040

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

Which script will execute jobs stored in a Pentaho server from a command line?

  • A. pan
  • B. carle
  • C. kitchen
  • D. spoon
Mark Question:
Answer:

A


Explanation:
https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command
_Line_Tools

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

You are implementing a Pentaho server repository for a customer.
The customer will be using the Pentaho Scheduler.
Which repository supports this requirement?

  • A. Carlo Repository
  • B. Pentaho Repository
  • C. Kettle Database Repository
  • D. Kettle File Repository
Mark Question:
Answer:

B


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

What are two ways to schedule a PDI job stored in the repository? (Choose two.)
Choose 2 answers

  • A. Write a login script to start the timer and execute a kitchen script specifying a job in the repository.
  • B. Use the pan script specifying a job in the repository and schedule it using cron.
  • C. Use the kitchen script specifying a job in the repository and schedule it using cron.
  • D. Use Spoon connected to the Pentaho repository and choose Action > Schedule in the menu.
Mark Question:
Answer:

B, C


Explanation:
https://help.hitachivantara.com/Documentation/Pentaho/8.1/Products/Data_Integration/Schedule_
Perspective#:~:text=or%20kitchen%20commands.-
,Schedule%20a%20Transformation%20or%20Job,The%20Schedule%20window%20appears
.

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 11

You have a PDI input step that generates data within a transformation.
Which two statements are true about downstream steps in this scenario? (Choose two.)
Choose 2 answers

  • A. The steps will receive a stream of data from the input as soon as it is a available.
  • B. Only one step can receive data from the input step.
  • C. The steps will receive the data once the input step fully fetches it.
  • D. Multiple steps can receive data from the input step.
Mark Question:
Answer:

CD


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

You need to perform a union of two data flows in a PDI transformation. You plan on having one step
receive the two hops from the different flows.
Which two statements are true in this scenario? (Choose two.)
Choose 2 answers

  • A. You can only use the Append streams step to join these two flows.
  • B. The row layout must be identical between the two steps.
  • C. You can use the 'Dummy (do nothing)' step to join these two flows.
  • D. The row layout can be different between the two steps as long as the data types are the same
Mark Question:
Answer:

BC


Explanation:
https://help.hitachivantara.com/Documentation/Pentaho/7.0/0L0/0Y0/030/010

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

Which feature of PDI will allow you to create an Interactive Reporting report against a Web service?

  • A. Pontaho Data Service
  • B. Checkpoints
  • C. Metadata Injection
  • D. Capability Manager
Mark Question:
Answer:

A


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

A client is developing a Web application to implement a wizard-like application used by many users.
At several points in the workflow, the application needs to execute jobs and transformations that are
stored in the Pentaho server. Execution will include user-specific parameters. Upon completion of the
job or transformation, the Web application will continue to the next UI page.
What is the recommended approach to accomplish this task?

  • A. Use the Web service API to execute the jobs and transformations on the Pentaho server.
  • B. Use the scheduling tool of the OS to execute the job and transformation on the pentaho server.
  • C. Use the Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.
  • D. Use the Job and Transformation steps to execute the jobs and transformations on the Pentaho server.
Mark Question:
Answer:

C


Explanation:
https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command
_Line_Tools

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

A customer has an existing PDI job that calls a transformation. They want to execute the
transformation through Spark on their Hadoop cluster.
Which change must be made to satisfy this requirement?

  • A. Change the Parameters of the transformation
  • B. Change the Run Configuration of the transformation
  • C. Change the Logging options of the transformation
  • D. Change the Arguments of the transformation
Mark Question:
Answer:

B


User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2