Hitachi Vantara HCE-5920 Exam Practice Test Instant Access

Question 1

You are connecting to a secure Hadoop dueler from Pentaho and want to use impersonation.

Which Pentaho tool should you use?

APentaho Report Designer

BPentaho Spoon

CPentaho Security Manager

DPentaho Server

Answer : A

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

AMicrosoft SQL Server

BOracle

CDB2

DSybase

Answer : A, B

https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Use_PostgreSQL_as_your_repository_database_(Manual_installation)

Question 3

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?

AKETTLEHOME

BJAVA_HOME

CPENTAHO_JAVA_HOME

DSPOON HOME

Answer : C

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_environment_for_an_archive_install

Question 4

To simplify the migration of a PDI solution from one environment to another, you need to externalize all database connection details.

Which two methods will satisfy this requirement? (Choose two.)

Choose 2 answers

AUse the Data Source Wizard to generate the connection details.

BCreate a properties file that includes the connection details and use the Set Variables step to load these properties.

CUse Manage Data Source to create a new connection in Spoon.

DSet the connection details in the Kettle properties file.

Answer : A, D

Question 5

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

Astart-pentaho.sh

Bstart-pentaho-debug.

Cimport-export.sh

Dstop-pentaho.sh

Answer : A, B

Question 6

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?

AUse the Web service API to execute the jobs and transformations on the Pentaho server.

BUse the scheduling tool of the OS to execute the job and transformation on the pentaho server.

CUse the Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.

DUse the Job and Transformation steps to execute the jobs and transformations on the Pentaho server.

Answer : C

https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command_Line_Tools

Question 7

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

Choose 2 answers

AWrite a login script to start the timer and execute a kitchen script specifying a job in the repository.

BUse the pan script specifying a job in the repository and schedule it using cron.

CUse the kitchen script specifying a job in the repository and schedule it using cron.

DUse Spoon connected to the Pentaho repository and choose Action > Schedule in the menu.

Answer : B, C

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.

Hitachi Vantara Certified Specialist Pentaho Data Integration Implementation HCE-5920 Exam Practice Test