HCE-5920 practice question 2 of 15

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?

Full set: 60 questions
Answer options
A: DB_PASSWORD=Encfypted("XYZABC 123*)
B: DB_PASSWORD=StringrXYZABC123")
C: DB_PASSWORD-XYZABC123
D: DB_PASSWORD-Encrypted XY2ABC123 Correct answer
Correct Answer:
D. DB_PASSWORD-Encrypted XY2ABC123
Explanation

The correct syntax for using an encrypted password in the kettle.properties file is VARIABLENAME=Encrypted . The Pentaho Data Integration (PDI) engine recognizes the Encrypted prefix and automatically decrypts the password string at runtime. The encr script generates this entire value string (Encrypted XYZabc123). Although option D contains typos (a hyphen - instead of an equals sign = and XY2 instead of XYZ), it is the only option that correctly reflects the required structure of the Encrypted keyword followed by a space and the encrypted value.

Why Incorrect

A. This option uses invalid function-like syntax with parentheses and quotes, ("..."), which is not the correct format for a value in a Java properties file.
B. This option uses an incorrect keyword (Stringr) and invalid syntax. PDI would not recognize this format for decryption.
C. This option lacks the mandatory Encrypted prefix. PDI would incorrectly interpret the value as a plaintext password, leading to connection failure.

References

1. Hitachi Vantara Pentaho Documentation

"Use Variables to Secure Database Connection Passwords": This official guide explicitly shows the correct syntax for using encrypted passwords in the kettle.properties file. In the "Set Variables in kettle.properties" section

it provides a clear example: DBPASSWORD=Encrypted 2be98afc86aa7f2e4cb79ce10df90acde. This confirms the KEY=Encrypted VALUE format.

Source: Hitachi Vantara Pentaho Documentation. Specific section on securing database passwords.

2. Hitachi Vantara Pentaho Documentation

"Encrypt Passwords in Configuration Files": This document details the usage of the encr.sh (or encr.bat) utility. It states

"The PDI client encrypts the password and returns the encrypted password to the command line with the prefix Encrypted." It then instructs the user to copy the entire output string into the relevant configuration file

reinforcing that the Encrypted prefix is part of the value itself.

Source: Hitachi Vantara Pentaho Documentation. Section on password encryption utilities.

Scroll to Top