[Oct-2022] Latest HCE-5920 Exam Dumps for Pass Guaranteed [Q35-Q54]

Rate this post

[Oct-2022] Latest HCE-5920 Exam Dumps for Pass Guaranteed

Reliable Hitachi Vantara Certified Specialist HCE-5920 Dumps PDF Oct 19, 2022 Recently Updated Questions

NEW QUESTION 35
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

NEW QUESTION 36
you want to enable PDI step monitoring Since memory resources are limited. you decide to set a limit to vie number of snapshots.
Which option should be used to accomplish this task?

the Logging interval(seconds)’ option in the Performance section

The ‘Limit’ option in the Snapshot tab

the ‘KETTLE_MAX_JOB_TRACKER_SIZE’ option in kettle properties.

The ‘Maximum number of snapshots in memory option in the Monitoring tab

NEW QUESTION 37
You have a PDI job with an Oozie Job Executor entry and you want this job entry to finish before the next fob entry starts.
How do you accomplish this task?

Use a Simple Evaluation entry

Add the timeout property in the Advanced Options pane.

Use a Wart For entry

Set the Enable Blocking option

NEW QUESTION 38
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=Encfypted(“XYZABC 123*)

DB_PASSWORD=StringrXYZABC123″)

DB_PASSWORD-XYZABC123

DB_PASSWORD-Encrypted XY2ABC123

NEW QUESTION 39
Which two steps in a transformation allow variable values to be used throughout the rest of a PDI job?
(Choose two.)
Choose 2 answers

the ‘Set Variables’ step

the ‘Select values’ step

the ‘Table inpuT step

the Modified Java Script Value’ step

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

pan

carle

kitchen

spoon

NEW QUESTION 41
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

NEW QUESTION 42
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.

NEW QUESTION 43
A Big Datacustomer is experiencing failures on a Tableinput stepwhen running a PDl transformation on AEL Sparkagainst 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.

NEW QUESTION 44
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

NEW QUESTION 45
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

NEW QUESTION 46
You are adding an ‘MD5_ Value’ column to the dimension table to uniquely identify a record in the source system.
Which step should you use to accomplish this tasks?

the “String operations’ step

the ‘Formula’ step

the ‘Concat Fields’ step

the’ Add a checksum’ step

NEW QUESTION 47
You are preparing a server environment for an archive installation of a Pentaho server According to Hitachi Vantara best practices which environment variable should be set?

KETTLEHOME

JAVA_HOME

PENTAHO_JAVA_HOME

SPOON HOME

NEW QUESTION 48
Which three file formats are splittable on HDFS? (Choose three).
Choose 3 answers
Choose 3 answers

txt

xml

Parquet

xisx

Avro

NEW QUESTION 49
A client is developing a Web application to implement a wizard-like application used by many users. At several points in the workflow, the application needs to execute jobs and transformations that are stored in the Pentaho server. Execution will include user-specific parameters. Upon completion of the job or transformation, the Web application will continue to the next UI page.
What is the recommended approach to accomplish this task?

Use the Web service API to execute the jobs and transformations on the Pentaho server.

Use the scheduling tool of the OS to execute the job and transformation on the pentaho server.

Use the Kitchen and pan scripts to execute the jobs and transformations on the Pentaho server.

Use the Job and Transformation steps to execute the jobs and transformations on the Pentaho server.

NEW QUESTION 50
Which statement is true for a transformation?

Transformation steps are executed in parallel.

Atransformation must have a start step.

A transformation step processes one row at a time.

A transformation step can have only one incoming hop and one outgoing hop.

NEW QUESTION 51
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

NEW QUESTION 52
In a PDI transformation you are retrieving data from a large lookup table using a Database Lookup stepfromimprove 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.

NEW QUESTION 53
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

NEW QUESTION 54
You are running a Pentaho MapReduce (PMR) job that is facing on Hadoop.You review the YARN logs and determine that the mappersare generating out of memory errors.
Which action will resolve the mapper errors?

Edit me Pentahoserver startup script to increase the memory setting

Increase the Number of mapper tacks in the PMR step.

Set the JVM memory parameters appropriatelyin the User Denned tab ofthe PMR step

Set the Enable blocking option in the PMR step.