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.
Question 1 of 20 · Page 1 / 2