Hitachi Vantara HCE-5920 Exam Questions Instant Access

Question 1

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?

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

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

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

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

Answer : C

https://help.hitachivantara.com/Documentation/Pentaho/8.2/Products/Data_Integration/Command_Line_Tools

Question 2

Which statement is true for a transformation?

ATransformation steps are executed in parallel.

BA transformation must have a start step.

CA transformation step processes one row at a time.

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

Answer : B

Question 3

You have a job that uses a Pentaho MapReduce entry to read four input files, and that outputs words and their counts to one output file.

How should you set the number of reducer tasks?

ASet it to blank.

BSet it to 0.

CSet it to 1.

DSet it to 4.

Answer : A

Question 4

Which two statements are correct about the Repository Explorer? (Choose two.)

Choose 2 answers

AYou can create new jobs and transformations.

BYou can move. rename, and delete jobs and transformations.

CYou can upload JDBC drivers when defining JOBC connections.

DYou can lock and unlock jobs and transformations.

Answer : B, D

https://help.hitachivantara.com/Documentation/Pentaho/7.0/0L0/0Y0/040/010

Question 5

You have used for copies of the Sort rows step in parallel on the local JVM using the 'Change number of copies to start option.

Each of the sorted stream need to be merged together to ensure the proper sort sequence.

Which step should be used in this scenario?

Athe Sorted Merge step

Bthe Merge Join step

Cthe Dummy step

Dthe Append Streams step

Answer : B

Question 6

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

AUse the pan script

BUse the import-export script.

CUsing Spoon Tools > Repository > import Repository

DUse the encr script.

Answer : B, C

https://help.hitachivantara.com/Documentation/Pentaho/6.0/0P0/0U0/040

Question 7

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

AWhen caching is enable, only rows with matching lookup values will passed through.

BThere must be enough allocated heap space to store the lookup fields allocated heap space to store the lookup fields in memory.

CCached comparisons are case sensitive.

DEvery input row must have only one matching row in the lookup table

EOnly one matching row is used from the Lookup table.

Answer : A, B, C

Hitachi Vantara Certified Specialist Pentaho Data Integration Implementation HCE-5920 Exam Questions