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 19,2024.
- Exam Code: HCE-5920
- Exam Name: Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation
- Certification Provider: Hitachi
- Latest update: Nov 19,2024
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?
- A . Use a Simple Evaluationentry
- B . Add the timeout property in the Advanced Options pane.
- C . Use a Wait For entry
- D . Set the Enable Blocking option
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.)
- A . the Madoop Fie Input step
- B . the Hadoop File Output step
- C . the MapReduce Input step
- D . the MapReduce Output step
Which script will execute jobs stored in a Pentaho server from a command line?
- A . pan
- B . carle
- C . kitchen
- D . spoon
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?
- A . Add a transformation entry in the job that uses theGet Variables step.
- B . Add a transformation entry in the job that sets the table_name variable.
- C . Change the reference in the Table input step to ‘?’
- D . Add a Set Variable step before the Table input step in the transformation.
Which two PDI steps are used to parse XML content? (Choose two.)
- A . the ‘XML Join’ step
- B . the ‘Modified Java Script Value’ stop
- C . the ‘Get data from XML’ step
- D . the ‘Add XML’step
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.)
- A . When the files have a different structure andhave different target tables.
- B . When the files have a different structure and have the same target table.
- C . When the files have the same structure and have different target tables.
- D . When the files have the same structure and have the same target table.
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?
- A . DB_PASSWORD=Encrypted (‘XYZABC 123’)
- B . DB_PASSWORD=String(‘XYZABC123’)
- C . DB_PASSWORD=XYZABC123
- D . DB_PASSWORD=Encrypted XYZABC123
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?
- A . Reduce the value in the Nr’ of rows in rowset’ option on the Miscellaneous tab in the Transformation properties.
- B . Select the ‘Enable step performance monitoring?’ option on the Monitoring tab in the Transformation properties.
- C . Right click on the slow-running steps and select the Load Balance option from the Data Movement submenu.
- D . Select the ‘Execute for every input row? Option on the Advanced tab of the Transformation properties from the parent job.
What are two ways to schedule a PDI job stored in the repository? (Choose two.)
- A . Write a loginscript to start the timer and execute a kitchen script specifying a job in the repository.
- B . Use the pan script specifying a job in the repository and schedule it using cron.
- C . Use the kitchen script specifying a job in the repository and schedule it using cron.
- D . Use Spoon connected to the Pentaho repository and choose Action > Schedule in the menu.
Which two statements are correct about the Repository Explorer? (Choose two.)
- A . You can create new jobs and transformations.
- B . You can move. rename, and delete jobs and transformations.
- C . You can upload JDBC drivers when defining JOBC connections.
- D . You can lock and unlock jobs and transformations.