DA0-002 · Question #75
A data analyst receives an email from the IT department about renewing the company password, and the analyst follows the password reset link as required. Later in the week, the analyst receives the fo
The correct answer is C. The analyst did not change the password used to launch the report.. After a password reset, applications or reports using stored credentials must have those credentials manually updated.
Question
A data analyst receives an email from the IT department about renewing the company password, and the analyst follows the password reset link as required. Later in the week, the analyst receives the following notification when running a recurring analysis that connects to the database:
Log-in failed for user '<username>' Which of the following is most likely the reason for this issue?
Options
- AThe company changed its database authentication method.
- BThe password expiration process locked the account.
- CThe analyst did not change the password used to launch the report.
- DThe company is experiencing issues with password replication.
How the community answered
(18 responses)- A11% (2)
- B6% (1)
- C78% (14)
- D6% (1)
Why each option
After a password reset, applications or reports using stored credentials must have those credentials manually updated.
A change in the company's database authentication method would likely affect all users or connections, not just a single report failing after a personal password reset.
A password expiration process typically locks the account completely, preventing any login, rather than just failing a specific report's connection.
Many reports or automated tasks use embedded or stored credentials that do not automatically update when a user's password changes, requiring a manual update of the report's connection string or stored password.
Password replication issues are generally related to directory services (like Active Directory) syncing passwords across servers, which is less likely to be the direct cause of a single report failing after a user's manual password reset.
Concept tested: Database connection security and credential management
Source: https://learn.microsoft.com/en-us/sql/relational-databases/security/password-policy
Topics
Community Discussion
No community discussion yet for this question.