Pentaho Quiz

Posted on: | By: – Comments Off

Pentaho Intermediate Quiz




1) How to execute job from command line?

  1. “file=-filename”
  2. “-file=<filename>”
  3. “file=-filename”
  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]
 
 
2) Which Step can be used to get the properties of a file?

  1. Get File Names
  2. Get File Rows
  3. Get File Id
  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]
 
 
3) Result of the exceuted procedure is stored in

  1. Result Name
  2. Result
  3. Output
  4. Non of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
4) Step used to get union of two data sets from two streams is

  1. Append Streams
  2. Union
  3. Append
  4. Union Streams

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
5) If Cache size in rows is set to zero in Database lookup step then that means

  1. Cache Nothing
  2. Cache only first row
  3. Cache Everything
  4. Cache Last row

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
6) which of the following statements are true? Select all that apply

  1. All steps in a transformation run in parallel
  2. All steps in a job run in parallel
  3. all steps in a transformation run in sequence
  4. All steps in a job run in parallel & steps in a job execute in order

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
7) fill in the blanks:____________type of logging gives a very detailed output

  1. Detailed
  2. Debug
  3. Row level
  4. Nothing

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
8) How do you do a database join with PDI?

  1. Table Input
  2. Database Join
  3. Merge Join
  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]
 
 
9) which step is used to Execute SQL script extracted from a field created in a previous step.

  1. Execute row SQL script
  2. Execute SQL script
  3. SQL
  4. Analytic Query

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
10) Memory group by step doesn’t require sorted input

  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]



 
11) Which step is used for merging two streams and flagging the rows for insert ,update ,delete and new

  1. Merge Join
  2. Merge Rows (diff)
  3. Join Rows (cartesian product)
  4. Database Join

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
12) there are 3 typrs of repositories to save kettle jobs and transformations

  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]
 
 
13) Choose the types of repositories that can be used to save kettle jobs and transformations

  1. File Repository
  2. Database Repository
  3. Enterprise Repository
  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]
 
 
14) Whch of the following steps acts like a SQL case statement in PDI

  1. Filter
  2. Switch/case
  3. Java filter

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
15) Stream lookup can be used to lookup data in which of the following sources

  1. File
  2. Database
  3. Both

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
16) Sort rows step can be used to remove duplicate data ?

  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]
 
 
17) How to determine the slowest step in a transformation

  1. A slow step will have consistently large input buffer sizes
  2. A slow step will consistently have low input buffer sizes

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
18) How to determine the fastest step in a transformation

  1. A fast step will have consistently large input buffer sizes
  2. A fast step will consistently have low input buffer sizes

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
19) Which of the following statements are true (Select all of them)

  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. A & B

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

  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]



 
21) What is the syntax to pass an argument to the table input step from the previous step.

  1. SELECT VID FROM CO_VEHICLES WHERE PONO = ${input_param};
  2. SELECT VID FROM CO_VEHICLES WHERE PONO = ?;

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
22) What is the syntax to pass an variable to the table input step

  1. SELECT VID FROM CO_VEHICLES WHERE PONO = ${input_param};
  2. SELECT VID FROM CO_VEHICLES WHERE PONO = ?;

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
23) SELECT VID FROM CO_VEHICLES_${NUMBER};What PDI does for these query (if you enable “variable replacement” in the table input step)

  1. Replace the variables in the SQL statements;
  2. Bind the parameters per execution;
  3. Both

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
24) 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]
 
 
25) 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]
 
 
26) 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]
 
 
27) 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]
 
 
28) 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]
 
 
29) 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]
 
 
30) 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]



 
31) Lookups Steps is used to look up data in

  1. flat file
  2. Relational table
  3. view
  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]
 
 
32) What are the types of joins  that  Joiner Components supports ?

  1. Full Outer
  2. Inner
  3. Cross Join
  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]
 
 
33) Which of these are true statements to improve  performance of joiners in Pentaho? Select all of them

  1. Do not user master outer join
  2. Use sorted input to decrease the use of
  3. Limit connected input/output Sources.
  4. B & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
34) Which is not a function of Pentaho Repository ?

  1. Check out and check in versioned objects
  2. Compare objects
  3. Track changes to an object
  4. Update a version

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
35) What folder are the kettle.properties and shared.xml files stored in

  1. .pentaho
  2. .kettle
  3. data-integration
  4. config

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
36) How can you set where the folder containing the kettle.properties and shared.xml is

  1. Environment variable – KETTLE_HOME
  2. Environment variable – PENTAHO_HOME
  3. It can’t be changed
  4. It is always located in the directory where the script is run from

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
37) What is stored in kettle.properties

  1. Default properties file for variables
  2. Default shared objects file
  3. The database cache for metadata
  4. The local repositories file

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
38) How do you access Parameters in a Transformation so that they can be used with the data records

  1. Use Get Variables to create variables populated with the Parameter’s value
  2. Parameters can be directly referenced by their name for each data record
  3. They aren’t used in the data record
  4. Parameters can only be used by the first step in the transformation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
39) Are the JavaScript steps the same for Job and 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]
 
 
40) If there is a name collision between a parameter and a variable, what will take precedence

  1. Parameter
  2. Variable
  3. Job will throw an error
  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]
 
 
41) Execution order for Java Script in Modified Java Script Value step.

  1. Set Start Script
  2. Set End Script
  3. Set Transform Script

 

  1. 1,2,3
  2. 3,1,2
  3. 1,3,2
  4. 2,1,3

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



 
42) Text file input step have compression option in it.

  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]
 
 
43) Which of the below option is not available in Generate Random Value

  1. Random Integer
  2. Random Number
  3. Random String
  4. Random Character

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
44) Which Output type is not available in Automatic Documentation Output Step

  1. PDF
  2. DOC
  3. XML
  4. XLS

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



 
51) 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]
 
 
52) 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]
 
 
53) 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]
 
 
54) 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]
 
 
55) when using partition you would choose the most non repeating key as the partiton key?

  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]
 
 
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.

  1. Select values
  2. Javascript
  3. Calculator
  4. Value Mapper

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

  1. 0
  2. 1261
  3. 12612612613

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
58) The HTTP client step 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]
 
 
59) Does the HTTP client support SOAP?

  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]
 
 
60) How do you do a database join with PDI?

  1. Table Input
  2. Database Join
  3. Merge Join
  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]



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz