hitachi hce-5920 practice test

You have a PDI input step that generates data within a transformation.
Which two statements are true about downstream steps in this scenario? (Choose two.)
Choose 2 answers

• A. The steps will receive a stream of data from the input as soon as it is a available.
• B. Only one step can receive data from the input step.
• C. The steps will receive the data once the input step fully fetches it.
• D. Multiple steps can receive data from the input step.

You need to perform a union of two data flows in a PDI transformation. You plan on having one step
receive the two hops from the different flows.
Which two statements are true in this scenario? (Choose two.)
Choose 2 answers

• A. You can only use the Append streams step to join these two flows.
• B. The row layout must be identical between the two steps.
• C. You can use the 'Dummy (do nothing)' step to join these two flows.
• D. The row layout can be different between the two steps as long as the data types are the same

Which feature of PDI will allow you to create an Interactive Reporting report against a Web service?

• A. Pontaho Data Service
• B. Checkpoints
• C. Metadata Injection
• D. Capability Manager

A client is developing a Web application to implement a wizard-like application used by many users.
At several points in the workflow, the application needs to execute jobs and transformations that are
stored in the Pentaho server. Execution will include user-specific parameters. Upon completion of the
job or transformation, the Web application will continue to the next UI page.
What is the recommended approach to accomplish this task?

• A. Use the Web service API to execute the jobs and transformations on the Pentaho server.
• B. Use the scheduling tool of the OS to execute the job and transformation on the pentaho server.
• C. Use the Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.
• D. Use the Job and Transformation steps to execute the jobs and transformations on the Pentaho server.

A customer has an existing PDI job that calls a transformation. They want to execute the
transformation through Spark on their Hadoop cluster.
Which change must be made to satisfy this requirement?

• A. Change the Parameters of the transformation
• B. Change the Run Configuration of the transformation
• C. Change the Logging options of the transformation
• D. Change the Arguments of the transformation

A customer needs to extract data from many afferent text He layouts with new file layouts being
identified in the future and they want to insert the data into corresponding database tables. They are
concerned about maintaining multiple PDI jobs and transformations given the large number of
unique files.
What should you do to meet the requirements when creating transformations?

• A. Use the Metadata structure of stream step for each file.
• B. Use the Transformation Executor step for each file.
• C. Use the ETL Metadata injection step
• D. Use the Job Executor step for each file.

You need to load data from many CSV files into a database and you want to minimize the number of
PDI jobs and transformations that need to be maintained.
In which two scenarios is Metadata injection the recommend option? (Choose two.)
Choose 2 answers

• A. When the files have a different structure and have different target tables.
• B. When the files have a different structure and have the same target table.
• C. When the files have the same structure and have different target tables.
• D. When the files have the same structure and have the same target table.

You execute a transformation locally in Spoon to read data from an Oracle database and you receive
the Drive not found’ exception.
What are two ways to solve this problem? (Choose two.)
Choose 2 answers

• A. Copy the Oracle JDBC driver to the data-integration/lib folder of PDI.
• B. Copy of the Oracle JDBC driver to the tomcat/lib folder of the Pentaho server.
• C. Use the PDI import script
• D. Use the JDBC Distribution Tools.

To simplify the migration of a PDI solution from one environment to another, you need to externalize
all database connection details.
Which two methods will satisfy this requirement? (Choose two.)
Choose 2 answers

• A. Use the Data Source Wizard to generate the connection details.
• B. Create a properties file that includes the connection details and use the Set Variables step to load these properties.
• C. Use Manage Data Source to create a new connection in Spoon.
• D. Set the connection details in the Kettle properties file.

You are developing the PDI solution for a customer. The customer requires that a set of SQL
statements are executed on each connection to the database.
Which method will satisfy this requirement?

• A. Use JNDI to specify the SQL statements.
• B. Use the Advanced section in the Database Connection window to enter the SQL statements.
• C. Use the Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.
• D. Use the Database Connection wizard and specify SQL statements.