HCE-5920 PDF Dumps 2023 Exam Questions with Practice Test
Dumps for Free HCE-5920 Practice Exam Questions
NEW QUESTION 14
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 transformation entry in the job that sets the table_name variable.
- B. Add a Set Variable step before the Table input step in the transformation.
- C. Change the reference in the Table input step to '?'
- D. Add a transformation entry in the job that uses theGet Variables step.
Answer: B
NEW QUESTION 15
You have a PDI job that gets a list of variables followed by three subsequent transformation entries. Since the three subsequent transformation entries are not dependent on each other. You want to execute them at the same time.
According the Hitachi Vantara best practices, how do you accomplish this task?
- A. Increase the Change Number of Copies to Start option on the input step of each of the subsequenttransformations.
- B. Select the Enable Downstream setting from the Hop Bulk Change submenu.
- C. Select the Run Next Entries in Parallel option for the job entry that gathers variables.
- D. Select the Run Next Entries in Parallel option for the three independent transformation entries.
Answer: D
NEW QUESTION 16
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' Add a checksum' step
- C. the "String operations' step
- D. the 'Concat Fields' step
Answer: D
NEW QUESTION 17
Which statement is true for a transformation?
- A. A transformation step can have only one incoming hop and one outgoing hop.
- B. A transformation step processes one row at a time.
- C. Transformation steps are executed in parallel.
- D. Atransformation must have a start step.
Answer: D
NEW QUESTION 18
You are installing a Pentaho server and you decide to use a responsibility database other than Postgres.
Which two database are supported in this configuration? (Choose two.) Choose 2 answers
- A. Sybase
- B. DB2
- C. Oracle
- D. Microsoft SQL Server
Answer: C,D
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Use_PostgreSQL_as_your_repository_databas
NEW QUESTION 19
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 satisfythisrequirement?
- A. Change the Arguments of the transformation
- B. Change the Logging options of the transformation
- C. Change the Run Configuration of the transformation
- D. Change the Parameters of the transformation
Answer: C
NEW QUESTION 20
An existing PDI job that checks the availability of a Web service is a sending a failure email even when the Web service is available.
You want this failure email to be sent only when the Web service is unavailable.
What should you do on tie hop between me two entries?
- A. Set the hop Evaluation option to Unconditional.
- B. Set the hop Evaluation option to Follow When Result a True.
- C. Set the hop Evaluation option to Follow When.
- D. Flip the direction
Answer: D
NEW QUESTION 21
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. import-export.sh
- B. stop-pentaho.sh
- C. start-pentaho.sh
- D. start-pentaho-debug.
Answer: C,D
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?
- A. HTTP
- B. Get a files with FTP
- C. Copy Files
- D. Sqoop import
Answer: A
NEW QUESTION 23
You have a job that uses a Pentaho MapReduce entry to read four input files, and that outputs words and their counts to one output file.
How shouldyou set the number of reducer tasks?
- A. Set it to 0.
- B. Set it to 4.
- C. Set it to blank.
- D. Set it to 1.
Answer: C
NEW QUESTION 24
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?
- A. the Logging interval(seconds)' option in the Performance section
- B. the 'KETTLE_MAX_JOB_TRACKER_SIZE' option in kettle properties.
- C. The 'Maximum number of snapshots in memory option in the Monitoring tab
- D. The 'Limit' option in the Snapshot tab
Answer: C
NEW QUESTION 25
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
- A. Load the data to HDFS before running the transform.
- B. Increase the Spark driver memory configuration.
- C. Add the Step ID to the Configuration File.
- D. Increase the maximum size of the message butters tor your AEL environment.
Answer: A,D
NEW QUESTION 26
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. Use the Data Source Wizard to generate the connection details.
- B. Use Manage Data Source to create a new connection in Spoon.
- C. Create a properties file that includes the connection details and use the Set Variables step to load these properties.
- D. Set the connection details in the Kettle properties file.
Answer: A,D
NEW QUESTION 27
You are connecting to a secure Hadoopclusterfrom Pentaho and want to use impersonation.
Which Pentaho tool should you use?
- A. Pentaho Spoon
- B. Pentaho Report Designer
- C. Pentaho Security Manager
- D. Pentaho Server
Answer: B
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?
- A. Add a transformation entry in the job that uses the Get Variables step.
- B. Add a Set Variable step before the Table input step in the transformation.
- C. Add a transformation entry in the job that sets the table-name variable.
- D. Change the reference in the Table input step to '?'
Answer: B
NEW QUESTION 29
You have instated the Pentaho server using an archive installation. You now want to change the server port.
Whichfile do you modify?
- A. context.xml
- B. server.xml
- C. slave-server-config.xml
- D. repositories.xml
Answer: B
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 30
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. Cached comparisons are case sensitive.
- B. There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.
- C. Only one matching row is used from the Lookup table.
- D. Every input row must have only one matching row in the lookup table
- E. When caching is enable, only rows with matching lookup values will passed through.
Answer: A,B,E
NEW QUESTION 31
You are planning to connect to a secured Hadoop duster
from Pentaho.
Which two authentication methods are supported? (Choose two)
Choose 2 answers
- A. X.509 Certificate
- B. Keytan
- C. Password
- D. Trusted
Answer: B,D
NEW QUESTION 32
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
- A. the MapReduce Output step
- B. the MapReduce Input step
- C. the Madoop Fie Input step
- D. the Hadoop File Output step
Answer: B,C
NEW QUESTION 33
What are two ways to schedule a PDI job stored in the repository? (Choose two.) Choose 2 answers
- A. Use the pan script specifying a job in the repository and schedule it using cron.
- B. Use Spoon connected to the Pentaho repository and choose Action > Schedule in the menu.
- C. Use the kitchen script specifying a job in the repository and schedule it using cron.
- D. Write a login script to startthe timer and execute a kitchen script specifying a job in the repository.
Answer: A,C
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.1/Products/Data_Integration/Schedule_Perspective#:~
NEW QUESTION 34
You need to populate a fact table with the corresponding surrogate keys from each dimension table Which two steps accomplish this task? (Choose two.) Choose 2 answers
- A. the 'Filter rows' step
- B. the 'Combination lookup/update' step
- C. the 'Select values' step
- D. the Dimension lookup/update' step
Answer: B,D
NEW QUESTION 35
......
Hitachi HCE-5920 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
Check your preparation for Hitachi HCE-5920 On-Demand Exam: https://examcollection.prep4sureguide.com/HCE-5920-prep4sure-exam-guide.html