Hitachi HCE-5920 Hitachi Vantara Certified Specialist – Pentaho Data Integration Implementation Online Training
Hitachi HCE-5920 Online Training
The questions for HCE-5920 were last updated at Nov 23,2024.
- Exam Code: HCE-5920
- Exam Name: Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation
- Certification Provider: Hitachi
- Latest update: Nov 23,2024
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.)
- A . When caching is enable, only rows with matching lookup values will passed through.
- B . There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.
- C . Cached comparisons are case sensitive.
- D . Every input row must have only one matching row in the lookup table
- E . Only one matching row is used from the Lookup table.
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.)
- A . In the mail entry’s options, select the ‘Attach files to message’ option and select the filetype ‘Log’
- B . In the Transformation entry option, select the ‘Specify logfile’ option and enter a name and extension for the file.
- C . In the log tab of job properties, configure the Log Connection and the Log table options for the Job entry log tablesection.
- D . In the Mail entry’s options, select the ‘Attach files to message’ option and select the file type General’
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.)
- A . The steps will receive a stream of data from the input as soon as it is a available.
- B . Only one step can receive data from the input step.
- C . The steps will receive the data once the input step fully fetches it.
- D . Multiple steps can receive data from the input step.
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 Web service API to execute the jobs and transformations on the Pentaho server.
- B . Use the scheduling tool of the OS to execute the job and transformation on the pentaho server.
- C . Use the Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.
- D . Use the Job and Transformation steps to execute the jobs and transformations on the Pentaho server.
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 . Execute the transformation via the pan script and pass the performance gathering parameter.
- B . Ensure there is enough memory on the Pentaho server and that there are no "Out Of Memory’ errors in the log.
- C . Make sure the customer is using data partitioning to ensure parallel processing for fasterexecution
- D . 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
You want to manage a slowly changing dimension as type II.
Which step in PDI should you use to accomplish this task.
- A . The ‘Shared Dimension’ step
- B . The ‘Dimension Lookup/update’ step
- C . The ‘Combination lookup/update’ step
- D . The ‘Table output step
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?
- A . Any free form text field with a ”V” next to it
- B . any free form text field with a ‘@’ sign next to it.
- C . any free form text field with a ‘$’ sign next to it.
- D . Any free form text field with the variable name entered in all caps
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?
- A . Use the "Mapping (sub-transformation)’ step containing the series of steps.
- B . Use the ETL Metadata Infection’ stop containing the series of steps.
- C . Use the "Get data from XML’ step to read the series of steps
- D . Use the ‘Job Executor1 step containing the series of steps
You are connecting to a secure Hadoopclusterfrom Pentaho and want to use impersonation.
Which Pentaho tool should you use?
- A . Pentaho Report Designer
- B . Pentaho Spoon
- C . Pentaho Security Manager
- D . Pentaho Server
You have instated the Pentaho server using an archive installation. You now want to change the server port.
Which file do you modify?
- A . server.xml
- B . repositories.xml
- C . context.xml
- D . slave-server-config.xml
Latest HCE-5920 Dumps Valid Version with 60 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
