Instant Download HCE-5920 Dumps Q&As Provide PDF&Test Engine [Q23-Q44]

Rate this post

Instant Download HCE-5920 Dumps Q&As Provide PDF&Test Engine

Fast Exam Updates HCE-5920 dumps with PDF Test Engine Practice

Hitachi HCE-5920 Exam Syllabus Topics:

Topic	Details
Topic 1	Describe how data flows within PDI jobs and transformations Demonstrate knowledge of the steps used to create a PDI job
Topic 2	Demonstrate knowledge of Pentaho Server installation and configuration Describe the Data Integration client and server components
Topic 3	Demonstrate knowledge of how to manage data connections in PDI Describe how to use streaming steps

Q23. You need to load data from many CSV files into a 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 andhave 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.

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

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

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

Q27. A customer needs to extract data from many afferent text He layouts with new file layouts being identified in the future andthey want to insert the data into corresponding database tables.They are concerned about maintainingmultiple PDI jobs and transformations given the large number of unique files.
What should you do to meet the requirements when creating transformations?

Use the Metadata structure of stream step for each file.

Use the Transformation Executor step for each file.

Use the ETL Metadata injection step

Use the Job Executor step for each file.

Q28. Which three file formats are splittable on HDFS? (Choose three).
Choose 3 answers
Choose 3 answers

txt

xml

Parquet

xisx

Avro

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

Q30. 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 satisfythisrequirement?

Change the Parameters of the transformation

Change the Run Configuration of the transformation

Change the Logging options of the transformation

Change the Arguments of the transformation

Q31. You need to design a PDI job that will execute a transformation and then send an e-mail with an attached log of the transformation’s execution.
Which two sets of actions will accomplish this task? (Choose two.)
Choose 2 answers

In the mail entry’s options, select the ‘Attach files to message’ option and select the file type ‘Log’

In the Transformation entry option, select the ‘Specify logfile’ option and enter a name and extension for the file.

In the log tab of job properties, configure the Log Connection and the Log table options for the Job entry log table section.

In the Mail entry’s options, select the ‘Attach files to message’ option and select the file type General’

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

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

Q34. You have a PDI job that gets a list of variables followed by three subsequent transformation entries. Since the three subsequent transformation entries are not dependent on each other. You want to execute them at the same time.
According the Hitachi Vantara best practices, how do you accomplish this task?

Select the Run Next Entries in Parallel option for the job entry that gathers variables.

Select the Run Next Entries in Parallel option for the three independent transformation entries.

Select the Enable Downstream setting from the Hop Bulk Change submenu.

Increase the Change Number of Copies to Start option on the input step of each of the subsequenttransformations.

Q35. Which script will execute jobs stored in a Pentaho server from a command line?

pan

carle

kitchen

spoon

Q36. Which PDI step or entry processes data within the Hadoop cluster?

the Hadoop File Output step

the Hadoop Fie Input step

the Pentaho MapReduce entry

the Hadoop Copy files entry

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

Write a login script to startthe timer and execute a kitchen script specifying a job in the repository.

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

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

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

Q38. You need to populate a fact table with the corresponding surrogate keys from each dimension table Which two steps accomplish this task? (Choose two.) Choose 2 answers

the ‘Combination lookup/update’ step

the Dimension lookup/update’ step

the ‘Select values’ step

the ‘Filter rows’ step

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

Q40. What must be the first PDI step in a child transformation ingesting records from Kafka?

Get rows from result

Get records from stream

Kafka Consumer

Get data from Kafka

Q41. You have a PDI job where you want to dynamically pass a table name to the Table input step of a transformation. You have replacedthe table name reference in the transformation’s Table input step with’$(table_name)’ but when the transformation runs the table name is shown as ‘$(table_name)’ Which action will correct this issue?

Add a transformation entry in the job that uses theGet Variables step.

Add a transformation entry in the job that sets the table_name variable.

Change the reference in the Table input step to ‘?’

Add a Set Variable step before the Table input step in the transformation.

Q42. When deploying your work lo the Pentaho server, which configuration Me should you review to ensure that the environment variable information is moved correctly?

repositories.xml

shared.xml

kettle.properties

context.xml

Q43. You are planning to connect to a secured Hadoop duster
from Pentaho.
Which two authentication methods are supported? (Choose two)
Choose 2 answers

Trusted

Keytan

Password

X.509 Certificate

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