The New HCE-5920 2022 Updated Verified Study Guides & Best Courses
Authentic HCE-5920 Exam Dumps PDF - 2022 Updated
Hitachi HCE-5920 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
NEW QUESTION 30
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?
- A. Use the "Mapping (sub-transformation)' step containing the series of steps.
- B. Use the "Get data from XML' step to read the series of steps
- C. Use the ETL Metadata Infection' stop containing the series of steps.
- D. Use the 'Job Executor1 step containing the series of steps
Answer: C
NEW QUESTION 31
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. import-export.sh
- C. start-pentaho.sh
- D. stop-pentaho.sh
Answer: A,C
NEW QUESTION 32
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. Change the reference in the Table input step to '?'
- C. Add a Set Variable step before the Table input step in the transformation.
- D. Add a transformation entry in the job that uses theGet Variables step.
Answer: C
NEW QUESTION 33
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. Run the Spark application butter tool to obtain the AEL daemon zip file.
- B. Run the AEL Oozie job to install the AEL daemon.
- C. Configure the AEL daemon in Local Mode.
- D. Configure the AEL daemon in YARN Mode
Answer: C,D
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Set_up_the_Adaptive_Execution_Layer_(AEL
NEW QUESTION 34
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. Set the connection details in the Kettle properties file.
- B. Create a properties file that includes the connection details and use the Set Variables step to load these properties.
- C. Use Manage Data Source to create a new connection in Spoon.
- D. Use the Data Source Wizard to generate the connection details.
Answer: A,D
NEW QUESTION 35
What are Job checkpoints?
- A. Points in a job that sends a heartbeat request to the Pentaho server to ensure connectivity.
- B. Error handing hops that manage e-mail notifications.
- C. Points in a job that have finished successfully and are automatically skipped after a previously failed run
- D. Points in a job that log the step metrics during certain intervals
Answer: D
NEW QUESTION 36
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. Get rows from result
- D. Kafka Consumer
Answer: C
NEW QUESTION 37
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. Reduce the value in the Nr' of rows in rowset' option on the Miscellaneous tab in the Transformation properties.
- B. Select the 'Execute for every input row? Option on the Advanced tab of the Transformation properties from the parent job.
- C. Right click on the slow-running steps and select the Load Balance option from the Data Movement submenu.
- D. Select the 'Enable step performance monitoring?' option on the Monitoring tab in the Transformation properties.
Answer: A
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?
- A. solutions/system/karaf/system/org/apache/karaf/logpentaho/server/pentaho-solution/system/karaf/System/commons logging
- B. pentaho-server/tomcat/logs
- C. pentaho-service/data
- D. pentaho-server/pentaho
Answer: C
NEW QUESTION 39
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. Oracle
- B. Sybase
- C. DB2
- D. Microsoft SQL Server
Answer: A,D
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.3/Setup/Use_PostgreSQL_as_your_repository_databas
NEW QUESTION 40
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-XYZABC123
- B. DB_PASSWORD-Encrypted XY2ABC123
- C. DB_PASSWORD=Encfypted("XYZABC 123*)
- D. DB_PASSWORD=StringrXYZABC123")
Answer: C
NEW QUESTION 41
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 Merge Join step
- B. the Sorted Merge step
- C. the Append Streams step
- D. the Dummy step
Answer: A
NEW QUESTION 42
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 Madoop Fie Input step
- B. the MapReduce Input step
- C. the Hadoop File Output step
- D. the MapReduce Output step
Answer: A,B
NEW QUESTION 43
Which script will execute jobs stored in a Pentaho server from a command line?
- A. pan
- B. spoon
- C. kitchen
- D. carle
Answer: A
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command_Line_Tools
NEW QUESTION 44
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 4.
- B. Set it to 1.
- C. Set it to 0.
- D. Set it to blank.
Answer: D
NEW QUESTION 45
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 transformation's properties.
- B. Modify the Pentaho server's tog4j.xml.
- C. Modify the start-pentaho bat or start-pentaho.sh script
- D. Modify the Tomcat startup bat or startup.sh script
Answer: A
NEW QUESTION 46
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 JNDI to specify the SQL statements.
- D. Use the Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.
Answer: D
NEW QUESTION 47
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 48
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 a '$' sign next to it.
- C. any free form text field with a '@' sign next to it.
- D. Any free form text field with the variable name entered in all caps
Answer: C
NEW QUESTION 49
Which two statements are correct about the Repository Explorer? (Choose two.) Choose 2 answers
- A. You can upload JDBC drivers when defining JOBC connections.
- B. You can create new jobs and transformations.
- C. You can move. rename, and delete jobs and transformations.
- D. You can lock and unlockjobs and transformations.
Answer: C,D
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/7.0/0L0/0Y0/040/010
NEW QUESTION 50
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('XYZABC 123')
- B. DB_PASSWORD=XYZABC123
- C. DB_PASSWORD=Encrypted XYZABC123
- D. DB_PASSWORD=String('XYZABC123')
Answer: A
NEW QUESTION 51
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 a different structure and have the same target table.
- B. When the files have the same structure and have different target tables.
- 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: A,C
NEW QUESTION 52
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 'KETTLE_MAX_JOB_TRACKER_SIZE' option in kettle properties.
- B. The 'Limit' option in the Snapshot tab
- C. the Logging interval(seconds)' option in the Performance section
- D. The 'Maximum number of snapshots in memory option in the Monitoring tab
Answer: D
NEW QUESTION 53
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. Use the encr script.
- B. Use the pan script
- C. Use the import-export script.
- D. Using Spoon Tools > Repository > import Repository
Answer: C,D
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/6.0/0P0/0U0/040
NEW QUESTION 54
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. Define the unconditional evaluation hop out of the job entry that you are going to verify.
- B. Define the true evaluation hop out of the job entry that you are going to verify.
- C. Definethe false evaluation hop out of the job entry that you are going to verify.
- D. Do not define any evaluation hop out of the Job entry that are going to verify.
Answer: D
NEW QUESTION 55
......
Get Prepared for Your HCE-5920 Exam With Actual 61 Questions: https://www.real4dumps.com/HCE-5920_examcollection.html
