Free Access To Hitachi HCE-5920 Practice Exam Questions

test2022-06-10T06:34:40+00:00

Want to pass Hitachi HCE-5920 exam? Hitachi Vantara Certified Specialist – Pentaho Data Integration Implementation exam certifies that the successful candidate has knowledge, skills and abilities to implement and support Pentaho Data Integration solutions. Here we have valid HCE-5920 practice exam providing with actual questions and correct answers to ensure that you can pass Hitachi HCE-5920 exam in the first try. We ensure that you can pass HCE-5920 Hitachi Vantara Certified Specialist – Pentaho Data Integration Implementation exam and achieve your certification easily and successfully.

To help you prepare for the exam, take a free HCE-5920 practice test.

Page 1 of 2

1. 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.

2. You need to perform a union of two data flows in a PDI transformation. You plan on having one step receive the two hops from the different flows.

Which two statements are true in this scenario? (Choose two.)

You can only use the Append streams step to join these two flows.

The row layout must be identical between the two steps.

You can use the 'Dummy (do nothing)' step to join these two flows.

The row layout can be different between the two steps as long as the data types are the same

3. You want to manage a slowly changing dimension as type II.

Which step in PDI should you use to accomplish this task.

The ‘Shared Dimension’ step

The ‘Dimension Lookup/update’ step

The ‘Combination lookup/update’ step

The ‘Table output step

4. You need to process data on the nodes within a Hadoop cluster. To accomplish this task, you write a mapper and reducer transformation and use the Pentaho MapReduce entry to execute the MapReduce job on the cluster.

In this scenario, which two steps are required within the transformations? (Choose two.)

the Madoop Fie Input step

the Hadoop File Output step

the MapReduce Input step

the MapReduce Output step

5. When deploying your work lo the Pentaho server, which configuration Me should you review to ensure that the environment variable information is moved correctly?

repositories.xml

shared.xml

kettle.properties

context.xml

6. You are installing a Pentaho server and you decide to use a responsibility database other than Postgres.

Which two database are supported in this configuration? (Choose two.) Choose 2 answers

Microsoft SQL Server

Oracle

DB2

Sybase

7. Which script will execute jobs stored in a Pentaho server from a command line?

pan

carle

kitchen

spoon

8. The log files on a Pentaho server rotate daily and are getting too large. You want to change want logs to rotate hourly.

How do you adjust the log settings?

Modify the transformation's properties.

Modify the Pentaho server's tog4j.xml.

Modify the Tomcat startup bat or startup.sh script

Modify the start-pentaho bat or start-pentaho.sh script

9. You have slow-running steps in a PDI transformation and you notice that it is taking a long time for subsequent steps to get data and begin processing.

Which action will help solve the problem?

Reduce the value in the Nr’ of rows in rowset’ option on the Miscellaneous tab in the Transformation properties.

Select the ‘Enable step performance monitoring?’ option on the Monitoring tab in the Transformation properties.

Right click on the slow-running steps and select the Load Balance option from the Data Movement submenu.

Select the ‘Execute for every input row? Option on the Advanced tab of the Transformation properties from the parent job.

10. A Big Data customer is experiencing failures on a Table input step when running a PDl transformation on AEL Spark against a large Oracle database.

What are two methods to resolve this issue? (Choose two.)

Increase the maximum size of the message butters tor your AEL environment.

Load the data to HDFS before running thetransform.

Add the Step ID to the Configuration File.

Increase the Spark driver memory configuration.

Page 2 of 2

11. 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.)

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.

12. You have instated the Pentaho server using an archive installation. You now want to change the server port.

Which file do you modify?

server.xml

repositories.xml

context.xml

slave-server-config.xml

13. 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.)

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

14. A customer has an archive-based installation. They have not configured logging tables or changed the defaultconfiguration settings. They need to research an issue that has been affecting one of their scheduled PDI jobs for the past week.

In this situation, where do they go to view more details about the execution of these jobs?

pentaho-server/tomcat/logs

pentaho-service/data

pentaho-server/pentaho

solutions/system/karaf/system/org/apache/karaf/log pentaho/server/pentaho-solution/system/karaf/System/commons logging

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

the 'XML Join' step

the 'Modified Java Script Value' stop

the 'Get data from XML' step

the 'Add XML'step