[HCE5910] HCE 5910 Hitachi Vantara Certified
Specialist Pentaho Business Analytics
Implementation Certification Exam Guide
**Question 1.** Which installation method allows you to install the Pentaho Business Analytics
suite without a graphical user interface?
A) Graphical installer (GUI)
B) Command‑line silent installer
C) Docker container deployment
D) Cloud Marketplace deployment
**Answer:** B
**Explanation:** The command‑line silent installer performs an unattended installation,
suitable for scripted or automated environments where no GUI is available.
**Question 2.** During environment validation, which Java version is the minimum required for
Pentaho 9.x releases?
A) Java 8 update 40
B) Java 8 update 60
C) Java 11
D) Java 7
**Answer:** B
**Explanation:** Pentaho 9.x requires at least Java 8 update 60 to ensure compatibility with the
underlying libraries and to receive critical security updates.
**Question 3.** Which file contains the primary configuration for the Pentaho BA server’s web
container?
A) pentaho.xml
B) server.xml
C) context.xml
D) web.xml
, [HCE5910] HCE 5910 Hitachi Vantara Certified
Specialist Pentaho Business Analytics
Implementation Certification Exam Guide
**Answer:** B
**Explanation:** *server.xml* is the Tomcat (or Jetty) configuration file that defines connectors,
ports, and other servlet container settings for the BA server.
**Question 4.** In Pentaho Schema Workbench, what component defines the hierarchical
relationship between members of a dimension?
A) Measure
B) Level
C) Hierarchy
D) Cube
**Answer:** C
**Explanation:** A hierarchy groups levels to represent parent‑child relationships within a
dimension, enabling drill‑down and roll‑up operations.
**Question 5.** Which of the following best describes a “JNDI” data source in Pentaho?
A) A direct JDBC URL stored in the repository
B) A data source defined in the application server’s naming service
C) A CSV file imported into the repository
D) An XML file containing connection parameters
**Answer:** B
**Explanation:** JNDI (Java Naming and Directory Interface) allows the BA server to look up a
data source that the application server (e.g., Tomcat) has pre‑configured, promoting reuse and
centralized management.
**Question 6.** When publishing a Mondrian schema, which repository folder type should be
used?
, [HCE5910] HCE 5910 Hitachi Vantara Certified
Specialist Pentaho Business Analytics
Implementation Certification Exam Guide
A) Files
B) Reports
C) Solutions
D) Pentaho Server
**Answer:** C
**Explanation:** The *solutions* folder holds Pentaho BI objects, including Mondrian schemas,
which are then accessible to the server runtime.
**Question 7.** Which security object in the Pentaho User Console controls read/write
permissions on a specific folder?
A) Role
B) User
C) ACL (Access Control List)
D) Policy
**Answer:** C
**Explanation:** An ACL defines the allowed actions (read, write, execute) for users or roles on
a particular repository object.
**Question 8.** In Pentaho Report Designer, which band is used to display column headers for
a table component?
A) Page Header
B) Column Header
C) Group Header
D) Detail
**Answer:** B
, [HCE5910] HCE 5910 Hitachi Vantara Certified
Specialist Pentaho Business Analytics
Implementation Certification Exam Guide
**Explanation:** The *Column Header* band repeats at the top of each page for a table,
showing the column titles.
**Question 9.** Which component of Pentaho Analyzer provides the “slice” functionality?
A) Drag‑and‑drop filter panel
B) Pivot table view
C) Chart selector
D) Data source manager
**Answer:** A
**Explanation:** The filter panel lets users select members from a dimension, effectively
“slicing” the cube to focus on a subset of data.
**Question 10.** What is the primary purpose of the Aggregation Designer tool?
A) Create visual dashboards
B) Define report parameters
C) Build aggregate tables to speed up OLAP queries
D) Manage user authentication
**Answer:** C
**Explanation:** Aggregation Designer helps generate and publish pre‑aggregated tables that
Mondrian can use to answer queries faster.
**Question 11.** Which log level provides the most detailed information for troubleshooting
Pentaho server issues?
A) ERROR
B) WARN
Specialist Pentaho Business Analytics
Implementation Certification Exam Guide
**Question 1.** Which installation method allows you to install the Pentaho Business Analytics
suite without a graphical user interface?
A) Graphical installer (GUI)
B) Command‑line silent installer
C) Docker container deployment
D) Cloud Marketplace deployment
**Answer:** B
**Explanation:** The command‑line silent installer performs an unattended installation,
suitable for scripted or automated environments where no GUI is available.
**Question 2.** During environment validation, which Java version is the minimum required for
Pentaho 9.x releases?
A) Java 8 update 40
B) Java 8 update 60
C) Java 11
D) Java 7
**Answer:** B
**Explanation:** Pentaho 9.x requires at least Java 8 update 60 to ensure compatibility with the
underlying libraries and to receive critical security updates.
**Question 3.** Which file contains the primary configuration for the Pentaho BA server’s web
container?
A) pentaho.xml
B) server.xml
C) context.xml
D) web.xml
, [HCE5910] HCE 5910 Hitachi Vantara Certified
Specialist Pentaho Business Analytics
Implementation Certification Exam Guide
**Answer:** B
**Explanation:** *server.xml* is the Tomcat (or Jetty) configuration file that defines connectors,
ports, and other servlet container settings for the BA server.
**Question 4.** In Pentaho Schema Workbench, what component defines the hierarchical
relationship between members of a dimension?
A) Measure
B) Level
C) Hierarchy
D) Cube
**Answer:** C
**Explanation:** A hierarchy groups levels to represent parent‑child relationships within a
dimension, enabling drill‑down and roll‑up operations.
**Question 5.** Which of the following best describes a “JNDI” data source in Pentaho?
A) A direct JDBC URL stored in the repository
B) A data source defined in the application server’s naming service
C) A CSV file imported into the repository
D) An XML file containing connection parameters
**Answer:** B
**Explanation:** JNDI (Java Naming and Directory Interface) allows the BA server to look up a
data source that the application server (e.g., Tomcat) has pre‑configured, promoting reuse and
centralized management.
**Question 6.** When publishing a Mondrian schema, which repository folder type should be
used?
, [HCE5910] HCE 5910 Hitachi Vantara Certified
Specialist Pentaho Business Analytics
Implementation Certification Exam Guide
A) Files
B) Reports
C) Solutions
D) Pentaho Server
**Answer:** C
**Explanation:** The *solutions* folder holds Pentaho BI objects, including Mondrian schemas,
which are then accessible to the server runtime.
**Question 7.** Which security object in the Pentaho User Console controls read/write
permissions on a specific folder?
A) Role
B) User
C) ACL (Access Control List)
D) Policy
**Answer:** C
**Explanation:** An ACL defines the allowed actions (read, write, execute) for users or roles on
a particular repository object.
**Question 8.** In Pentaho Report Designer, which band is used to display column headers for
a table component?
A) Page Header
B) Column Header
C) Group Header
D) Detail
**Answer:** B
, [HCE5910] HCE 5910 Hitachi Vantara Certified
Specialist Pentaho Business Analytics
Implementation Certification Exam Guide
**Explanation:** The *Column Header* band repeats at the top of each page for a table,
showing the column titles.
**Question 9.** Which component of Pentaho Analyzer provides the “slice” functionality?
A) Drag‑and‑drop filter panel
B) Pivot table view
C) Chart selector
D) Data source manager
**Answer:** A
**Explanation:** The filter panel lets users select members from a dimension, effectively
“slicing” the cube to focus on a subset of data.
**Question 10.** What is the primary purpose of the Aggregation Designer tool?
A) Create visual dashboards
B) Define report parameters
C) Build aggregate tables to speed up OLAP queries
D) Manage user authentication
**Answer:** C
**Explanation:** Aggregation Designer helps generate and publish pre‑aggregated tables that
Mondrian can use to answer queries faster.
**Question 11.** Which log level provides the most detailed information for troubleshooting
Pentaho server issues?
A) ERROR
B) WARN
