Pentaho Expert Quiz

1) What are the execution options available for running a transformation

1. Local Execution
2. Execute remotely
3. Execute clustered
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]
 
 
2) ____________is a simple web server that allows you to execute transformations and jobs remotely

1. Carte
2. PAN
3. Kettle
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) Which step  is used to update a junk dimension

1. Dimension lookup/update
2. Combination lookup/update
3. Insert/update

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
4) Which of the below statements helps in improving the performance

1. indexes need to be enabled before running a session
2. Drop the constraints and indexes before running the session and rebuild them after completion of session
3. indexes should be dropped but constraints should be enabled before running a session
4. disable the constraints but enable the indexes before running a session

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
5) How can you minimize the cache for a joiner transformation?

1. Make the smaller source the master source
2. Make the smaller source the details source
3. Sort the master data prior to the joiner transformation
4. sort the detail data prior to the joiner transformation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
6) [(# of reads from disk) + (# of writes to disk)]/[(# of reads from memory cache) + (# of writes to memory cache)] is the formula for

1. hit ratio
2. miss ratio
3. a&b
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]
 
 
7) Which is not valid for optimizing system bottleneck?

1. Improve network speed
2. improve CPU performance
3. increase paging
4. check hard disks on related machines

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
8) What are the Xms and Xmx parameters when starting JVMs

1. The flag Xmx specifies the maximum memory allocation pool for a Java Virtual Machine (JVM), while Xms specifies the initial memory allocation pool.
2. The flag Xmx specifies the minimum memory allocation pool for a Java Virtual Machine (JVM), while Xms specifies the initial memory allocation pool.
3. The flag Xmx specifies the maximum memory allocation pool for a Java Virtual Machine (JVM), while Xms specifies the minimum memory allocation pool.
4. None of them

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



 
11) 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]
 
 
12) 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]
 
 
13) 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]
 
 
14) In PDI, most of the steps use optimization techniques which map column names into field numbers

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]
 
 
15) Whch stepcan be used to join heterogenous sources

1. Multiway merge join
2. Join rows
3. Database Join
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]
 
 
16) How many evaluation modes are there in a job hop?

1. 2
2. 3
3. 4
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]
 
 
17) What are the different kinds of job hops available in PDI. Select all that apply

1. Unconditional
2. Follow when result is true
3. Follow when result is false
4. All of them

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
18) In the database lookup step  “Do not pass the row if the lookup fails ” is enabled what is the resulting join

1. Inner join
2. Outer join
3. Left outer join
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]
 
 
19) What are the different access methods available to connect to database in PDI?Select all that apply

1. Native(JDBC)
2. JNDI
3. OCI
4. All of them

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
20) Which of the below are true for Enable Caching in Database Lookup?? Select all of them

1. Increased Cache size increases performance
2. Reduces the DB Calls and increases the performance
3. This means that the database is expected to return the same value all the time for a certain lookup value.
4. All of them

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



 
21) Which one is not correct about filter transformation?

1. Act as a ‘where’ condition
2. Can Pass Multiple Conditions
3. Act like ‘Case’ in pl/sql
4. If one record does not match condition, the record passes to the next record

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
22) What parallelisms does Pentaho support?

1. Data Parallelism : data is parallelly worked
2. Component Parallelism : Components are executed Parallely
3. Pipeline Parallelism : Data is passed from one component to another component.
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) Pentaho supports

1. Only homogeneous source and target
2. Heterogeneous source and target
3. Only heterogeneous Target
4. Both A and B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
24) Which is the better approach to utilize logic from one transformation or job in another process?

1. Transformations and jobs can be nested
2. Transformation logic can actually be shared by creating subtransformations
3. Both A and B
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]
 
 
25) 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]
 
 
26) 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]
 
 
27) 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]
 
 
28) 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]
 
 
29) 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]
 
 
30) 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]



 
31) Pentaho Execute SQL Script Step can be used..

1. during the initialization phase of the transformation
2. for every input-row that the step is given
3. a & b
4. none of the above.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
32) Merge Join Step Requires Inputs to be..

1. Pre-Sorted prior to Join Step.
2. No need to be sorted, the step itself performs the Sort.
3. Needs to be sorted using Sort Step.
4. A & C.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
33) 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]
 
 
34) 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]
 
 
35) 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]
 
 
36) 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]
 
 
37) 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]
 
 
38) 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]
 
 
39) 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]
 
 
40) 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]



 
41) 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]
 
 
42) 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]
 
 
43) 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]
 
 
44) 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]
 
 
45) 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]
 
 
46) 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]
 
 
47) 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]
 
 
48) 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]
 
 
49) 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]
 
 
50) Valid options for When writing rows in Microsoft Excel Writer Step

1. overwrite existing cells
2. shift existing cells down
3. shift existing cells up

 

1. 1,2
2. 2,3
3. 1,3
4. All of the above

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



 
51) Unique rows step requires 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]
 
 
52) What will be the output of following expression in formula stage ISNA(“#N/A”)
 

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]
 
 
53) What will be the output of following expression in formula stage ISTEXT(“1”)
 

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]
 
 
54) Memory Group by step requires sorted input

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]
 
 
55) 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]
 
 
56) 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]
 
 
57) 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]
 
 
58) 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]
 
 
59) 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]
 
 
60) How many evaluation modes are there in a job hop?

1. 2
2. 3
3. 4
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]