Scribd
Upload
19 views4 pages

Pentaho ETL MCQ Test

The document is a multiple-choice question test focused on Pentaho ETL, containing 20 questions with one correct answer each. It covers various aspects of ETL processes, data transformation, and specific steps used in Pentaho Data Integration. Each question tests knowledge on terminology, functionalities, and operations within the Pentaho environment.

Uploaded by

buntyrajpoot9135206016
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
19 views4 pages

Pentaho ETL MCQ Test

The document is a multiple-choice question test focused on Pentaho ETL, containing 20 questions with one correct answer each. It covers various aspects of ETL processes, data transformation, and specific steps used in Pentaho Data Integration. Each question tests knowledge on terminology, functionalities, and operations within the Pentaho environment.

Uploaded by

buntyrajpoot9135206016
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Pentaho ETL – Multiple Choice Questions (MCQ) Test

Total Questions: 20
Each question has only one correct answer.
Choose the most appropriate option.

1. Q1. What does ETL stand for in Pentaho?

 A. Extract, Transform, Launch


 B. Evaluate, Transfer, Load
 C. Extract, Transfer, Load
 D. Extract, Transform, Load

2. Q2. Which of the following is responsible for data movement in Pentaho?

 A. Report Designer
 B. Transformation
 C. Job
 D. Metadata Editor

3. Q3. In ETL, which phase is responsible for converting data formats, removing nulls, and
applying business rules?

 A. Extraction
 B. Transformation
 C. Loading
 D. Validation

4. Q4. What is a transformation in Pentaho Data Integration (PDI)?

 A. A file type used to display dashboards


 B. A process to create metadata
 C. A set of steps to manipulate data
 D. A way to execute external programs

5. Q5. What is a job in Pentaho used for?

 A. Data filtering
 B. Visualizing data
 C. Managing and sequencing transformations
 D. Connecting to a database

6. Q6. Which step is used to read data from a CSV file in Pentaho?

 A. Table Input
 B. CSV File Input
 C. File Writer
 D. Text File Output

7. Q7. When using the Table Input step, you must write:

 A. A JSON file
 B. An Excel macro
 C. An SQL query
 D. A shell script

8. Q8. Which step is specifically used to read data from Excel files?

 A. Excel Reader
 B. Microsoft Excel Input
 C. XLS File Import
 D. Sheet Reader

9. Q9. Which step is used to rename, remove, or change data types of fields?

 A. Filter Rows
 B. Select Values
 C. Unique Rows
 D. Table Output

10. Q10. Which step allows you to filter records based on conditions?

 A. Calculator
 B. Select Values
 C. Filter Rows
 D. JSON Output

11. Q11. The Sort Rows step is used to:

 A. Group data by key


 B. Alphabetically order rows
 C. Remove duplicates
 D. Assign primary keys

12. Q12. What does the Unique Rows step do?

 A. Creates a primary key


 B. Removes duplicates from sorted data
 C. Changes field data type
 D. Merges datasets

13. Q13. Which step is used for performing mathematical and logical operations on fields?
 A. Filter Rows
 B. Calculator
 C. Join Rows
 D. Table Output

14. Q14. The Calculation step is typically used for:

 A. SQL Joins
 B. File conversion
 C. Field expressions and derived fields
 D. Sorting data

15. Q15. Which step is used to write data into a database table?

 A. Table Output
 B. Text File Output
 C. Table Input
 D. Insert Script

16. Q16. The Insert/Update step is used when:

 A. Only inserts are needed


 B. You want to update files
 C. You want to update a table if key exists, else insert
 D. You are exporting to Excel

17. Q17. Which of the following outputs data in JSON format?

 A. JSON Creator
 B. JSON Input
 C. JSON Output
 D. Text Output

18. Q18. In a job, which step is used to execute a transformation?

 A. Transformation Executor
 B. Start
 C. Job Entry
 D. Transformation

19. Q19. What does the Start step in a Pentaho job represent?

 A. Start of a transformation
 B. Entry point of a job
 C. Start of a CSV export
 D. Initial database connection
20. Q20. Which step is used in a transformation to limit the number of rows for testing
purposes?

 A. Sample Rows
 B. Limit Rows
 C. Row Number
 D. Row Sampler

You might also like