Pentaho Quiz

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

Answer : C

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

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

Answer : D

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

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

Answer : B

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

  1. FALSE
  2. TRUE

Answer : A

 
 
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

Answer : A

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

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

Answer : D

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

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

Answer : D

 
 
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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : A




 
11) What is the extension for saving the transformations

  1. ktr
  2. kjb

Answer : A

 
 
12) What is the extension for saving the jobs

  1. ktr
  2. kjb

Answer : B

 
 
13) Which step is used for converting columns into rows

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

Answer : A

 
 
14) Which step is used for converting rows into columns

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

Answer : B

 
 
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

Answer : B

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

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

Answer : B

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

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

Answer : D

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

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

Answer : C

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

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

Answer : A




 
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

Answer : B

 
 
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

Answer : A

 
 
22) Select values step is useful for ?

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

Answer : D

 
 
23) Java source code is compiled into __________

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

Answer : D

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

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

Answer : A

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

  1. TRUE
  2. FALSE

Answer : A

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

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

Answer : C

 
 
27) Charater data type cannot store the following values

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

Answer : C

 
 
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

Answer : B

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

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

Answer : D

 
 
30) JVM is a_________

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

Answer : C

 
 
31) Bytecode is given as input to _________

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

Answer : D




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

  1. Yes
  2. No

Answer : A

 
 
33) you can call one transformation in multiple jobs?

  1. TRUE
  2. FALSE

Answer : A

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

  1. 1
  2. 0

Answer : B

 
 
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)

Answer : A

 
 
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)

Answer : B

 
 
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

Answer : A

 
 
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

Answer : D

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

  1. TRUE
  2. FALSE

Answer : A




 
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. #####.###%

Answer : B

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

  1. Yes
  2. No

Answer : A

 
 
42) Can we run a transformation inside another transformation

  1. Yes
  2. no

Answer : A

 
 
43) Can we run a job inside a  transformation

  1. Yes
  2. no

Answer : A

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

  1. TRUE
  2. FALSE

Answer : B

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

  1. Yes
  2. No

Answer : B

 
 
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

Answer : A

 
 
47) Can the steps in a transformation be sequentialised?

  1. yes
  2. no

Answer : B

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

  1. TRUE
  2. FALSE

Answer : A

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

  1. TRUE
  2. FALSE

Answer : A

 
 
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

Answer : A




 
51) Are loops allowed in a transformation

  1. Yes
  2. No

Answer : B

 
 
52) Are loops allowed in a job

  1. Yes
  2. No

Answer : A

 
 
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

Answer : A

 
 
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

Answer : D

 
 
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.

Answer : D

 
 
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.

Answer : A

 
 
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

Answer : C

 
 
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

Answer : B

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

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

Answer : B

 
 
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

Answer : A