Updated Dec-2022 Official licence for HCE-5920 Certified by HCE-5920 Dumps PDF [Q22-Q39]

4.7/5 - (3 votes)

Updated Dec-2022 Official licence for HCE-5920 Certified by HCE-5920 Dumps PDF

Grab latest Amazon HCE-5920 Dumps as PDF Updated on 2022

Hitachi HCE-5920 Exam Syllabus Topics:

Topic	Details
Topic 1	Describe usage of metadata injection Describe how to manage the repository
Topic 2	Demonstrate knowledge of how to manage data connections in PDI Describe how to use streaming steps
Topic 3	Demonstrate knowledge of Pentaho Server installation and configuration Describe the Data Integration client and server components
Topic 4	Describe how data flows within PDI jobs and transformations Demonstrate knowledge of the steps used to create a PDI job

NEW QUESTION 22
You need to download files from a web site as part of a PDI job.
Which job entry will accomplish this task?

HTTP

Sqoop import

Get a files with FTP

Copy Files

NEW QUESTION 23
What are Job checkpoints?

Error handing hops that manage e-mail notifications.

Points in a job that have finished successfully and are automatically skipped after a previously failed run

Points in a job that log the step metrics during certain intervals

Points in a job that sends a heartbeat request to the Pentaho server to ensure connectivity.

NEW QUESTION 24
You need to process dataon 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.) Choose 2 answers

the Madoop Fie Input step

the Hadoop File Output step

the MapReduce Input step

the MapReduce Output step

NEW QUESTION 25
You execute a transformation locally in Spoon to read data from an Oracle database and you receive the Drive not found’ exception.
What are two ways to solve this problem? (Choose two.)
Choose 2 answers

Copy the Oracle JDBC driver to the data-integration/lib folder of PDI.

Copy of the Oracle JDBC driver to the tomcat/lib folder of the Pentaho server.

Use the PDI import script

Use the JDBC Distribution Tools.

NEW QUESTION 26
You are running a Pentaho MapReduce (PMR) job that is facing on Hadoop.You review the YARN logs and determine that the mappersare generating out of memory errors.
Which action will resolve the mapper errors?

Edit me Pentahoserver startup script to increase the memory setting

Increase the Number of mapper tacks in the PMR step.

Set the JVM memory parameters appropriatelyin the User Denned tab ofthe PMR step

Set the Enable blocking option in the PMR step.

NEW QUESTION 27
You have a PDI job with an Oozie Job Executor entry and you want this job entry to finish before the next fob entry starts.
How do you accomplish this task?

Use a Simple Evaluation entry

Add the timeout property in the Advanced Options pane.

Use a Wart For entry

Set the Enable Blocking option

NEW QUESTION 28
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?

Use the Metadata structure of stream step for each file.

Use the Transformation Executor step for each file.

Use the ETL Metadata injection step

Use the Job Executor step for each file.

NEW QUESTION 29
A customer has an archive-basedinstallation. They have not configured logging tables or changed the default configuration settings.They need to research an issue that has been affecting one of their scheduled PDI jobs for the past week.
In this situation, where do they go to view more details about the execution of these jobs?

pentaho-server/tomcat/logs

pentaho-service/data

pentaho-server/pentaho

solutions/system/karaf/system/org/apache/karaf/logpentaho/server/pentaho-solution/system/karaf/System/commons logging

NEW QUESTION 30
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.

NEW QUESTION 31
You are preparing a server environment for an archive installation of a Pentaho server According to HitachiVantara best practices which environment variable should be set?

KETTLEHOME

JAVA_HOME

PENTAHO_JAVA_HOME

SPOON HOME

Explanation
Set environment variablesIf you do not set the HOME environment variables, Pentaho will not start correctly.Complete the steps in this topic to ensure that you have set the HOME environment variables properly.
* Set the path of the PENTAHO_JAVA_HOME variable to the path of your Java installation, as shown:
SET PENTAHO_JAVA_HOME=C:\Program Files\Java\jdk8.x.x.x
* (Optional) If you are using a JRE, then also set the JRE_HOME home environment variable.
* Log off and log on again, then verify the variables have been properly set by using a command similar to the following example:
ECHO %PENTAHO_JAVA_HOME%
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Prepare_your_Windows_environment_for_an

NEW QUESTION 32
You have instated the Pentaho server using an archive installation. You now want to change the server port.
Whichfile do you modify?

server.xml

repositories.xml

context.xml

slave-server-config.xml

Explanation
Follow the instructions below to change the port through which the Pentaho Server runs:
* Stop the Pentaho Server.
* Navigate to the /pentaho-server/tomcat/conf/ directory.
* Open the server.xml file with any text editor, and search for the value for Define a non-SSL HTTP/1.1 Connector.
Change the port number in the connector port element below from 8080 to your preferred port number.
https://help.hitachivantara.com/Documentation/Pentaho/9.0/Setup/Customize_the_Pentaho_Server#:~:text=Chan

NEW QUESTION 33
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

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

The row layout must be identical between the two steps.

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

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

Explanation
https://help.hitachivantara.com/Documentation/Pentaho/7.0/0L0/0Y0/030/010

NEW QUESTION 34
Which two steps in a transformation allow variable valuesto be used throughout the rest of a PDI job? (Choose two.) Choose 2 answers

the ‘Set Variables’ step

the ‘Select values’ step

the ‘Table inpuT step

the Modified Java Script Value’ step

NEW QUESTION 35
What are two ways to schedule a PDI job stored in the repository? (Choose two.) Choose 2 answers

Write a login script to startthe 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.

Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.1/Products/Data_Integration/Schedule_Perspective#:~

NEW QUESTION 36
A transformation is running in a production environment and you want to monitor it in real time.
Which tool should you use?

Pentaho Operations Mart

Kettle status page

Log4j

Monitoring tab

NEW QUESTION 37
You have used for copies of the Sort rows step in parallel on the local JVM using the ‘Change number of copies to start option.
Each of the sorted stream need to be merged together to ensure the proper sort sequence.
Which step should be used in this scenario?

the Sorted Merge step

the Merge Join step

the Dummy step

the Append Streams step

NEW QUESTION 38
Which statement is true for a transformation?

Transformation steps are executed in parallel.

Atransformation must have a start step.

A transformation step processes one row at a time.

A transformation step can have only one incoming hop and one outgoing hop.

NEW QUESTION 39
You are developing the PDI solution for a customer. The customer requires that a set of SQL statements are executed on each connection to the database.
Which method will satisfy this requirement?

Use JNDI to specify the SQL statements.

Use the Advanced section in the Database Connection window to enter the SQL statements.

Use the Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.

Use the Database Connection wizard and specify SQL statements.

Loading …