CompTIA Data+ DA0-002 (V2) Practice Question

The correct answer is to enable verbose logging. When faced with an intermittent issue and a generic error message, the primary goal is to gather more information to identify the root cause. Enabling detailed or verbose logging is the standard method for capturing specific error codes, system states, or problematic data points at the exact time of failure.

• Rewriting the SQL query is a potential solution, but it is premature. Without evidence that the query is the problem, this is a speculative fix that may waste time.
• Consulting vendor communities is a valid troubleshooting step, but it is ineffective without a specific error message or details. Posting about a "generic error" is unlikely to yield a useful solution.
• Restoring the database from a backup is a drastic and inappropriate action for this type of issue. It is a solution for data corruption or catastrophic failure, not an intermittent application error, and would cause significant disruption.