Pentaho Data Integration Implementation HCE-5920 Questions and Answers

dumps2022-05-25T01:58:53+08:00

HCE-5920 Pentaho Data Integration Implementation exam is much easier for you to pass. Knowing Hitachi Certificatin HCE-5920 exam information is first step for you to study teh test. There are 60 questions in real HCE-5920 exam, and you have 90 minutes (120 minutes for non-English-speaking countries) to finish the test. The required passing score of HCE-5920 exam is 63%. Free Hitachi Vantara Certified Specialist HCE-5920 exam questions and answers are below.

Page 1 of 2

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?

Use a Simple Evaluationentry

Add the timeout property in the Advanced Options pane.

Use a Wait For entry

Set the Enable Blocking option

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

the Madoop Fie Input step

the Hadoop File Output step

the MapReduce Input step

the MapReduce Output step

3. Which script will execute jobs stored in a Pentaho server from a command line?

pan

carle

kitchen

spoon

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?

Add a transformation entry in the job that uses theGet Variables step.

Add a transformation entry in the job that sets the table_name variable.

Change the reference in the Table input step to ‘?’

Add a Set Variable step before the Table input step in the transformation.

5. Which two PDI steps are used to parse XML content? (Choose two.)

the 'XML Join' step

the 'Modified Java Script Value' stop

the 'Get data from XML' step

the 'Add XML'step

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

When the files have a different structure andhave different target tables.

When the files have a different structure and have the same target table.

When the files have the same structure and have different target tables.

When the files have the same structure and have the same target table.

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?

DB_PASSWORD=Encrypted (‘XYZABC 123’)

DB_PASSWORD=String(‘XYZABC123’)

DB_PASSWORD=XYZABC123

DB_PASSWORD=Encrypted XYZABC123

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?

Reduce the value in the Nr’ of rows in rowset’ option on the Miscellaneous tab in the Transformation properties.

Select the ‘Enable step performance monitoring?’ option on the Monitoring tab in the Transformation properties.

Right click on the slow-running steps and select the Load Balance option from the Data Movement submenu.

Select the ‘Execute for every input row? Option on the Advanced tab of the Transformation properties from the parent job.

9. What are two ways to schedule a PDI job stored in the repository? (Choose two.)

Write a loginscript to start the timer and execute a kitchen script specifying a job in the repository.

Use the pan script specifying a job in the repository and schedule it using cron.

Use the kitchen script specifying a job in the repository and schedule it using cron.

Use Spoon connected to the Pentaho repository and choose Action > Schedule in the menu.

10. Which two statements are correct about the Repository Explorer? (Choose two.)

You can create new jobs and transformations.

You can move. rename, and delete jobs and transformations.

You can upload JDBC drivers when defining JOBC connections.

You can lock and unlock jobs and transformations.

Page 2 of 2

11. 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.)

When caching is enable, only rows with matching lookup values will passed through.

There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.

Cached comparisons are case sensitive.

Every input row must have only one matching row in the lookup table

Only one matching row is used from the Lookup table.

12. 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.)

In the mail entry’s options, select the ‘Attach files to message’ option and select the filetype ‘Log’

In the Transformation entry option, select the ‘Specify logfile’ option and enter a name and extension for the file.

In the log tab of job properties, configure the Log Connection and the Log table options for the Job entry log tablesection.

In the Mail entry’s options, select the ‘Attach files to message’ option and select the file type General’

13. 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.)

The steps will receive a stream of data from the input as soon as it is a available.

Only one step can receive data from the input step.

The steps will receive the data once the input step fully fetches it.

Multiple steps can receive data from the input step.

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

Use the Web service API to execute the jobs and transformations on the Pentaho server.

Use the scheduling tool of the OS to execute the job and transformation on the pentaho server.

Use the Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.

Use the Job and Transformation steps to execute the jobs and transformations on the Pentaho server.

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

Execute the transformation via the pan script and pass the performance gathering parameter.

Ensure there is enough memory on the Pentaho server and that there are no "Out Of Memory' errors in the log.

Make sure the customer is using data partitioning to ensure parallel processing for fasterexecution

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

16. You want to manage a slowly changing dimension as type II.

Which step in PDI should you use to accomplish this task.

The ‘Shared Dimension’ step

The ‘Dimension Lookup/update’ step

The ‘Combination lookup/update’ step

The ‘Table output step

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

Any free form text field with a ''V'' next to it

any free form text field with a '@' sign next to it.

any free form text field with a '$' sign next to it.

Any free form text field with the variable name entered in all caps

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

Use the "Mapping (sub-transformation)' step containing the series of steps.

Use the ETL Metadata Infection' stop containing the series of steps.

Use the "Get data from XML' step to read the series of steps

Use the 'Job Executor1 step containing the series of steps

Pentaho Data Integration Implementation HCE-5920 Questions and Answers

Pentaho Data Integration Implementation HCE-5920 Questions and Answers

Share this post

Leave a Reply Cancel reply

Related Posts

Hitachi Vantara Qualified Professional HQT-4180 Exam Questions