Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation (HCE-5920) Free Practice Test

Question 1

A customer needs to extract data from many afferent text He layouts with new file layouts being identified in the future and they want toinsert the data into corresponding database tables. They are concerned about maintaining multiple PDI jobs and transformations given the large number of unique files.
What should you do to meet the requirements when creating transformations?

A. Use the Job Executor step for each file.

B. Use the Transformation Executor step for each file.

C. Use the Metadata structure of stream step for each file.

D. Use the ETL Metadata injection step

Correct Answer: D

Question 2

A client is developing a Web application to implement a wizard-like application used by many users. At several pointsin 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 Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.

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

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

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

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Which statement is true for a transformation?

A. A transformation step processes one row at a time.

B. Transformation steps are executed in parallel.

C. A transformation step can have only one incoming hop and one outgoing hop.

D. Atransformation must have a start step.

Correct Answer: D

Question 4

What are Job checkpoints?

A. Points in a job that log the step metrics during certain intervals

B. Points in a job that have finished successfully and are automatically skipped after a previously failed run

C. Points in a job that sends a heartbeat request to the Pentaho server to ensure connectivity.

D. Error handing hops that manage e-mail notifications.

Correct Answer: A

Question 5

The log files on a Pentaho server rotate daily and are getting too large. You want to change want logs to rotate hourly.
how do you adjust the log settings?

A. Modify the Tomcat startup bat or startup.sh script

B. Modify the Pentaho server's tog4j.xml.

C. Modify the transformation's properties.

D. Modify the start-pentaho bat or start-pentaho.sh script

Correct Answer: C

Question 6

You are connecting to a secure Hadoopclusterfrom Pentaho and want to use impersonation.
Which Pentaho tool should you use?

A. Pentaho Server

B. Pentaho Report Designer

C. Pentaho Security Manager

D. Pentaho Spoon

Correct Answer: B

Question 7

A customer's transformation Is running slowly in a lest environment. You have access to Spoon and you can run and monitor the job.
How do you troubleshoot this problem?

A. Make sure the customer is using data partitioning to ensure parallel processing for fasterexecution

B. Verify that there are no bottleneck slaps m the transformation by comparing the amount of rows in the input buffer versus the output buffer within the Step Metrics tab

C. Ensure there is enough memory on the Pentaho server and that there are no "Out Of Memory' errors in the log.

D. Execute the transformation via the pan script and pass the performance gathering parameter.

Correct Answer: D

Welcome to TestSimulate

Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation (HCE-5920) Free Practice Test