nerdexam
CompTIA

CV0-002 · Question #605

A cloud application uses clustered database servers for a large website. Users are reporting occasional trouble logging into the site. Logs show this only happens when users connect to one particular

The correct answer is B. Server certificate expiration. When login issues for a clustered database reoccur consistently on one specific server after a multi-month interval, the most probable cause to check first is the expiration of a server certificate.

Troubleshooting

Question

A cloud application uses clustered database servers for a large website. Users are reporting occasional trouble logging into the site. Logs show this only happens when users connect to one particular database server. A reboot of the database server fixes the issue temporarily, but then it reoccurs after three months. Which of the following should the administrator check FIRST?

Options

  • AUser password expiration
  • BServer certificate expiration
  • CDatabase version mismatch
  • DTime synchronization

How the community answered

(52 responses)
  • A
    12% (6)
  • B
    60% (31)
  • C
    6% (3)
  • D
    23% (12)

Why each option

When login issues for a clustered database reoccur consistently on one specific server after a multi-month interval, the most probable cause to check first is the expiration of a server certificate.

AUser password expiration

User password expiration would affect all users attempting to log in, regardless of the specific database server they connect to, and would likely not reoccur precisely every three months after a reboot.

BServer certificate expirationCorrect

Server certificate expiration is a common issue that causes authentication failures for specific servers, especially if connections rely on TLS/SSL for security, which would affect user logins. The recurring nature of the problem every three months, fixed temporarily by a reboot, strongly suggests a certificate with a three-month validity period or a certificate that expires after a specific renewal cycle, as reboots often clear temporary cached states.

CDatabase version mismatch

A database version mismatch would typically cause persistent and immediate issues across all relevant connections to that server, not temporary issues that reoccur after several months and are fixed by a reboot.

DTime synchronization

Time synchronization issues, while critical for clustered environments and authentication, usually lead to immediate and consistent authentication failures or cluster instability, not a temporary problem that reoccurs every three months on a single server.

Concept tested: Troubleshooting server certificate expiration

Source: https://learn.microsoft.com/en-us/azure/security/fundamentals/tls-certificate-management

Topics

#troubleshooting#certificate expiration#database clusters#application access

Community Discussion

No community discussion yet for this question.

Full CV0-002 Practice