Real Hitachi HCE-5920 Exam Dumps [2022] For The Best Preparation Online

1. You have a PDI job with an Oozie JobExecutor entry and you want this job entry to finish before the nextjob entry starts.

How do you accomplish this task?

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

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

4. You have a PDI job where you want to dynamically pass a table name to the Table input step of a transformation. You have replacedthe table name reference in the transformation’s Table input step with‘$(table_name)’ but when the transformation runs the table name is shown as ‘$(table_name)’

Which action will correct this issue?

5. Which two PDI steps are used to parse XML content? (Choose two.)

6. You need to load data from many CSV files into a database and you want to minimize the number of PDI jobs and transformations that need to be maintained.

In which two scenarios is Metadata injection the recommend option? (Choose two.)

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

8. You have slow-running steps in a PDI transformation and you notice that it is taking a long time for subsequent steps to get data and begin processing.

Which action will help solve the problem?

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

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

11. In a PDI transformation you are retrieving data from a large lookup table using a Database Lookup step from improve performance, you enable caching in the stepand use the Load all data from table option.

In this scenario, which three statement s are correct about the data flow of the ‘Database Lookup step? (Choose three.)

12. You need to design a PDI job that will execute a transformation andthen send an e-mail with an attached log of the transformation’s execution.

Which two sets of actions will accomplish this task? (Choose two.)

13. 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.)

14. 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?

15. 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?

16. You want to manage a slowly changing dimension as type II.

Which step in PDI should you use to accomplish this task.

17. you want to make a dynamic PDI transformation that is driven with variables that areloaded from a properties file.

Which free form text fields within a step can be configured with variables?

18. 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 do you accomplish this?

19. You are connecting to a secure Hadoopclusterfrom Pentaho and want to use impersonation.

Which Pentaho tool should you use?

20. You have instated the Pentaho server using an archive installation. You now want to change the server port.

Which file do you modify?