[UPDATED 2022] Hitachi HCE-5920 Questions Prepare with Free Demo of PDF
NEW 2022 Certification Sample Questions HCE-5920 Dumps & Practice Exam
Hitachi HCE-5920 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
NEW QUESTION 29
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?
- A. the Append Streams step
- B. the Merge Join step
- C. the Dummy step
- D. the Sorted Merge step
Answer: B
NEW QUESTION 30
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?
- A. Set the Enable blocking option in the PMR step.
- B. Increase the Number of mapper tacks in the PMR step.
- C. Edit me Pentahoserver startup script to increase the memory setting
- D. Set the JVM memory parameters appropriatelyin the User Denned tab ofthe PMR step
Answer: C
NEW QUESTION 31
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?
- A. DB_PASSWORD-Encrypted XY2ABC123
- B. DB_PASSWORD=StringrXYZABC123")
- C. DB_PASSWORD=Encfypted("XYZABC 123*)
- D. DB_PASSWORD-XYZABC123
Answer: C
NEW QUESTION 32
Which statement is true for a transformation?
- A. Atransformation must have a start step.
- B. A transformation step can have only one incoming hop and one outgoing hop.
- C. A transformation step processes one row at a time.
- D. Transformation steps are executed in parallel.
Answer: A
NEW QUESTION 33
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?
- A. Use the Database Connection wizard and specify SQL statements.
- B. Use the Advanced section in the Database Connection window to enter the SQL statements.
- C. Use the Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.
- D. Use JNDI to specify the SQL statements.
Answer: C
NEW QUESTION 34
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?
- A. Use the Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.
- B. Use the Job and Transformation steps to execute the jobs and transformations on the Pentaho server.
- C. Use the scheduling tool of the OS to execute the job and transformation on the pentaho server.
- D. Use the Web service API to execute the jobs and transformations on the Pentaho server.
Answer: A
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command_Line_Tools
NEW QUESTION 35
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?
- A. Select the 'Enable step performance monitoring?' option on the Monitoring tab in the Transformation properties.
- B. Reduce the value in the Nr' of rows in rowset' option on the Miscellaneous tab in the Transformation properties.
- C. Select the 'Execute for every input row? Option on the Advanced tab of the Transformation properties from the parent job.
- D. Right click on the slow-running steps and select the Load Balance option from the Data Movement submenu.
Answer: B
NEW QUESTION 36
Which two steps in a transformation allow variable valuesto be used throughout the rest of a PDI job? (Choose two.) Choose 2 answers
- A. the 'Set Variables' step
- B. the 'Table inpuT step
- C. the 'Select values' step
- D. the Modified Java Script Value' step
Answer: A,D
NEW QUESTION 37
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 'Select values' step
- C. the Dimension lookup/update' step
- D. the 'Combination lookup/update' step
Answer: C,D
NEW QUESTION 38
The log files on a Pentaho server rotate daily and are getting too large. You want to change want logs to rotate hourly.
how do you adjust the log settings?
- A. Modify the start-pentaho bat or start-pentaho.sh script
- B. Modify the Pentaho server's tog4j.xml.
- C. Modify the Tomcat startup bat or startup.sh script
- D. Modify the transformation's properties.
Answer: D
NEW QUESTION 39
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
- A. Configure the AEL daemon in YARN Mode
- B. Configure the AEL daemon in Local Mode.
- C. Run the Spark application butter tool to obtain the AEL daemon zip file.
- D. Run the AEL Oozie job to install the AEL daemon.
Answer: A,B
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Set_up_the_Adaptive_Execution_Layer_(AEL
NEW QUESTION 40
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. Microsoft SQL Server
- B. DB2
- C. Sybase
- D. Oracle
Answer: A,D
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Use_PostgreSQL_as_your_repository_databas
NEW QUESTION 41
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. Do not define any evaluation hop out of the Job entry that are going to verify.
- C. Define the true evaluation hop out of the job entry that you are going to verify.
- D. Define the unconditional evaluation hop out of the job entry that you are going to verify.
Answer: B
NEW QUESTION 42
What must be the first PDI step in a child transformation ingesting records from Kafka?
- A. Get data from Kafka
- B. Get records from stream
- C. Kafka Consumer
- D. Get rows from result
Answer: D
NEW QUESTION 43
You are planning to connect to a secured Hadoop duster
from Pentaho.
Which two authentication methods are supported? (Choose two)
Choose 2 answers
- A. Password
- B. Keytan
- C. X.509 Certificate
- D. Trusted
Answer: B,D
NEW QUESTION 44
Which content is found in the kettle, properties files?
- A. default language translations
- B. global variables
- C. repository connection properties
- D. stared database objects
Answer: D
NEW QUESTION 45
You are migrating to a new version of the Pentaho server and you want to import your old repository.
What are two methods to accomplish this task? (Choose two.) Choose 2 answers
- A. Using Spoon Tools > Repository > import Repository
- B. Use the encr script.
- C. Use the pan script
- D. Use the import-export script.
Answer: A,D
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/6.0/0P0/0U0/040
NEW QUESTION 46
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 transformation entry in the job that uses theGet Variables step.
- C. Change the reference in the Table input step to '?'
- D. Add a Set Variable step before the Table input step in the transformation.
Answer: D
NEW QUESTION 47
Which script will execute jobs stored in a Pentaho server from a command line?
- A. carle
- B. spoon
- C. pan
- D. kitchen
Answer: C
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command_Line_Tools
NEW QUESTION 48
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. Change the reference in the Table input step to '?'
- C. Add a transformation entry in the job that sets the table-name variable.
- D. Add a Set Variable step before the Table input step in the transformation.
Answer: D
NEW QUESTION 49
Which two steps in a transformation allow variable values to be used throughout the rest of a PDI job?
(Choose two.)
Choose 2 answers
- A. the 'Set Variables' step
- B. the 'Table inpuT step
- C. the 'Select values' step
- D. the Modified Java Script Value' step
Answer: A,D
NEW QUESTION 50
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. Every input row must have only one matching row in the lookup table
- B. Only one matching row is used from the Lookup table.
- C. There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.
- D. Cached comparisons are case sensitive.
- E. When caching is enable, only rows with matching lookup values will passed through.
Answer: C,D,E
NEW QUESTION 51
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 Run Next Entries in Parallel option for the job entry that gathers variables.
- C. Select the Enable Downstream setting from the Hop Bulk Change submenu.
- D. Select the Run Next Entries in Parallel option for the three independent transformation entries.
Answer: D
NEW QUESTION 52
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. start-pentaho.sh
- C. stop-pentaho.sh
- D. start-pentaho-debug.
Answer: B,D
NEW QUESTION 53
......
HCE-5920 Deluxe Study Guide with Online Test Engine: https://exampasspdf.testkingit.com/Hitachi/latest-HCE-5920-exam-dumps.html