Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation

QUESTION NO: 1
According to Hitachi vantara best practices, which three statements arc true when designing a realtime streaming, solution? (Choose me.) Choose 3 answers

A. You should enable error handing on each step that could cause a message parsing fatal error. B. Data duplication detection and management should be handled during realtime data processing. C. Using sorts during data ingestion can block downstream processing. D. The Kafka Consumer step has an offset setting that allows records to be reprocessed inthe event of failure. E. You should process data in large batches to make sure it is processed as soon as possible.

Correct Answer: B,D,E

QUESTION NO: 2
Which two steps in a transformation allow variable valuesto be used throughout the rest of a PDI job? (Choose two.) Choose 2 answers

A. the 'Table inpuT step B. the Modified Java Script Value' step C. the 'Select values' step D. the 'Set Variables' step

Correct Answer: B,D

QUESTION NO: 3
You are implementing a Pentaho server repository for a customer.
The customer will be using the Pentaho Scheduler.
Which repository supports this requirement?

A. Kettle File Repository B. Pentaho Repository C. Carlo Repository D. Kettle Database Repository

Correct Answer: B

QUESTION NO: 4
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 of the Oracle JDBC driver to the tomcat/lib folder of the Pentaho server. B. Copy the Oracle JDBCdriver to the data-integration/lib folder of PDI. C. Use the PDI import script D. Use the JDBC Distribution Tools.

Correct Answer: B,C

QUESTION NO: 5
you want to make a dynamic PDI transformation that is driven with variables that areloaded from a properties file.
Which free form text fields within a step can be configured with variables?

A. any free form text field with a '$' sign next to it. B. Any free form text field with a ''V'' next to it C. Any free form text field with the variable name entered in all caps D. any free form text field with a '@' sign next to it.

Correct Answer: D

QUESTION NO: 6
You have multiple transformations that read and process data from multiple text files. You identity a series of steps that are common across transformations and you want to re-use them to avoid duplication of code.
How doyou accomplish this?

A. Use the 'Job Executor1 step containing the series of steps B. Use the "Mapping (sub-transformation)' step containing the series of steps. C. Use the ETL Metadata Infection' stop containing the series of steps. D. Use the "Get data from XML' step to read the series of steps

Correct Answer: C

QUESTION NO: 7
You need to design a PDI job that will execute a transformation andthen send an e-mail with an attached log of the transformation's execution.
Which two sets of actions will accomplish this task? (Choose two.)
Choose 2 answers

A. In the Transformation entry option, select the 'Specify logfile' option and enter a name and extension for the file. B. In the mail entry's options, select the 'Attach files to message' option and select the filetype 'Log' C. In the Mail entry's options, select the 'Attach files to message' option and select the file type General' D. In the log tab of job properties, configure the Log Connection and the Log table options for the Job entry log tablesection.

Correct Answer: A,C

Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation - HCE-5920 Exam Questions