Prepare HCE-5920 Question Answers - HCE-5920 Exam Dumps
Real Hitachi HCE-5920 Exam Questions [Updated 2022]
NEW QUESTION 23
A transformation is running in a production environment and you want to monitor it in real time.
Which tool should you use?
- A. Log4j
- B. Kettle status page
- C. Pentaho Operations Mart
- D. Monitoring tab
Answer: D
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
- A. the MapReduce Input step
- B. the Madoop Fie Input step
- C. the Hadoop File Output step
- D. the MapReduce Output step
Answer: A,B
NEW QUESTION 25
What are Job checkpoints?
- A. Points in a job that have finished successfully and are automatically skipped after a previously failed run
- B. Points in a job that log the step metrics during certain intervals
- C. Error handing hops that manage e-mail notifications.
- D. Points in a job that sends a heartbeat request to the Pentaho server to ensure connectivity.
Answer: B
NEW QUESTION 26
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 Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.
- C. Use the Advanced section in the Database Connection window to enter the SQL statements.
- D. Use JNDI to specify the SQL statements.
Answer: B
NEW QUESTION 27
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' Add a checksum' step
- B. the 'Formula' step
- C. the "String operations' step
- D. the 'Concat Fields' step
Answer: D
NEW QUESTION 28
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 create new jobs and transformations.
- C. You can lock and unlockjobs and transformations.
- D. You can upload JDBC drivers when defining JOBC connections.
Answer: A,C
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/7.0/0L0/0Y0/040/010
NEW QUESTION 29
Which two PDI steps are used to parse XML content? (Choose two.)
Choose 2 answers
- A. the 'XML Join' step
- B. the 'Get data from XML' step
- C. the 'Modified Java Script Value' stop
- D. the 'Add XML'step
Answer: A,C
NEW QUESTION 30
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. start-pentaho-debug.
- B. start-pentaho.sh
- C. import-export.sh
- D. stop-pentaho.sh
Answer: A,B
NEW QUESTION 31
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. Every input row must have only one matching row in the lookup table
- C. Cached comparisons are case sensitive.
- D. Only one matching row is used from the Lookup table.
- E. There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.
Answer: A,C,E
NEW QUESTION 32
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 transformation's properties.
- C. Modify the Tomcat startup bat or startup.sh script
- D. Modify the Pentaho server's tog4j.xml.
Answer: B
NEW QUESTION 33
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 JVM memory parameters appropriatelyin the User Denned tab ofthe PMR step
- B. Set the Enable blocking option in the PMR step.
- C. Edit me Pentahoserver startup script to increase the memory setting
- D. Increase the Number of mapper tacks in the PMR step.
Answer: C
NEW QUESTION 34
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 'Maximum number of snapshots in memory option in the Monitoring tab
- C. the 'KETTLE_MAX_JOB_TRACKER_SIZE' option in kettle properties.
- D. The 'Limit' option in the Snapshot tab
Answer: B
NEW QUESTION 35
You are running a PDI Job and 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. Do not define any evaluation hop out of the Job entry that are going to verify.
- B. Define the false evaluation hop out of the job entry that you 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: A
NEW QUESTION 36
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?
- A. Use the Transformation Executor step for each file.
- B. Use the ETL Metadata injection step
- C. Use the Job Executor step for each file.
- D. Use the Metadata structure of stream step for each file.
Answer: B
NEW QUESTION 37
Which PDI step or entry processes data within the Hadoop cluster?
- A. the Hadoop File Output step
- B. the Pentaho MapReduce entry
- C. the Hadoop Fie Input step
- D. the Hadoop Copy files entry
Answer: C
NEW QUESTION 38
Which statement is true for a transformation?
- A. A transformation step processes one row at a time.
- B. Atransformation must have a start step.
- C. Transformation steps are executed in parallel.
- D. A transformation step can have only one incoming hop and one outgoing hop.
Answer: B
NEW QUESTION 39
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?
- A. pentaho-service/data
- B. solutions/system/karaf/system/org/apache/karaf/logpentaho/server/pentaho-solution/system/karaf/System/commons logging
- C. pentaho-server/tomcat/logs
- D. pentaho-server/pentaho
Answer: A
NEW QUESTION 40
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 41
Which script will execute jobs stored in a Pentaho server from a command line?
- A. spoon
- B. carle
- C. kitchen
- D. pan
Answer: D
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command_Line_Tools
NEW QUESTION 42
......
HCE-5920 Exam Dumps Pass with Updated 2022: https://www.guidetorrent.com/HCE-5920-pdf-free-download.html