Free HCE-5920 Practice Test Questions and Answers (2026)
Q: 1
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
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 2
You need to perform a union of two data flows in a PDI transformation. You plan on having one step
receive the two hops from the different flows.
Which two statements are true in this scenario? (Choose two.)
Choose 2 answers
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 3
You need to design a PDI job that will execute a transformation and then send an e-mail with an
attached log of the transformation’s execution.
Which two sets of actions will accomplish this task? (Choose two.)
Choose 2 answers
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 4
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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 5
A customer has an archive-based installation. 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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 6
You have a string field in your dataset where you need to extract characters 1-5 only.
Which two steps will accomplish this task? (Choose two.)
Choose 2 answers
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 7
You are implementing a Pentaho server repository for a customer.
The customer will be using the Pentaho Scheduler.
Which repository supports this requirement?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 8
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 should you call from the script? (Choose two.)
Choose 2 answers
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 9
You execute a transformation locally in Spoon to read data from an Oracle database and you receive
the Drive not found’ exception.
What are two ways to solve this problem? (Choose two.)
Choose 2 answers
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 10
In a PDI transformation you are retrieving data from a large lookup table using a Database Lookup
step from improve 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.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 11
You need to download files from a web site as part of a PDI job.
Which job entry will accomplish this task?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 12
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 steps for installing AEL? (Choose two.)
Choose 2 answers
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 13
Which two statements are correct about the Repository Explorer? (Choose two.)
Choose 2 answers
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 14
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
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Q: 15
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?
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Question 1 of 20