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

Questions 4

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

Options:

Pontaho Data Service

Checkpoints

Metadata Injection

Capability Manager

Buy Now

Questions 5

Which content is found in the kettle,properties files?

Options:

stared database objects

global variables

default language translations

repository connection properties

Buy Now

Questions 6

Which two PDI steps are used to parse XML content? (Choose two.)

Choose 2 answers

Options:

the 'XML Join' step

the 'Modified Java Script Value' stop

the 'Get data from XML' step

the 'Add XML'step

Buy Now

Questions 7

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?

Options:

Use JNDI to specify the SQL statements.

Use the Advanced section in the Database Connection window to enter the SQL statements.

Use the Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.

Use the Database Connection wizard and specify SQL statements.

Buy Now

Questions 8

What must be the first PDI step in a child transformation ingesting records from Kafka?

Options:

Get rows from result

Get records fromstream

Kafka Consumer

Get data from Kafka

Buy Now

Questions 9

A customer's transformation Is running slowly in a lest environment. You have access to Spoon and you can run and monitor the job.

How do you troubleshoot this problem?

Options:

Execute the transformation via the pan script and pass the performance gathering parameter.

Ensure there is enough memory on the Pentaho server and that there are no "Out Of Memory' errors in the log.

Make sure the customer is using data partitioning to ensure parallel processing for fasterexecution

Verify that there are no bottleneck slaps m the transformation by comparing the amount of rows in the input buffer versus the output buffer within the Step Metrics tab

Buy Now