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

Which feature of PDI will allow you to create an Interactive Reporting report against a Web service?

• Pontaho Data Service
• Checkpoints
• Metadata Injection
• Capability Manager

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

You have a PDI job where you want to dynamically pass a table name to the Table input step of a transformation. You have replaced the table name reference in the transformation's Table input step with $(table_name)' but when the transformation runs the table name is shown as '$(table_name);Which action will correct this issue?

• Add a transformation entry in the job that uses the Get Variables step.
• Add a transformation entry in the job that sets the table-name variable.
• Change the reference in the Table input step to '?'
• Add a Set Variable step before the Table input step in the transformation.

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.

You are connecting to a secure Hadoop dueler from Pentaho and want to use impersonation.Which Pentaho tool should you use?

• Pentaho Report Designer
• Pentaho Spoon
• Pentaho Security Manager
• Pentaho Server

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

• Increase the maximum size of the message butters tor your AEL environment.
• Load the data to HDFS before running the transform.
• Add the Step ID to the Configuration File.
• Increase the Spark driver memory configuration.

A customer has an archive-based installation. They have not configured logging tables or changed the default configuration 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

A Big Data customer wants to run POI transformations on Spark on their production Hadoop cluster using Pentaho's Adaptive Execution Layer (AEL)What are two steps for installing AEL? (Choose two.)Choose 2 answers

• Run the Spark application butter tool to obtain the AEL daemon zip file.
• Configure the AEL daemon in Local Mode.
• Run the AEL Oozie job to install the AEL daemon.
• Configure the AEL daemon in YARN Mode

A customer has an existing PDI job that calls a transformation. They want to execute the transformation through Spark on their Hadoop cluster.Which change must be made to satisfy this requirement?

• Change the Parameters of the transformation
• Change the Run Configuration of the transformation
• Change the Logging options of the transformation
• Change the Arguments of the transformation

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.