Hitachi Vantara HCE-5920 Exam Practice Test Instant Access

Question 1

According to Hitachi vantara best practices, which three statements arc true when designing a realtime streaming, solution? (Choose me.)

Choose 3 answers

AData duplication detection and management should be handled during realtime data processing.

BYou should enable error handing on each step that could cause a message parsing fatal error.

CThe Kafka Consumer step has an offset setting that allows records to be reprocessed in the event of failure.

DUsing sorts during data ingestion can block downstream processing.

EYou should process data in large batches to make sure it is processed as soon as possible.

Answer : A, C, E

Question 2

You need to download files from a web site as part of a PDI job.

Which job entry will accomplish this task?

AHTTP

BSqoop import

CGet a files with FTP

DCopy Files

Answer : A

Question 3

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?

ADB_PASSWORD=Encfypted('XYZABC 123*)

BDB_PASSWORD=StringrXYZABC123')

CDB_PASSWORD-XYZABC123

DDB_PASSWORD-Encrypted XY2ABC123

Answer : A

Question 4

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?

AUse JNDI to specify the SQL statements.

BUse the Advanced section in the Database Connection window to enter the SQL statements.

CUse the Options section in the Database Connection windows and pass the SQL statements to the database as a parameter.

DUse the Database Connection wizard and specify SQL statements.

Answer : C

Question 5

To simplify the migration of a PDI solution from one environment to another, you need to externalize all database connection details.

Which two methods will satisfy this requirement? (Choose two.)

Choose 2 answers

AUse the Data Source Wizard to generate the connection details.

BCreate a properties file that includes the connection details and use the Set Variables step to load these properties.

CUse Manage Data Source to create a new connection in Spoon.

DSet the connection details in the Kettle properties file.

Answer : A, D

Question 6

You have a PDI input step that generates data within a transformation.

Which two statements are true about downstream steps in this scenario? (Choose two.)

Choose 2 answers

AThe steps will receive a stream of data from the input as soon as it is a available.

BOnly one step can receive data from the input step.

CThe steps will receive the data once the input step fully fetches it.

DMultiple steps can receive data from the input step.

Answer : C, D

Question 7

What are two ways to schedule a PDI job stored in the repository? (Choose two.)

Choose 2 answers

AWrite a login script to start the timer and execute a kitchen script specifying a job in the repository.

BUse the pan script specifying a job in the repository and schedule it using cron.

CUse the kitchen script specifying a job in the repository and schedule it using cron.

DUse Spoon connected to the Pentaho repository and choose Action > Schedule in the menu.

Answer : B, C

https://help.hitachivantara.com/Documentation/Pentaho/8.1/Products/Data_Integration/Schedule_Perspective#:~:text=or%20kitchen%20commands.-,Schedule%20a%20Transformation%20or%20Job,The%20Schedule%20window%20appears.

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