Free HCE-5920 Exam braindumps download (HCE-5920 exam dumps Free)

QUESTION: 16

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?

Use the Metadata structure of stream step for each file.
Use the Transformation Executor step for each file.
Use the ETL Metadata injection step
Use the Job Executor step for each file.

Answer(s): C

Show Answer Next Question

QUESTION: 17

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

When the files have a different structure and have different target tables.
When the files have a different structure and have the same target table.
When the files have the same structure and have different target tables.
When the files have the same structure and have the same target table.

Answer(s): B,D

Show Answer Next Question

QUESTION: 18

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

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

Answer(s): A,C

Show Answer Next Question

QUESTION: 19

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

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

Answer(s): A,D

Show Answer Next Question

QUESTION: 20

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?

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.

Answer(s): C

Show Answer Next Question

Free HCE-5920 Exam Braindumps Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation Questions 16–20 (page: 5)

QUESTION: 16

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20

Free HCE-5920 Exam Braindumps
Hitachi Vantara Certified Specialist - Pentaho Data Integration Implementation Questions 16–20 (page: 5)