Pentaho Intermediate Quiz
1) How to execute job from command line?
- “file=-filename”
- “-file=<filename>”
- “file=-filename”
- None of the above
2) Which Step can be used to get the properties of a file?
- Get File Names
- Get File Rows
- Get File Id
- None of the above
3) Result of the exceuted procedure is stored in
- Result Name
- Result
- Output
- Non of the above
4) Step used to get union of two data sets from two streams is
- Append Streams
- Union
- Append
- Union Streams
5) If Cache size in rows is set to zero in Database lookup step then that means
- Cache Nothing
- Cache only first row
- Cache Everything
- Cache Last row
6) which of the following statements are true? Select all that apply
- All steps in a transformation run in parallel
- All steps in a job run in parallel
- all steps in a transformation run in sequence
- All steps in a job run in parallel & steps in a job execute in order
7) fill in the blanks:____________type of logging gives a very detailed output
- Detailed
- Debug
- Row level
- Nothing
8) How do you do a database join with PDI?
- Table Input
- Database Join
- Merge Join
- All of the above
9) which step is used to Execute SQL script extracted from a field created in a previous step.
- Execute row SQL script
- Execute SQL script
- SQL
- Analytic Query
10) Memory group by step doesn’t require sorted input
- TRUE
- FALSE
11) Which step is used for merging two streams and flagging the rows for insert ,update ,delete and new
- Merge Join
- Merge Rows (diff)
- Join Rows (cartesian product)
- Database Join
12) there are 3 typrs of repositories to save kettle jobs and transformations
- TRUE
- FALSE
13) Choose the types of repositories that can be used to save kettle jobs and transformations
- File Repository
- Database Repository
- Enterprise Repository
- All of the above
14) Whch of the following steps acts like a SQL case statement in PDI
- Filter
- Switch/case
- Java filter
15) Stream lookup can be used to lookup data in which of the following sources
- File
- Database
- Both
16) Sort rows step can be used to remove duplicate data ?
- TRUE
- FALSE
17) How to determine the slowest step in a transformation
- A slow step will have consistently large input buffer sizes
- A slow step will consistently have low input buffer sizes
18) How to determine the fastest step in a transformation
- A fast step will have consistently large input buffer sizes
- A fast step will consistently have low input buffer sizes
19) Which of the following statements are true (Select all of them)
- Arguments are command line arguments that you would normally specify during batch processing (via Pan)
- Arguments are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
- Variables are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
- A & B
20) The Simple-JNDI layer does not create true JNDI connections, so the behavior of connections in Spoon may differ slightly compared to an Application Server running the same PDI job or transformation.
- TRUE
- FALSE
21) What is the syntax to pass an argument to the table input step from the previous step.
- SELECT VID FROM CO_VEHICLES WHERE PONO = ${input_param};
- SELECT VID FROM CO_VEHICLES WHERE PONO = ?;
22) What is the syntax to pass an variable to the table input step
- SELECT VID FROM CO_VEHICLES WHERE PONO = ${input_param};
- SELECT VID FROM CO_VEHICLES WHERE PONO = ?;
23) SELECT VID FROM CO_VEHICLES_${NUMBER};What PDI does for these query (if you enable “variable replacement” in the table input step)
- Replace the variables in the SQL statements;
- Bind the parameters per execution;
- Both
24) Can the steps in a transformation be sequentialised?
- yes
- no
25) By default Null and “” are the same in PDI
- TRUE
- FALSE
26) IN PDI every row which is sent over a single hop needs to be of the same structure
- TRUE
- FALSE
27) which step can be used to get system date and arguments?
- Get system info
- get varibles
- Get files from result
- get repository names
28) Are loops allowed in a transformation
- Yes
- No
29) Are loops allowed in a job
- Yes
- No
30) To cache all the rows in a databas lookup step “Cache size in rows” should be set to?
- 0
- 1
- Null
- None of the above
31) Lookups Steps is used to look up data in
- flat file
- Relational table
- view
- All of the above
32) What are the types of joins that Joiner Components supports ?
- Full Outer
- Inner
- Cross Join
- All of the above
33) Which of these are true statements to improve performance of joiners in Pentaho? Select all of them
- Do not user master outer join
- Use sorted input to decrease the use of
- Limit connected input/output Sources.
- B & C
34) Which is not a function of Pentaho Repository ?
- Check out and check in versioned objects
- Compare objects
- Track changes to an object
- Update a version
35) What folder are the kettle.properties and shared.xml files stored in
- .pentaho
- .kettle
- data-integration
- config
36) How can you set where the folder containing the kettle.properties and shared.xml is
- Environment variable – KETTLE_HOME
- Environment variable – PENTAHO_HOME
- It can’t be changed
- It is always located in the directory where the script is run from
37) What is stored in kettle.properties
- Default properties file for variables
- Default shared objects file
- The database cache for metadata
- The local repositories file
38) How do you access Parameters in a Transformation so that they can be used with the data records
- Use Get Variables to create variables populated with the Parameter’s value
- Parameters can be directly referenced by their name for each data record
- They aren’t used in the data record
- Parameters can only be used by the first step in the transformation
39) Are the JavaScript steps the same for Job and Transformation?
- Yes
- No
40) If there is a name collision between a parameter and a variable, what will take precedence
- Parameter
- Variable
- Job will throw an error
- None of the above
41) Execution order for Java Script in Modified Java Script Value step.
- Set Start Script
- Set End Script
- Set Transform Script
- 1,2,3
- 3,1,2
- 1,3,2
- 2,1,3
42) Text file input step have compression option in it.
- TRUE
- FALSE
43) Which of the below option is not available in Generate Random Value
- Random Integer
- Random Number
- Random String
- Random Character
44) Which Output type is not available in Automatic Documentation Output Step
- DOC
- XML
- XLS
45) while using sort in a partition is it necessary to use sort merge?
- Yes
- No
46) you can call one transformation in multiple jobs?
- TRUE
- FALSE
47) What is the return code of a shell script/batch file for success
- 1
- 0
48) whcich statement is true abt arguments
- Arguments are command line arguments that you would normally specify during batch processing (via Pan)
- Arguments are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
- Variables are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
- Variables are command line arguments that you would normally specify during batch processing (via Pan)
49) whcich statement is true abt Variables
- Arguments are command line arguments that you would normally specify during batch processing (via Pan)
- Arguments are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
- Variables are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
- Variables are command line arguments that you would normally specify during batch processing (via Pan)
50) In Spoon, a running transformation will also highlight the step icon’s border for any steps that may be considered bottlenecks.
- TRUE
- FALSE
51) whch step can be used to duplicate/copy a field in a transformation
- Java script
- Calculator
- Select Values
- All of the above
52) The Call DB PRocedure needs to be triggered explicitly in PDI?
- TRUE
- FALSE
53) Which format should be selected in table output step to get the result in the below format?100.23
- #,##0.###
- #.00
- #.#
- #####.###%
54) Can we use Microsoft excel as an output in PDI?
- Yes
- No
55) when using partition you would choose the most non repeating key as the partiton key?
- TRUE
- FALSE
56) which step can be used to insert booleans into a MySql database as PDI encodes a boolean as ‘Y’ or ‘N’ and this can’t be insert into a BIT(1) column in MySql.
- Select values
- Javascript
- Calculator
- Value Mapper
57) I made a transformation using 28/222 in a calculator step the 2 input fields are integer but my result type is Number(6, 4). What is the expected output
- 0
- 1261
- 12612612613
58) The HTTP client step needs to be triggered explicitly in PDI?
- TRUE
- FALSE
59) Does the HTTP client support SOAP?
- YES
- NO
60) How do you do a database join with PDI?
- Table Input
- Database Join
- Merge Join
- All of the above