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?
The code uses Databricks utilities to fetch and use a secret value from the secrets module. When fetching a password from the secrets scope and printing it, Databricks redacts the output to avoid exposing sensitive information. Therefore, when the script executes, sensitive information like passwords stored in the secret scope will not be shown in plain text; instead, 'REDACTED' will be printed to safeguard the secret. Thus, the correct outcome is that the connection to the external database will succeed, and 'REDACTED' will be printed.
A is correct
Answer A : When using Databricks secrets, the actual value of the secret is typically protected from being displayed in plain text. Databricks automatically redacts secret values when they are printed in the notebook. So, when you use the print(password) statement, the output will not show the actual password but will instead show [REDACTED].
A. A. The connection to the external table will succeed; the string "REDACTED" will be printed.