Free Access Hitachi.HCE-5920.v2022-07-05.q26 Practice Test (Page 2)

Question 1

A customer needs to extract data from many afferent text He layouts with new file layouts being identified in the future andthey want to insert the data into corresponding database tables.They are concerned about maintainingmultiple PDI jobs and transformations given the large number of unique files.
What should you do to meet the requirements when creating transformations?

A.Use the Metadata structure of stream step for each file.

B.Use the ETL Metadata injection step

C.Use the Job Executor step for each file.

D.Use the Transformation Executor step for each file.

Question 2

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

A.You can only use the Append streams step to join these two flows.

B.The row layout must be identical between the two steps.

C.You can use the 'Dummy (do nothing)' step to join these two flows.

D.The row layout can be different between the two steps as long as the data types are the same

Question 3

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 Set Variable step before the Table input step in the transformation.

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 transformation entry in the job that uses theGet Variables step.

Question 4

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 faster execution

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

Question 5

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.

Latest Upload: 107Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 155TheSecOpsGroup.CNSP.v2025-09-08.q20; 206CFAInstitute.ESG-Investing.v2025-09-08.q173; 153PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 140Salesforce.Data-Architect.v2025-09-05.q216; 136Adobe.AD0-E605.v2025-09-05.q50; 176Nutanix.NCP-MCI-6.10.v2025-09-05.q55; 114Oracle.1z0-591.v2025-09-05.q104

Question 1

Question 2

Question 3

Question 4

Question 5

Download PDF File