Free Hitachi HCE-5920 Exam Questions & Answer from Training Expert PrepAwayETE [Q18-Q33]

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

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

Q20. you want to enable PDI step monitoring Since memory resources are limited. you decide to set a limit to vie number of snapshots.
Which option should be used to accomplish this task?

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

Q22. You are running a PDI Job and you need to identify when something fails for a specific job entry to notify the sysops team about the failure.
Which statement is correct in this scenario?

Q23. You have a PDI job where you want to dynamically pass a table name to the Table input step of a transformation. You have replaced the 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?

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

Q25. You have used for copies of the Sort rows step in parallel on the local JVM using the ‘Change number of copies to start option.
Each of the sorted stream need to be merged together to ensure the proper sort sequence.
Which step should be used in this scenario?

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

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

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

Q29. What must be the first PDI step in a child transformation ingesting records from Kafka?

Q30. You are running a Pentaho MapReduce (PMR) job that is facing on Hadoop.You review the YARN logs and determine that the mappersare generating out of memory errors.
Which action will resolve the mapper errors?

Q31. You are developing the PDI solution for a customer. The customer requires that a set of SQL statements are executed on each connection to the database.
Which method will satisfy this requirement?

Q32. You need to process dataon 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.) Choose 2 answers

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