Which statement describes what will happen when the above code is executed?

The security team is exploring whether or not the Databricks secrets module can be leveraged for connecting to an external database.

After testing the code with all Python variables being defined with strings, they upload the password to the secrets module and configure the correct permissions for the currently active user. They then modify their code to the following (leaving all other variables unchanged).

Which statement describes what will happen when the above code is executed?
A . The connection to the external table will fail; the string "redacted" will be printed.
B . An interactive input box will appear in the notebook; if the right password is provided, the connection will succeed and the encoded password will be saved to DBFS.
C . An interactive input box will appear in the notebook; if the right password is provided, the connection will succeed and the password will be printed in plain text.
D . The connection to the external table will succeed; the string value of password will be printed in plain text.
E . The connection to the external table will succeed; the string "redacted" will be printed.

View Answer

Answer: E

Explanation:

This is the correct answer because the code is using the dbutils.secrets.get method to retrieve the password from the secrets module and store it in a variable. The secrets module allows users to securely store and access sensitive information such as passwords, tokens, or API keys. The connection to the external table will succeed because the password variable will contain the actual password value. However, when printing the password variable, the string “redacted” will be displayed instead of the plain text password, as a security measure to prevent exposing sensitive information in notebooks.

Verified Reference: [Databricks Certified Data Engineer Professional],

under “Security & Governance” section; Databricks Documentation, under “Secrets” section.