Online Access Free HCE-5920 Practice Test

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?

• A.Add a transformation entry in the job that uses theGet Variables step.
• B.Change the reference in the Table input step to '?'
• C.Add a transformation entry in the job that sets the table_name variable.
• D.Add a Set Variable step before the Table input step in the transformation.

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?

• A.DB_PASSWORD=Encrypted XYZABC123
• B.DB_PASSWORD=XYZABC123
• C.DB_PASSWORD=Encrypted('XYZABC 123')
• D.DB_PASSWORD=String('XYZABC123')

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

• A.shared.xml
• B.kettle.properties
• C.context.xml
• D.repositories.xml

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?

• A.the Sorted Merge step
• B.the Dummy step
• C.the Merge Join step
• D.the Append Streams step

You need to design a PDI job that will execute a transformation andthen 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

• A.In the mail entry's options, select the 'Attach files to message' option and select the filetype 'Log'
• B.In the log tab of job properties, configure the Log Connection and the Log table options for the Job entry log tablesection.
• C.In the Transformation entry option, select the 'Specify logfile' option and enter a name and extension for the file.
• D.In the Mail entry's options, select the 'Attach files to message' option and select the file type General'