Pentaho Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
2) Tool which performs reading, manipulating and writing various data sources is called

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
3) The program that execute jobs that are designed in Pentaho Data Integration Tools is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
4) Group by step works if input is not sorted.

  1. FALSE
  2. TRUE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
6) Which step can be used to slow down the transformation?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
7) How to use a variable inside the transformation entries? Select all that apply

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
11) What is the extension for saving the transformations

  1. ktr
  2. kjb

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
12) What is the extension for saving the jobs

  1. ktr
  2. kjb

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
13) Which step is used for converting columns into rows

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
14) Which step is used for converting rows into columns

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
16) Which command is used to run a job in windows platform

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
17) Which command is used to run a transformation in windows platform

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
18) Which command is used to run a transformation in unix platform

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
19) Which command is used to run a job in unix platform

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
22) Select values step is useful for ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
23) Java source code is compiled into __________

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
24) Which of the following tool used to execute java code

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
25) Java programming promises progmmer “Write once, Run Any where ”

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
26) Which of the following is smallest integer data types ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
27) Charater data type cannot store the following values

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
29) Platform independent code file created from source file is understandable by ________

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
30) JVM is a_________

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
31) Bytecode is given as input to _________

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



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

  1. Yes
  2. No

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
33) you can call one transformation in multiple jobs?

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
34) What is the return code of a shell script/batch file for success

  1. 1
  2. 0

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
39) The Call DB PRocedure needs to be triggered explicitly in PDI?

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
41) Can we use Microsoft excel as an output in PDI?

  1. Yes
  2. No

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
42) Can we run a transformation inside another transformation

  1. Yes
  2. no

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
43) Can we run a job inside a  transformation

  1. Yes
  2. no

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
44) The Join Components in pentaho does not support flat file.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
45) Can we generate alpha-numeric value using sequence generator in Pentaho ?

  1. Yes
  2. No

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
47) Can the steps in a transformation be sequentialised?

  1. yes
  2. no

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
48) By default Null and “” are the same in PDI

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
49) IN PDI every row which is sent over a single hop needs to be of the same structure

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
51) Are loops allowed in a transformation

  1. Yes
  2. No

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
52) Are loops allowed in a job

  1. Yes
  2. No

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
59) How is a Pentaho Variable Defined for a Unix Environment.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz