Pentaho Beginner Quiz

1) GUI Provided by Pentaho to design Transformation and Jobs that can be run with Kettle Tools is

1. Pan
2. Kitchen
3. Spoon
4. No GUI provided

Show Answer

 
 
2) Tool which performs reading, manipulating and writing various data sources is called

1. Spoon
2. Kitchen
3. Kettle
4. Pan

Show Answer

 
 
3) The program that execute jobs that are designed in Pentaho Data Integration Tools is

1. Kettle
2. Kitchen
3. ETTL
4. Pan

Show Answer

 
 
4) Group by step works if input is not sorted.

1. FALSE
2. TRUE

Show Answer

 
 
5) Step used for implementation of SCD Type I and Type II implementaion is

1. Dimension Lookup/update
2. Dimension
3. Lookup
4. None of the above

Show Answer

 
 
6) Which step can be used to slow down the transformation?

1. No such step
2. Slow Row
3. Delay
4. Delay Row

Show Answer

 
 
7) How to use a variable inside the transformation entries? Select all that apply

1. %%VARIABLE%%
2. ${VARIABLE}
3. $VARIABLE
4. A & B

Show Answer

 
 
8) What is PAN

1. a program that can execute transformations designed in Spoon in XML
2. a program that can execute jobs designed in Spoon in XML
3. a program that can execute transformations and jobs designed in Spoon in XML
4. None of the above

Show Answer

 
 
9) fill in the blanks:____________is A graphical representation of one or more data streams between two steps

1. Hop
2. Row
3. Input stream
4. None of the above

Show Answer

 
 
10) fill in the blanks:_________________is a graphical user interface that allows you to design transformations and jobs t

1. Spoon
2. PAN
3. Kitchen
4. KETTLE

Show Answer

 
11) What is the extension for saving the transformations

1. ktr
2. kjb

Show Answer

 
 
12) What is the extension for saving the jobs

1. ktr
2. kjb

Show Answer

 
 
13) Which step is used for converting columns into rows

1. Row normalizer
2. Row denormalizer
3. Row flattener

Show Answer

 
 
14) Which step is used for converting rows into columns

1. Row normalizer
2. Row denormalizer
3. Row flattener

Show Answer

 
 
15) What is KITCHEN ?

1. a program that can execute transformations designed in Spoon in XML
2. a program that can execute jobs designed in Spoon in XML
3. a program that can execute transformations and jobs designed in Spoon in XML
4. None of the above

Show Answer

 
 
16) Which command is used to run a job in windows platform

1. sh
2. bat
3. sh
4. bat

Show Answer

 
 
17) Which command is used to run a transformation in windows platform

1. sh
2. bat
3. sh
4. bat

Show Answer

 
 
18) Which command is used to run a transformation in unix platform

1. sh
2. bat
3. sh
4. bat

Show Answer

 
 
19) Which command is used to run a job in unix platform

1. sh
2. bat
3. sh
4. bat

Show Answer

 
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

1. File
2. Repository

Show Answer

 
 
21) pan.bat /file:”D:\Transformations\Customer Dimension.ktr” /level:Basic the above command is an example of running kettle transformation from?

1. File
2. Repository

Show Answer

 
 
22) Select values step is useful for ?

1. selecting fields
2. removing fields
3. changing data types
4. All of the above

Show Answer

 
 
23) Java source code is compiled into __________

1. source code
2. .Exe
3. .Obj
4. Bytecode

Show Answer

 
 
24) Which of the following tool used to execute java code

1. Java
2. Javadoc
3. javac
4. rmic

Show Answer

 
 
25) Java programming promises progmmer “Write once, Run Any where ”

1. TRUE
2. FALSE

Show Answer

 
 
26) Which of the following is smallest integer data types ?

1. Long
2. int
3. byte
4. short

Show Answer

 
 
27) Charater data type cannot store the following values

1. Letter
2. Special Character
3. String
4. Digit

Show Answer

 
 
28) what is Literal in java programming ?

1. Special type of data type
2. Source code representation of a fixed value
3. Special type of class
4. Non of them

Show Answer

 
 
29) Platform independent code file created from source file is understandable by ________

1. Compiler
2. Applet
3. JRE
4. JVM

Show Answer

 
 
30) JVM is a_________

1. Assembler
2. Debugger
3. Interpreter
4. Compiler

Show Answer

 
 
31) Bytecode is given as input to _________

1. JRE
2. Assembler
3. Linker
4. JVM

Show Answer

 
32) while using sort in a partition is it necessary to use sort merge?

1. Yes
2. No

Show Answer

 
 
