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

Premium Access Includes

  • Quiz Simulator
  • Exam Mode
  • Progress Tracking
  • Question Saving
  • Flash Cards
  • Drag & Drops
  • 3 Months Access
  • PDF Downloads
Get Premium Access
Scroll to Top

FLASH OFFER

Days
Hours
Minutes
Seconds

avail 10% DISCOUNT on YOUR PURCHASE