Pass Guaranteed Quiz 2023 Realistic Verified Free HCE-5920 Exam Dumps [Q10-Q31]

4.5/5 - (2 votes)

Pass Guaranteed Quiz 2023 Realistic Verified Free HCE-5920 Exam Dumps

Free Hitachi Vantara Certified Specialist HCE-5920 Ultimate Study Guide (Updated 61 Questions)

QUESTION 10
Which script will execute jobs stored in a Pentaho server from a command line?

pan

carle

kitchen

spoon

QUESTION 11
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 stepsforinstalling 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

QUESTION 12
You need to load data from many CSV files intoa 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.

QUESTION 13
Which content is found in the kettle, properties files?

stared database objects

global variables

default language translations

repository connection properties

QUESTION 14
You need to download files from a web site as part of a PDI job.
Which job entry will accomplish this task?

HTTP

Sqoop import

Get a files with FTP

Copy Files

QUESTION 15
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

QUESTION 16
You are running a PDI Joband you need to identify when something fails for a specific job entry to notify the sysops team about the failure.
Which statement is correct in this scenario?

Define the true evaluation hop out of the job entry that you are going to verify.

Definethe false evaluation hop out of the job entry that you are going to verify.

Define the unconditional evaluation hop out of the job entry that you are going to verify.

Do not define any evaluation hop out of the Job entry that are going to verify.

QUESTION 17
You have instated the Pentaho server using an archive installation. You now want to change the server port.
Whichfile do you modify?

server.xml

repositories.xml

context.xml

slave-server-config.xml

QUESTION 18
An existing PDI job that checks the availability of a Web service is a sending a failure email even when the Web service is available.
You want this failure email to be sent only when the Web service is unavailable.
What should you do on tie hop between me two entries?

Flip the direction

Set the hop Evaluation option to Follow When.

Set the hop Evaluation option to Follow When Result a True.

Set the hop Evaluation option to Unconditional.

QUESTION 19
You are encryption your database connection password to use in the kettle. properties file. The output of the encr script is:
Encrypted XYZABC123
In this scenario, which syntax is correct?

DB_PASSWORD=Encrypted(‘XYZABC 123’)

DB_PASSWORD=String(‘XYZABC123’)

DB_PASSWORD=XYZABC123

DB_PASSWORD=Encrypted XYZABC123

QUESTION 20
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

QUESTION 21
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.

QUESTION 22
After monitoring a performance bottleneck in transformation you identified a user Defined Java Expression step as the problem.
Choose 2 answers

Replace the step with a Modified Java Script Value step

Increase the Change Number of Copies to Start for tie stop

Replace me step with a User Defined Java Class step

Split the step into multiple consecutive steps

QUESTION 23
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.

QUESTION 24
You have multiple transformations that read and process data from multiple text files. You identity a series of stepsthat are common across transformations and you want to re-use them to avoid duplication of code.
How do youaccomplishthis?

Use the “Mapping (sub-transformation)’ step containing the series of steps.

Use the ETL Metadata Infection’ stop containing the series of steps.

Use the “Get data from XML’ step to read the series of steps

Use the ‘Job Executor1 step containing the series of steps

QUESTION 25
You have a PDI job with an Oozie JobExecutor entry and you want this job entry to finish before the nextjob entry starts.
How do you accomplish this task?

Use a Simple Evaluationentry

Add the timeout property in the Advanced Options pane.

Use a Wait For entry

Set the Enable Blocking option

QUESTION 26
Which two PDI steps are used to parse XML content? (Choose two.)
Choose 2 answers

the ‘XML Join’ step

the ‘Modified Java Script Value’ stop

the ‘Get data from XML’ step

the ‘Add XML’step

QUESTION 27
A customer has an archive-basedinstallation. 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/logpentaho/server/pentaho-solution/system/karaf/System/commons logging

QUESTION 28
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

QUESTION 29
You are running a PDI Job and you need to identify when something fails for a specific job entry to notify the sysops team about the failure.
Which statement is correct in this scenario?

Define the true evaluation hop out of the job entry that you are going to verify.

Define the false evaluation hop out of the job entry that you are going to verify.

Define the unconditional evaluation hop out of the job entry that you are going to verify.

Do not define any evaluation hop out of the Job entry that are going to verify.

QUESTION 30
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.

QUESTION 31
A new customer has pre-existing Java MapReduce jobs.
How does the customer execute these jobs within PDI?

using the Pentaho MapReduce entry

using the Hadoop Job Executor entry

using Pig Script Executor entry

using Sqoop Import entry