(2023) HCE-5920 Dumps and Practice Test (61 Questions)

Guide (New 2023) Actual Hitachi HCE-5920 Exam Questions

NEW QUESTION 16
You have a string field in your dataset where you need to extract characters 1-5 only.
Which two steps will accomplish this task? (Choose two.)
Choose 2 answers

• A. The Modified Java Script Value step
• B. the Siring Operations step
• C. the Strings Cut step
• D. the Split Fields stop

Answer: B,C

 

NEW QUESTION 17
You have completed a successful installation of a Pentaho server on Linux.
You now need to write a script to run the Pentaho server as a service.
Which two files shouldyou call from the script? (Choose two.)
Choose 2 answers

• A. stop-pentaho.sh
• B. start-pentaho-debug.
• C. start-pentaho.sh
• D. import-export.sh

Answer: B,C

 

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

• A. KETTLEHOME
• B. PENTAHO_JAVA_HOME
• C. JAVA_HOME
• D. SPOON HOME

Answer: B

Explanation:
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 19
Which two PDI steps are used to parse XML content? (Choose two.)
Choose 2 answers

• A. the 'Get data from XML' step
• B. the 'Modified Java Script Value' stop
• C. the 'Add XML'step
• D. the 'XML Join' step

Answer: B,D

 

NEW QUESTION 20
You are connectingto a secure Hadoop dueler from Pentaho and want to use impersonation.
Which Pentaho tool should you use?

• A. Pentaho Security Manager
• B. Pentaho Report Designer
• C. Pentaho Spoon
• D. Pentaho Server

Answer: B

 

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

• A. server.xml
• B. context.xml
• C. slave-server-config.xml
• D. repositories.xml

Answer: A

Explanation:
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 22
To simplify the migration of a PDI solution from one environment to another, you need to externalize all database connection details.
Which two methods will satisfy this requirement? (Choose two.)
Choose 2 answers

• A. Create a properties file that includes the connection details and use the Set Variables step to load these properties.
• B. Use Manage Data Source to create a new connection in Spoon.
• C. Set the connection details in the Kettle properties file.
• D. Use the Data Source Wizard to generate the connection details.

Answer: C,D

 

NEW QUESTION 23
You are implementing a Pentaho server repository for a customer.
The customer will be using the Pentaho Scheduler.
Which repository supports this requirement?

• A. Kettle Database Repository
• B. Pentaho Repository
• C. Carlo Repository
• D. Kettle File Repository

Answer: B

 

NEW QUESTION 24
A customer has an archive-based installation. They have not configured logging tables or changed the defaultconfiguration 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?

• A. pentaho-server/pentaho
• B. pentaho-service/data
• C. solutions/system/karaf/system/org/apache/karaf/log
  pentaho/server/pentaho-solution/system/karaf/System/commons logging
• D. pentaho-server/tomcat/logs

Answer: B

 

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

• A. When the files have the same structure and have 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 the same target table.
• D. When the files have a different structure andhave different target tables.

Answer: B,C

 

NEW QUESTION 26
You are adding an 'MD5_ Value' column to the dimension table to uniquely identify a record in the source system.
Which step should you use to accomplish this tasks?

• A. the 'Formula' step
• B. the "String operations' step
• C. the' Add a checksum' step
• D. the 'Concat Fields' step

Answer: D

 

NEW QUESTION 27
A customer has an existing PDI job that calls a transformation. They want to execute the transformation through Spark on their Hadoop cluster.
Which change must be made to satisfy this requirement?

• A. Change the Parameters of the transformation
• B. Change the Run Configuration of the transformation
• C. Change the Arguments of the transformation
• D. Change theLogging options of the transformation

Answer: B

 

NEW QUESTION 28
You are running a PDI Joband you need to identify when something fails for a specific job entry to notify the sysops team about the failure.
Which statement is correct in this scenario?

• A. Definethe false evaluation hop out of the job entry that you are going to verify.
• B. Define the unconditional evaluation hop out of the job entry that you are going to verify.
• C. Do not define any evaluation hop out of the Job entry that are going to verify.
• D. Define the true evaluation hop out of the job entry that you are going to verify.

Answer: C

 

NEW QUESTION 29
In a PDI transformation you are retrieving data from a large lookup table using a Database Lookup stepfromimprove performance, you enable caching in the step and 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.)

• A. When caching is enable, only rows with matching lookup values will passed through.
• B. Cached comparisons are case sensitive.
• C. Only one matching row is used from the Lookup table.
• D. There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.
• E. Every input row must have only one matching row in the lookup table

Answer: A,B,D

 

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

• A. Use Spoon connected to the Pentaho repository and choose Action > Schedule in the menu.
• B. Use the kitchen script specifying a job in the repository and schedule it using cron.
• C. Write a login script to startthe timer and execute a kitchen script specifying a job in the repository.
• D. Use the pan script specifying a job in the repository and schedule it using cron.

Answer: B,D

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

 

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

• A. Multiple steps can receive data from the input step.
• B. The steps will receive a stream of data from the input as soon as it is a available.
• C. The steps will receive the data once the input step fully fetches it.
• D. Only one step can receive data from the input step.

Answer: A,C

 

NEW QUESTION 32
Which two statements are correct about the Repository Explorer? (Choose two.) Choose 2 answers

• A. You can move. rename, and delete jobs and transformations.
• B. You can lock and unlockjobs and transformations.
• C. You can upload JDBC drivers when defining JOBC connections.
• D. You can create new jobs and transformations.

Answer: A,B

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

 

NEW QUESTION 33
you want to make a dynamic PDI transformation that is driven with variables that are loaded from a properties file.
Which free form text fields within a step can be configured with variables?

• A. Any free form text field with a ''V'' next to it
• B. Any free form text field with the variable name entered in all caps
• C. any free form text field with a '$' sign next to it.
• D. any free form text field with a '@' sign next to it.

Answer: D

 

NEW QUESTION 34
Which statement is true for a transformation?

• A. Transformation steps are executed in parallel.
• B. A transformation step processes one row at a time.
• C. A transformation must have a start step.
• D. A transformation step can have only one incoming hop and one outgoing hop.

Answer: C

 

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

• A. Add the timeout property in the Advanced Options pane.
• B. Use a Simple Evaluation entry
• C. Set the Enable Blocking option
• D. Use a Wart For entry

Answer: D

 

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

• A. When the files have the same structure and have different target tables.
• B. When the files have a different structure and have the same target table.
• C. When the files have a different structure and have different target tables.
• D. When the files have the same structure and have the same target table.

Answer: B,D

 

NEW QUESTION 37
......

HCE-5920 Exam Dumps Pass with Updated 2023 Certified Exam Questions: https://www.vce4dumps.com/HCE-5920-valid-torrent.html

HCE-5920 Exam Questions - Real & Updated Questions PDF: https://drive.google.com/open?id=1ILPwSpvrbsB6zkkcUrUir_5mkwOxoafl