Cisco®
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
Scrum
All Vendors
  2. Home
  3. Exams
  4. Hitachi
  5. HCE-5920

Free HCE-5920 Exam Braindumps (page: 6)

Page 5 of 16
PDF with 60 Questions

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

  1. When the files have a different structure and have different target tables.
  2. When the files have a different structure and have the same target table.
  3. When the files have the same structure and have different target tables.
  4. When the files have the same structure and have the same target table.

Answer(s): B,D



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

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

Answer(s): A,C



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

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

Answer(s): A,D



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?

  1. Use JNDI to specify the SQL statements.
  2. Use the Advanced section in the Database Connection window to enter the SQL statements.
  3. Use the Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.
  4. Use the Database Connection wizard and specify SQL statements.

Answer(s): C






Post your Comments and Discuss Hitachi HCE-5920 exam with other Community members: