Hitachi HCE-5920 Practice Test Questions

1. HCE-5920 HCE-5920 P Practice Exam ractice Exam Hitachi Vantara Certified Specialist - Pentaho Data Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation Integration Implementation https://www.passquestion.com/HCE-5920.html https://www.passquestion.com/HCE-5920.html

2. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 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? 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 Answer: C

3. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 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.) A. the Madoop Fie Input step B. the Hadoop File Output step C. the MapReduce Input step D. the MapReduce Output step Answer: A,C

4. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 3. Which script will execute jobs stored in a Pentaho server from a command line? A. pan B. carle C. kitchen D. spoon Answer: A

5. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 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? 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. Answer: D

6. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 5. 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 Answer: A,B

7. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 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.) 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. Answer: B,D

8. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 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? A. DB_PASSWORD=Encrypted (‘XYZABC 123’) B. DB_PASSWORD=String(‘XYZABC123’) C. DB_PASSWORD=XYZABC123 D. DB_PASSWORD=Encrypted XYZABC123 Answer: A

9. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 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? 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. Answer: A

10. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 9. 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. Answer: B,C

11. Download valid HCE-5920 Practice Exam From PassQuestion Download valid HCE-5920 Practice Exam From PassQuestion 10. 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. Answer: B,D