New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Hitachi HCE-5920 Dumps Questions Answers

Page: 1 / 2
Total 60 questions

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

Question 1

Which three file formats are splittable on HDFS? (Choose three).

Choose 3 answers

Choose 3 answers

Options:

A.

txt

B.

xml

C.

Parquet

D.

xisx

E.

Avro

Buy Now
Question 2

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:

A.

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

B.

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

C.

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

D.

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

Question 3

Which two statements are correct about the Repository Explorer? (Choose two.)

Choose 2 answers

Options:

A.

You can create new jobs and transformations.

B.

You can move. rename, and delete jobs and transformations.

C.

You can upload JDBC drivers when defining JOBC connections.

D.

You can lock and unlock jobs and transformations.

Question 4

You have completed a successful installation of a Pentaho server on Linux.

You now need to write a script to run the Pentaho server as a service.

Which two files should you call from the script? (Choose two.)

Choose 2 answers

Options:

A.

start-pentaho.sh

B.

start-pentaho-debug.

C.

import-export.sh

D.

stop-pentaho.sh

Question 5

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

Options:

A.

Copy the Oracle JDBCdriver 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.

Question 6

You are running a PDI Joband you need to identify when something fails for a specific job entry to notify the sysops team about the failure.

Which statement is correct in this scenario?

Options:

A.

Define the true evaluation hop out of the job entry that you are going to verify.

B.

Definethe false evaluation hop out of the job entry that you are going to verify.

C.

Define the unconditional evaluation hop out of the job entry that you are going to verify.

D.

Do not define any evaluation hop out of the Job entry that are going to verify.

Question 7

To simplify themigration 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

Options:

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.

Question 8

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

Options:

A.

When the files have a different structure andhave 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.

Question 9

You are encryption your database connection password to use in the kettle. properties file. The output of the encr script is:

Encrypted XYZABC123

In this scenario, which syntax is correct?

Options:

A.

DB_PASSWORD=Encrypted(‘XYZABC 123’)

B.

DB_PASSWORD=String(‘XYZABC123’)

C.

DB_PASSWORD=XYZABC123

D.

DB_PASSWORD=Encrypted XYZABC123

Page: 1 / 2
Total 60 questions