Pentaho Training: Study Guide for Certication Exams Pentaho Solution Consultant Certication Exam and Pentaho Data Integration Certication Exam
Copyright ©2014 Pentaho Corporation. Redistribution permitted. All trademarks are the property of their respective owners. For the latest information, please visit our web site at pentaho.com at pentaho.com..
Contents Contents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Pentaho Solution Consultant Certication Exam Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Topical Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Recommended Training . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Exam Topics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Recommended Reading . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Pentaho Data Integration Exam Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Topical Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Recommended Training . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Exam Topics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 Recommended Reading . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
STUDY GUIDE FOR CERTIFICATION EXAMS PENTAHO
2
Overview The Pentaho Solution Consultant certication examination coordinates with Pentaho’s professional training oerings. The examination is delivered in an un-proctored, online format. Despite the un-proctored format, you are not allowed to use external resources when taking the exam (including books, course materials, Google searches, colleagues, and so on). The Pentaho Solution Consultant examination is 90 minutes long and consists of 75 questions chosen (at random) from a series of question pools. To pass the exam, you must achieve a score of 80% (or higher). The Pentaho Solution Consultant exam is designed to validate the knowledge and sk ills required to deliver rapid, high-value implementations of the Pentaho business intelligence platform. The e xam is intended for experienced Business Intelligence Consultants, Business Intelligence Solution Developers, Technical Business Analysts, Content Creators, and Pentaho Partners.
TOPICAL OVERVIEW
>
BA2000 - Business Analytics Report Designer: https://training.pentaho.com/ instructor-led-training/business-analytics-reportdesigner-ba2000
>
BA3000 - Business Analytics Data Modeling: https://training.pentaho.com/instructor-ledtraining/business-analytics-data-modeling-ba3000
>
DI1000 - Pentaho Data Integration: https:// training.pentaho.com/instructor-led-training/ pentaho-data-integration-di1000
>
AD1000 - Pentaho Installation and Administration: https://training.pentaho. com/instructor-led-training/installation-andadministration-for-version-50-ad1000
The Pentaho Solution Consultant exam covers the following topics: >
> > >
>
> >
Installing and conguring the Pentaho business intelligence platform Using xactions Implementing security Using Pentaho Data Integration to create jobs and transformations Implementing OLAP cubes using Pentaho Schema Workbench Creating reports using Pentaho Report Designer Using the Pentaho User Console tools to generate content: Pentaho Analysis, Pentaho Interactive Reporting, Pentaho Dashboard Designer
RECOMMENDED TRAINING
Pentaho oers a variety of courses to assist exam takers. Before attempting the certication exam, Pentaho Training recommends the following courses:
For some exam subjects, the following additional course may also be useful: >
>
BA1000 - Business Analytics User Console: https://training.pentaho.com/instructor-ledtraining/business-analytics-user-console-ba1000
SLN7000 - Integrating and Extending Pentaho: http://www.pentaho.com/services/training/ pentaho_architects_bootcamp.php
STUDY GUIDE FOR CERTIFICATION EXAMS PENTAHO
3
EX AM TOPICS
This section lists the topics found on the Solution Consultant exam and includes resources available to assist exam takers. Sample exam questions are also included. Most exam topics are covered by the Pentaho Training curricula and the Pentaho product documentation. All documentation on the Pentaho platform can be found in the Pentaho InfoCenter at: >
http://infocenter.pentaho.com/help/index.jsp.
TOPIC
RESOURCES
SAMPLE E X AM QUESTION
Installation and Deployment
>
From the Pentaho InfoCenter: • BA Server Manual Deployment Guide • Business Analytics Graphical Installer Guide • Pentaho Data Integration Installation Guide
What is the default location of the Hibernate conguration les?
Action sequences, Pentaho Design Studio
>
From the Pentaho InfoCenter: • Creating Action Sequences
>
From Pentaho Training: • SLN7000 Integrating and Extending Pentaho
What is the most common use for a global action sequence?
Security Model, Securing Objects
>
From the Pentaho InfoCenter: • The Pentaho Security Guide
What open source framework is used by Pentaho for authentication and authorization?
Carte, Pan, Kitchen
>
From the Pentaho InfoCenter: • Pentaho Data Integration Administrator’s Guide
Which parameters must be passed to Carte on startup?
>
From Pentaho Training: • DI1000 Pentaho Data Integration
>
From the Pentaho InfoCenter: • Pentaho Metadata Editor User Guide
>
From Pentaho Training: • BA3000 Business Analytics Data Modeling
Metadata, Metadata Security
STUDY GUIDE FOR CERTIFICATION EXAMS PENTAHO
4
To load a metadata domain le, what les must exist in the same parent directory in the solution repository?
TOPIC
Mondrian
Pentaho Report Designer
Pentaho User Console
Pentaho Interactive Reporting
Pentaho Analyzer
Pentaho Dashboard Designer
Pentaho Analyzer
Community Dashboard Framework (CDF)
RESOURCES
SAMPLE E X AM QUESTION
>
The Mondrian project documentation: • http://mondrian.pentaho.com
What le controls Mondrian logging?
>
From the Pentaho InfoCenter: • Pentaho Report Designer User Guide
A trac light can be added to a data element in a report by using a ___ ___ __?
>
From Pentaho Training: • BA2000: Business Analytics Report Designer
>
From the Pentaho InfoCenter: • Pentaho User Console Guide
>
From Pentaho Training: • BA1000 Business Analytics User Console
>
From the Pentaho InfoCenter: • Pentaho User Console Guide
>
From Pentaho Training: • BA1000 Business Analytics User Console
>
From the Pentaho InfoCenter: • The Pentaho Analysis Guide
>
From Pentaho Training: • BA1000 Business Analytics User Console
>
From the Pentaho InfoCenter: • Pentaho User Console Guide
>
From Pentaho Training: • BA1000 Business Analytics User Console
>
From the Pentaho InfoCenter: • The Pentaho User Console Guide
>
From Pentaho Training: • BA1000 Business Analytics User Console
>
The Community Dashboard Framework documentation: • http://wiki.pentaho.com/display/ COM/Community+Dashboard+ Framework
STUDY GUIDE FOR CERTIFICATION EXAMS PENTAHO
5
When you create a model in Pentaho Data Access, what types of models does it create?
True or False: Aggregate functions in Interactive Reporting require groups.
True or False: You cannot drill on a chart object in Pentaho Analyzer.
True or False: Aggregate functions in Interactive Reporting require groups.
In what le would you nd the templates used in Pentaho Dashboard Designer?
True or False: A FolderTree is a core CDF component.
Note: Though the exam tests knowledge of the Pentaho suite of products, exam takers may nd the Pentaho Community wiki helpful as well: http://wiki.pentaho.com/display/COM/ Community+Wiki+Home. The Community Edition wiki contains resources on a number of exam topics including:
RECOMMENDED READING
The following publications may also be useful in preparing for the certication exam: >
> > > > > >
Creating business intelligence solutions Security Data integration (Kettle) Metadata Reporting
>
>
Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL by Roland Bouman and Jos van Dongen Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration by Matt Casters, Roland Bouman, and Jos van Dongen Pentaho Reporting 3.5 for Java Developers by Will Gorman Pentaho Data Integration 4 Cookbook by María Carina Roldán and Adrian Sergio Pulvirenti
Overview The Pentaho Data Integration exam is an un-proctored, 60 minute online examination consisting of 50 questions derived from a larger question pool. A score of 80% is required to pass the exam. Despite the un-proctored format, you are not allowed to use external resources when taking the exam (including books, course materials, Google searches, colleagues, and so on). Before taking the exam, it is recommended that students have a minimum of six months experience using Pentaho Data Integration. Several exam questions are designed to test practical knowledge gained from deploying Pentaho Data Integration in the eld. The Pentaho Data Integration certication exam is designed to validate the knowledge and skills required to deliver rapid, high-value implementations of Pentaho Data Integration (including Big Data implementations). The exam is intended for experienced Business Intelligence Consultants, Business Intelligence Application Developers, Database Administrators, Business Intelligence Solution Architects, Technical Business Analysts, and Pentaho Partners. TOPICAL OVERVIEW
>
The Pentaho Data Integration exam covers the following topics: > > >
> >
Installing and conguring Pentaho Data Integration Conguring transformation steps and job entries Performing extract, transform, load (ETL) operations in PDI
> >
Maintaining job/transformation portability Using Kitchen and Pan Clustering and partitioning Logging Big Data
STUDY GUIDE FOR CERTIFICATION EXAMS PENTAHO
6
RECOMMENDED TRAINING
>
Pentaho oers a variety of courses to assist exam takers. Before attempting the certication exam, Pentaho recommends taking the following course:
BA3000 - Business Analytics Data Modeling: https://training.pentaho.com/instructor-ledtraining/business-analytics-data-modeling-ba3000
EXAM TOPICS
DI1000 - Pentaho Data Integration: https:// training.pentaho.com/instructor-led-training/ pentaho-data-integration-di1000
This section lists the topics found on the certication exam and resources available to assist exam takers. Sample exam questions are also included.
For some exam subjects, the following additional courses may also be useful:
Most exam topics are covered by the Pentaho Training curricula and the Pentaho product documentation. All documentation on the Pentaho platform can be found in the Pentaho InfoCenter at:
>
>
>
SLN7000 - Integrating and Extending Pentaho: https://training.pentaho.com/instructor-ledtraining/integrating-and-extending-pentahosln7000 BA1000 - Business Analytics User Console: https://training.pentaho.com/instructor-ledtraining/business-analytics-user-console-ba1000
>
Though the exam tests knowledge of the Pentaho suite of products, exam takers may nd the Pentaho Community Wiki helpful as well: >
>
BA2000 - Business Analytics Report Designer: https://training.pentaho.com/ instructor-led-training/business-analytics-reportdesigner-ba2000
TOPIC
http://infocenter.pentaho.com/help/index.jsp
http://wiki.pentaho.com/display/COM/ Community+Wiki+Home
Exam takers should have a general understanding of the following topics:
RESOURCES
SAMPLE E X AM QUESTION
Installation and Deployment
>
From the Pentaho InfoCenter: • Pentaho Data Integration Installation Guide
What is the default location of the Hibernate conguration les?
Steps
>
From the Pentaho Wiki: • http://wiki.pentaho.com/display/ EAIPentaho+Data+Integration +Steps
True or False: The Modied Java Script Value step supports calling Java methods.
>
From Pentaho Training: • DI1000 Pentaho Data Integration
STUDY GUIDE FOR CERTIFICATION EXAMS PENTAHO
7
TOPIC
Job Entries
Carte, Pan, Kitchen
Logging
RESOURCES
SAMPLE E X AM QUESTION
>
From the Pentaho Wiki: • http://wiki.pentaho.com/display/ EAI/Pentaho+Data+Integration +Job+Entries
>
From Pentaho Training: • DI1000 Pentaho Data Integration
>
From the Pentaho InfoCenter: • Pentaho Data Integration Administrator’s Guide
>
From Pentaho Training: • DI1000 Pentaho Data Integration
>
From the Pentaho InfoCenter: • Pentaho Data Integration Administrator’s Guide
>
From Pentaho Training: • DI1000 Pentaho Data Integration
The following publications may also be useful in preparing for the certication exam:
>
>
Which parameters must be passed to Carte on startup?
The easiest way to enable job logging in database tables in PDI is by_________.
Information on all Pentaho training courses can be found at www.pentaho.com/services/training/
RECOMMENDED READING
>
What is true about job entries launched in parallel?
Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration by Matt Casters, Roland Bouman, and Jos van Dongen Pentaho Data Integration 4 Cookbook by María Carina Roldán and Adrian Sergio Pulvirenti Pentaho 3.2 Data Integration: Beginner’s Guide by María Carina Roldán
STUDY GUIDE FOR CERTIFICATION EXAMS PENTAHO
8
Global Headquarters Citadel International - Suite 340 5950 Hazeltine National Dr. Orlando, FL 32822, USA tel +1 407 812 6736 fax +1 407 517 4575
US & Worldwide Sales Oce 353 Sacramento Street, Suite 1500 San Francisco, C A 94111, USA tel +1 415 525 5540 toll free +1 866 660 7555
Learn more about Pentaho Training www.pentaho.com/services/training +1 (866) 660-7555
United Kingdom, Rest of Europe, Middle East, Africa London, United Kingdom tel +44 7711 104854 toll free (UK) 0 800 680 0693 FRANCE
Oces - Paris, France tel +33 97 51 82 296 toll free (France) 0800 915343 GERMANY, AUSTRIA, SWITZERLAND
Oces - Frankfurt, Germany tel +49(0)89 / 37 41 40 81 toll free (Germany) 0800 186 0332 BELGIUM, NETHERLANDS, LUXEMBOURG
Oces - Antwerp, Belgium tel +31 6 52 69 88 01 toll free (Belgium) 0800 773 83
Copyright ©2014 Pentaho Corporation. Redistribution permitted. All trademarks are the property of their respective owners. For the latest information, please visit our web site at pentaho.com. 14-521
