Free Hitachi Vantara Certified Specialist Pentaho Data Integration Implementation Exam HCE-5920 Exam Practice Test

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

• txt
• xml
• Parquet
• xisx
• Avro

You have a PDI job that gets a list of variables followed by three subsequent transformation entries. Since the three subsequent transformation entries are not dependent on each other. You want to execute them at the same time.According the Hitachi Vantara best practices, how do you accomplish this task?

• Select the Run Next Entries in Parallel option for the job entry that gathers variables.
• Select the Run Next Entries in Parallel option for the three independent transformation entries.
• Select the Enable Downstream setting from the Hop Bulk Change submenu.
• Increase the Change Number of Copies to Start option on the input step of each of the subsequent transformations.

You need to design a PDI job that will execute a transformation and then send an e-mail with an attached log of the transformation's execution.Which two sets of actions will accomplish this task? (Choose two.)Choose 2 answers

• In the mail entry's options, select the 'Attach files to message' option and select the file type 'Log'
• In the Transformation entry option, select the 'Specify logfile' option and enter a name and extension for the file.
• In the log tab of job properties, configure the Log Connection and the Log table options for the Job entry log table section.
• In the Mail entry's options, select the 'Attach files to message' option and select the file type General'

In a PDI transformation you are retrieving data from a large lookup table using a Database Lookup step from improve performance, you enable caching in the step and use the Load all data from table option.In this scenario, which three statement s are correct about the data flow of the 'Database Lookup step? (Choose three.)

• When caching is enable, only rows with matching lookup values will passed through.
• There must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.
• Cached comparisons are case sensitive.
• Every input row must have only one matching row in the lookup table
• Only one matching row is used from the Lookup table.

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.)Choose 2 answers

• the Madoop Fie Input step
• the Hadoop File Output step
• the MapReduce Input step
• the MapReduce Output step

You need to populate a fact table with the corresponding surrogate keys from each dimension tableWhich two steps accomplish this task? (Choose two.)Choose 2 answers

• the 'Combination lookup/update' step
• the Dimension lookup/update' step
• the 'Select values' step
• the 'Filter rows' step

You are migrating to a new version of the Pentaho server and you want to import your old repository.What are two methods to accomplish this task? (Choose two.) Choose 2 answers

• Use the pan script
• Use the import-export script.
• Using Spoon Tools > Repository > import Repository
• Use the encr script.

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

• start-pentaho.sh
• start-pentaho-debug.
• import-export.sh
• stop-pentaho.sh

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?

• 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 faster execution
• 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

you want to make a dynamic PDI transformation that is driven with variables that are loaded from a properties file.Which free form text fields within a step can be configured with variables?

• Any free form text field with a ''V'' next to it
• any free form text field with a '@' sign next to it.
• any free form text field with a '$' sign next to it.
• Any free form text field with the variable name entered in all caps