33) you can call one transformation in multiple jobs?

1. TRUE
2. FALSE

Show Answer

 
 
34) What is the return code of a shell script/batch file for success

1. 1
2. 0

Show Answer

 
 
35) whcich statement is true abt arguments

1. Arguments are command line arguments that you would normally specify during batch processing (via Pan)
2. Arguments are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
3. Variables are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
4. Variables are command line arguments that you would normally specify during batch processing (via Pan)

Show Answer

 
 
36) whcich statement is true abt Variables

1. Arguments are command line arguments that you would normally specify during batch processing (via Pan)
2. Arguments are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
3. Variables are environment or PDI variables that you would normally set in a previous transformation in a job or in the Operating System.
4. Variables are command line arguments that you would normally specify during batch processing (via Pan)

Show Answer

 
 
37) In Spoon, a running transformation will also highlight the step icon’s border for any steps that may be considered bottlenecks.

1. TRUE
2. FALSE

Show Answer

 
 
38) whch step can be used to duplicate/copy a field in a transformation

1. Java script
2. Calculator
3. Select Values
4. All of the above

Show Answer

 
 
39) The Call DB PRocedure needs to be triggered explicitly in PDI?

1. TRUE
2. FALSE

Show Answer

 
40) Which format should be selected in table output step to get the result in the below format?100.23

1. #,##0.###
2. #.00
3. #.#
4. #####.###%

Show Answer

 
 
41) Can we use Microsoft excel as an output in PDI?

1. Yes
2. No

Show Answer

 
 
42) Can we run a transformation inside another transformation

1. Yes
2. no

Show Answer

 
 
43) Can we run a job inside a  transformation

1. Yes
2. no

Show Answer

 
 
44) The Join Components in pentaho does not support flat file.

1. TRUE
2. FALSE

Show Answer

 
 
45) Can we generate alpha-numeric value using sequence generator in Pentaho ?

1. Yes
2. No

Show Answer

 
 
46) Which of the below Components is used to  reuse the mapping Specified in someother file ??

1. Mapping Input Specification
2. Mapping Output Specification
3. Mapping (sub-transformation)
4. Simple Mapping

Show Answer

 
 
47) Can the steps in a transformation be sequentialised?

1. yes
2. no

Show Answer

 
 
48) By default Null and “” are the same in PDI

1. TRUE
2. FALSE

Show Answer

 
 
49) IN PDI every row which is sent over a single hop needs to be of the same structure

1. TRUE
2. FALSE

Show Answer

 
 
50) which step can be used to get system date and arguments?

1. Get system info
2. get varibles
3. Get files from result
4. get repository names

Show Answer

 
51) Are loops allowed in a transformation

1. Yes
2. No

Show Answer

 
 
52) Are loops allowed in a job

1. Yes
2. No

Show Answer

 
 
53) To cache all the rows in a databas lookup step “Cache size in rows” should be set to?

1. 0
2. 1
3. Null
4. None of the above

Show Answer

 
 
54) What is Uniform Data Access Integration?

1. UDAI places the data in the source systems.
2. A set of views are defined for providing access the unified view to the clients / customers.
3. Zero latency of data can be propagated from the source system.
4. All of the above

Show Answer

 
 
55) What is the use of Select values Step?

1. Select and Alter — Specify the exact order and name in which the fields have to be placed in the output rows
2. Remove — Specify the fields that have to be removed from the output rows
3. Meta-data – Change the name, type, length and precision (the metadata) of one or more fields
4. All of the Above.

Show Answer

 
 
56) What is the Default Insert method used by Table Output Step in Pentaho?

1. Batch Insert
2. Bulk Insert.
3. Single Row Insert.
4. None of the above.

Show Answer

 
 
57) What are the Types of Joins that can be Specified in Merge Join Step.

1. Only INNER
2. Only LEFT OUTER and RIGHT OUTER
3. INNER , LEFT OUTER , RIGHT OUTER , FULL OUTER
4. Only FULL OUTER

Show Answer

 
 
58) Oracle Bulk Loader Step will use which of the following Insert Techniques..

1. Batch Insert
2. SQL Loader
3. Interval based Inserts.
4. None of the above

Show Answer

 
 
59) How is a Pentaho Variable Defined for a Unix Environment.

1. %%VariableName%%
2. ${VariableName}
3. %%VariableName$$
4. None of the above.

Show Answer

 
 
60) What is PAN

1. a program that can execute transformations designed in Spoon in XML
2. a program that can execute jobs designed in Spoon in XML
3. a program that can execute transformations and jobs designed in Spoon in XML
4. None of the above

Show Answer