Hitachi Vantara Certified Specialist Certified Official Practice Test HCE-5920 - Feb-2023
Ace Hitachi HCE-5920 Certification with Actual Questions Feb 08, 2023 Updated
NEW QUESTION 15
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 log the step metrics during certain intervals
- D. Points in a job that have finished successfully and are automatically skipped after a previously failed run
Answer: C
NEW QUESTION 16
After monitoring a performance bottleneck in transformation you identified a user Defined Java Expression step as the problem.
Choose 2 answers
- A. Replace the step with a Modified Java Script Value step
- B. Increase the Change Number of Copies to Start for tie stop
- C. Split the step into multiple consecutive steps
- D. Replace me step with a User Defined Java Class step
Answer: C,D
NEW QUESTION 17
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. Copy Files
- C. Get a files with FTP
- D. Sqoop import
Answer: A
NEW QUESTION 18
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 'Combination lookup/update' step
- B. the 'Select values' step
- C. the Dimension lookup/update' step
- D. the 'Filter rows' step
Answer: A,C
NEW QUESTION 19
What must be the first PDI step in a child transformation ingesting records from Kafka?
- A. Kafka Consumer
- B. Get data from Kafka
- C. Get rows from result
- D. Get records from stream
Answer: C
NEW QUESTION 20
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 Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.
- B. Use the Database Connection wizard and specify SQL statements.
- C. Use the Advanced section in the Database Connection window to enter the SQL statements.
- D. Use JNDI to specify the SQL statements.
Answer: A
NEW QUESTION 21
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 'Select values' step
- B. the Modified Java Script Value' step
- C. the 'Set Variables' step
- D. the 'Table inpuT step
Answer: B,C
NEW QUESTION 22
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 Spoon
- C. Pentaho Server
- D. Pentaho Report Designer
Answer: D
NEW QUESTION 23
You are preparing a server environment for an archive installation of a Pentaho server According to HitachiVantara best practices which environment variable should be set?
- A. SPOON HOME
- B. JAVA_HOME
- C. PENTAHO_JAVA_HOME
- D. KETTLEHOME
Answer: C
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 24
You are planning to connect to a secured Hadoop duster
from Pentaho.
Which two authentication methods are supported? (Choose two)
Choose 2 answers
- A. Trusted
- B. Keytan
- C. X.509 Certificate
- D. Password
Answer: A,B
NEW QUESTION 25
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 Hadoop File Output step
- B. the MapReduce Input step
- C. the MapReduce Output step
- D. the Madoop Fie Input step
Answer: B,D
NEW QUESTION 26
A customer's transformation Is running slowly in a lest environment.You have access to Spoon and you can run and monitor the job.
How do you troubleshoot this problem?
- A. Make sure the customer is using data partitioning to ensure parallel processing for faster execution
- B. Ensure there is enough memory on the Pentaho server and that there are no "Out Of Memory' errors in the log.
- C. Verify that there are no bottleneck slaps m the transformation by comparing the amount of rows in the input buffer versus the output buffer within the Step Metrics tab
- D. Execute the transformation via the pan script and pass the performance gathering parameter.
Answer: D
NEW QUESTION 27
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 the same target table.
- C. When the files have a different structure andhave different target tables.
- D. When the files have the same structure and have different target tables.
Answer: A,B
NEW QUESTION 28
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 'Maximum number of snapshots in memory option in the Monitoring tab
- C. the Logging interval(seconds)' option in the Performance section
- D. The 'Limit' option in the Snapshot tab
Answer: B
NEW QUESTION 29
When deploying your work lo the Pentaho server, which configuration Me should you review to ensure that the environment variable information is moved correctly?
- A. kettle.properties
- B. repositories.xml
- C. context.xml
- D. shared.xml
Answer: C
NEW QUESTION 30
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 'Select values' step
- B. the Modified Java Script Value' step
- C. the 'Set Variables' step
- D. the 'Table inpuT step
Answer: B,C
NEW QUESTION 31
A transformation is running in a production environment and you want to monitor it in real time.
Which tool should you use?
- A. Monitoring tab
- B. Log4j
- C. Kettle status page
- D. Pentaho Operations Mart
Answer: A
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 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 33
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 Job and Transformation steps to execute the jobs and transformations on the Pentaho server.
- B. Use the Kitchen and pan scripts 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: B
Explanation:
Explanation
https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command_Line_Tools
NEW QUESTION 34
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 '$' sign next to it.
- B. Any free form text field with a ''V'' 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 35
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 36
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 Run Configuration of the transformation
- B. Change theLogging options of the transformation
- C. Change the Arguments of the transformation
- D. Change the Parameters of the transformation
Answer: A
NEW QUESTION 37
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 XYZABC123
- C. DB_PASSWORD=String('XYZABC123')
- D. DB_PASSWORD=Encrypted('XYZABC 123')
Answer: D
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. pentaho-server/tomcat/logs
- B. pentaho-service/data
- C. pentaho-server/pentaho
- D. solutions/system/karaf/system/org/apache/karaf/logpentaho/server/pentaho-solution/system/karaf/System/commons logging
Answer: B
NEW QUESTION 39
You have instated the Pentaho server using an archive installation. You now want to change the server port.
Whichfile do you modify?
- A. slave-server-config.xml
- B. context.xml
- C. repositories.xml
- D. server.xml
Answer: D
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 40
......
Try Free and Start Using Realistic Verified HCE-5920 Dumps Instantly.: https://www.pass4sures.top/Hitachi-Vantara-Certified-Specialist/HCE-5920-testking-braindumps.html