Pentaho Beginner Quiz
1) GUI Provided by Pentaho to design Transformation and Jobs that can be run with Kettle Tools is
- Pan
- Kitchen
- Spoon
- No GUI provided
2) Tool which performs reading, manipulating and writing various data sources is called
- Spoon
- Kitchen
- Kettle
- Pan
3) The program that execute jobs that are designed in Pentaho Data Integration Tools is
- Kettle
- Kitchen
- ETTL
- Pan
4) Group by step works if input is not sorted.
- FALSE
- TRUE
5) Step used for implementation of SCD Type I and Type II implementaion is
- Dimension Lookup/update
- Dimension
- Lookup
- None of the above
6) Which step can be used to slow down the transformation?
- No such step
- Slow Row
- Delay
- Delay Row
7) How to use a variable inside the transformation entries? Select all that apply
- %%VARIABLE%%
- ${VARIABLE}
- $VARIABLE
- A & B
8) What is PAN
- a program that can execute transformations designed in Spoon in XML
- a program that can execute jobs designed in Spoon in XML
- a program that can execute transformations and jobs designed in Spoon in XML
- None of the above
9) fill in the blanks:____________is A graphical representation of one or more data streams between two steps
- Hop
- Row
- Input stream
- None of the above
10) fill in the blanks:_________________is a graphical user interface that allows you to design transformations and jobs t
- Spoon
- PAN
- Kitchen
- KETTLE
11) What is the extension for saving the transformations
- ktr
- kjb
12) What is the extension for saving the jobs
- ktr
- kjb
13) Which step is used for converting columns into rows
- Row normalizer
- Row denormalizer
- Row flattener
14) Which step is used for converting rows into columns
- Row normalizer
- Row denormalizer
- Row flattener
15) What is KITCHEN ?
- a program that can execute transformations designed in Spoon in XML
- a program that can execute jobs designed in Spoon in XML
- a program that can execute transformations and jobs designed in Spoon in XML
- None of the above
16) Which command is used to run a job in windows platform
- sh
- bat
- sh
- bat
17) Which command is used to run a transformation in windows platform
- sh
- bat
- sh
- bat
18) Which command is used to run a transformation in unix platform
- sh
- bat
- sh
- bat
19) Which command is used to run a job in unix platform
- sh
- bat
- sh
- bat
20) pan.bat /rep:”Production Repository”
/trans:”update Customer Dimension”
/dir:/Dimensions/
/user:matt
/pass:somepassword123
/level:Basic the above command is an example of running kettle transform
- File
- Repository
21) pan.bat /file:”D:\Transformations\Customer Dimension.ktr” /level:Basic the above command is an example of running kettle transformation from?
- File
- Repository
22) Select values step is useful for ?
- selecting fields
- removing fields
- changing data types
- All of the above
23) Java source code is compiled into __________
- source code
- .Exe
- .Obj
- Bytecode
24) Which of the following tool used to execute java code
- Java
- Javadoc
- javac
- rmic
25) Java programming promises progmmer “Write once, Run Any where ”
- TRUE
- FALSE
26) Which of the following is smallest integer data types ?
- Long
- int
- byte
- short
27) Charater data type cannot store the following values
- Letter
- Special Character
- String
- Digit
28) what is Literal in java programming ?
- Special type of data type
- Source code representation of a fixed value
- Special type of class
- Non of them
29) Platform independent code file created from source file is understandable by ________
- Compiler
- Applet
- JRE
- JVM
30) JVM is a_________
- Assembler
- Debugger
- Interpreter
- Compiler
31) Bytecode is given as input to _________
- JRE
- Assembler
- Linker
- JVM
32) while using sort in a partition is it necessary to use sort merge?
- Yes
- No
33) you can call one transformation in multiple jobs?
- TRUE
- FALSE
34) What is the return code of a shell script/batch file for success
- 1
- 0
35) 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)
36) 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)
37) In Spoon, a running transformation will also highlight the step icon’s border for any steps that may be considered bottlenecks.
- TRUE
- FALSE
38) whch step can be used to duplicate/copy a field in a transformation
- Java script
- Calculator
- Select Values
- All of the above
39) The Call DB PRocedure needs to be triggered explicitly in PDI?
- TRUE
- FALSE
40) Which format should be selected in table output step to get the result in the below format?100.23
- #,##0.###
- #.00
- #.#
- #####.###%
41) Can we use Microsoft excel as an output in PDI?
- Yes
- No
42) Can we run a transformation inside another transformation
- Yes
- no
43) Can we run a job inside a transformation
- Yes
- no
44) The Join Components in pentaho does not support flat file.
- TRUE
- FALSE
45) Can we generate alpha-numeric value using sequence generator in Pentaho ?
- Yes
- No
46) Which of the below Components is used to reuse the mapping Specified in someother file ??
- Mapping Input Specification
- Mapping Output Specification
- Mapping (sub-transformation)
- Simple Mapping
47) Can the steps in a transformation be sequentialised?
- yes
- no
48) By default Null and “” are the same in PDI
- TRUE
- FALSE
49) IN PDI every row which is sent over a single hop needs to be of the same structure
- TRUE
- FALSE
50) which step can be used to get system date and arguments?
- Get system info
- get varibles
- Get files from result
- get repository names
51) Are loops allowed in a transformation
- Yes
- No
52) Are loops allowed in a job
- Yes
- No
53) 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
54) What is Uniform Data Access Integration?
- UDAI places the data in the source systems.
- A set of views are defined for providing access the unified view to the clients / customers.
- Zero latency of data can be propagated from the source system.
- All of the above
55) What is the use of Select values Step?
- Select and Alter — Specify the exact order and name in which the fields have to be placed in the output rows
- Remove — Specify the fields that have to be removed from the output rows
- Meta-data – Change the name, type, length and precision (the metadata) of one or more fields
- All of the Above.
56) What is the Default Insert method used by Table Output Step in Pentaho?
- Batch Insert
- Bulk Insert.
- Single Row Insert.
- None of the above.
57) What are the Types of Joins that can be Specified in Merge Join Step.
- Only INNER
- Only LEFT OUTER and RIGHT OUTER
- INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER
- Only FULL OUTER
58) Oracle Bulk Loader Step will use which of the following Insert Techniques..
- Batch Insert
- SQL Loader
- Interval based Inserts.
- None of the above
59) How is a Pentaho Variable Defined for a Unix Environment.
- %%VariableName%%
- ${VariableName}
- %%VariableName$$
- None of the above.
60) What is PAN
- a program that can execute transformations designed in Spoon in XML
- a program that can execute jobs designed in Spoon in XML
- a program that can execute transformations and jobs designed in Spoon in XML
- None of the above