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

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?

AUse the Metadata structure of stream step for each file.

BUse the Transformation Executor step for each file.

CUse the ETL Metadata injection step

DUse the Job Executor step for each file.

Answer : C

Question 7

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?

AChange the Parameters of the transformation

BChange the Run Configuration of the transformation

CChange the Logging options of the transformation

DChange the Arguments of the transformation

Answer : B

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