[Mar 01, 2023] Download Free Hitachi HCE-5920 Real Exam Questions [Q20-Q38] – IT Certification Exam Questions & Answers

Rate this post

[Mar 01, 2023] Download Free Hitachi HCE-5920 Real Exam Questions

Pass Your Exam With 100% Verified HCE-5920 Exam Questions

Hitachi HCE-5920 Exam Syllabus Topics:

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

NEW QUESTION 20
A Big Datacustomer is experiencing failures on a Tableinput stepwhen running a PDl transformation on AEL Sparkagainst a large Oracle database.
What are two methods to resolve this issue? (Choose two.)
Choose 2 answers

Increase the maximum size of the message butters tor your AEL environment.

Load the data to HDFS before running the transform.

Add the Step ID to the Configuration File.

Increase the Spark driver memory configuration.

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

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

NEW QUESTION 23
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.) Choose 2 answers

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.

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

NEW QUESTION 25
You have multiple transformations that read and process data from multiple text files. You identity a series of stepsthat are common across transformations and you want to re-use them to avoid duplication of code.
How do youaccomplishthis?

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

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

NEW QUESTION 27
You need to load data from many CSV files intoa 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.) Choose 2 answers

When the files have a different structure and have 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.

NEW QUESTION 28
You have a PDI job where you want to dynamically pass a table name to the Table input step of a transformation. You have replaced the 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 the Get 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.

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

KETTLEHOME

JAVA_HOME

PENTAHO_JAVA_HOME

SPOON HOME

NEW QUESTION 30
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=Encfypted(“XYZABC 123*)

DB_PASSWORD=StringrXYZABC123″)

DB_PASSWORD-XYZABC123

DB_PASSWORD-Encrypted XY2ABC123

NEW QUESTION 31
you want to enable PDI step monitoring Since memory resources are limited. you decide to set a limit to vie number of snapshots.
Which option should be used to accomplish this task?

the Logging interval(seconds)’ option in the Performance section

The ‘Limit’ option in the Snapshot tab

the ‘KETTLE_MAX_JOB_TRACKER_SIZE’ option in kettle properties.

The ‘Maximum number of snapshots in memory option in the Monitoring tab

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

NEW QUESTION 33
Which two steps in a transformation allow variable values to 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 34
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 35
A client is developing a Web application to implement a wizard-like application used by many users. At several points in 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.

NEW QUESTION 36
You are connecting to a secure Hadoopclusterfrom Pentaho and want to use impersonation.
Which Pentaho tool should you use?

Pentaho Report Designer

Pentaho Spoon

Pentaho Security Manager

Pentaho Server

NEW QUESTION 37
A Big Data customer wants to run POI transformations on Spark on their production Hadoop cluster using Pentaho’s Adaptive Execution Layer (AEL) What are two stepsforinstalling AEL? (Choose two.) Choose 2 answers

Run the Spark application butter tool to obtain the AEL daemon zip file.

Configure the AEL daemon in Local Mode.

Run the AEL Oozie job to install the AEL daemon.

Configure the AEL daemon in YARN Mode

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