nerdexam
CompTIA

SK0-004 · Question #22

A database server stops responding to requests, and the administrator suspects that the server is experiencing memory faults during heavy network traffic and database access. Which of the following…

The correct answer is B. Check the application logs. When a database server stops responding due to suspected memory or application faults, application logs are the first place to look for runtime error details.

Troubleshooting

Question

A database server stops responding to requests, and the administrator suspects that the server is experiencing memory faults during heavy network traffic and database access. Which of the following is the FIRST troubleshooting step?

Options

  • ACheck the security log.
  • BCheck the application logs.
  • CCheck the debug report.
  • DCheck the POST error log.

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    94% (32)
  • C
    3% (1)

Why each option

When a database server stops responding due to suspected memory or application faults, application logs are the first place to look for runtime error details.

ACheck the security log.

The security log records authentication and authorization events, not memory faults or application crashes.

BCheck the application logs.Correct

Application logs capture runtime events including memory allocation errors, exceptions, and performance warnings generated by the database service itself. Since the suspected cause is memory faults during database access - an application-layer event - the application log provides the most direct evidence of what went wrong. Security and POST logs do not record runtime memory or application errors.

CCheck the debug report.

A debug report is a specialized artifact that must typically be configured in advance or generated manually, making it unlikely to exist for an unexpected failure.

DCheck the POST error log.

The POST error log records hardware-level errors detected at boot time, not runtime memory faults during normal operation.

Concept tested: Server log analysis for runtime application faults

Source: https://learn.microsoft.com/en-us/windows-server/administration/windows-commands/eventvwr

Topics

#memory faults#application logs#server performance#log analysis

Community Discussion

No community discussion yet for this question.

Full SK0-004 Practice