Limited-Time Offer: Enjoy 50% Savings! Ends in 00h 00m 00s Coupon code: 50OFF
Skip to content

Free Hitachi Vantara Certified Specialist Pentaho Data Integration Implementation HCE-5920 Exam Questions

Page: 1 / 6 Total 60 questions

Want more questions? Get Premium Access.

Question 1

Which two steps in a transformation allow variable values to be used throughout the rest of a PDI job? (Choose two.)

Choose 2 answers

Correct Answer: A. the 'Set Variables' step; D. the Modified Java Script Value' step

Question 2

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

Correct Answer: A. start-pentaho.sh; B. start-pentaho-debug.

Question 3

After monitoring a performance bottleneck in transformation you identified a user Defined Java Expression step as the problem.

Choose 2 answers

Correct Answer: C. Replace me step with a User Defined Java Class step; D. Split the step into multiple consecutive steps

Question 4

You are encryption your database connection password to use in the kettle. properties file. The output of the encr script is:

Encrypted XYZabc123

In this scenario, which syntax is correct?

Correct Answer: A. DB_PASSWORD=Encfypted('XYZABC 123*)

Question 5

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?

Correct Answer: C. Use the Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.

Question 6

You have a PDI job that gets a list of variables followed by three subsequent transformation entries. Since the three subsequent transformation entries are not dependent on each other. You want to execute them at the same time.

According the Hitachi Vantara best practices, how do you accomplish this task?

Correct Answer: B. Select the Run Next Entries in Parallel option for the three independent transformation entries.

Question 7

Which statement is true for a transformation?

Correct Answer: B. A transformation must have a start step.

Question 8

You need to populate a fact table with the corresponding surrogate keys from each dimension table

Which two steps accomplish this task? (Choose two.)

Choose 2 answers

Correct Answer: A. the 'Combination lookup/update' step; B. the Dimension lookup/update' step

Question 9

You have a PDI job with an Oozie Job Executor entry and you want this job entry to finish before the next fob entry starts.

How do you accomplish this task?

Correct Answer: C. Use a Wart For entry

Question 10

You have a job that uses a Pentaho MapReduce entry to read four input files, and that outputs words and their counts to one output file.

How should you set the number of reducer tasks?

Correct Answer: A. Set it to blank.