nerdexam
CompTIA

DA0-002 · Question #87

A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analyst do first to troubl

The correct answer is C. Verify the connection to the database.. Given a report stopped working after a database upgrade, the first troubleshooting step is to verify the connection, as an upgrade often involves changes that can break existing database links.

Visualization and Reporting

Question

A report triggers an error that prevents information from being displayed. However, the report was functional before a database upgrade. Which of the following should a data analyst do first to troubleshoot the problem?

Options

  • AEnsure the system has permissions for the report service.
  • BChange the report's refresh rate.
  • CVerify the connection to the database.
  • DCheck whether the data structures were modified.

How the community answered

(36 responses)
  • A
    8% (3)
  • B
    3% (1)
  • C
    83% (30)
  • D
    6% (2)

Why each option

Given a report stopped working after a database upgrade, the first troubleshooting step is to verify the connection, as an upgrade often involves changes that can break existing database links.

AEnsure the system has permissions for the report service.

While permissions are important, a database upgrade is less likely to immediately break existing system-level permissions for a report service compared to affecting the direct database connection itself.

BChange the report's refresh rate.

Changing the refresh rate is a display or performance setting and will not resolve an underlying connection error that prevents data from being displayed at all.

CVerify the connection to the database.Correct

A database upgrade can alter connection strings, user credentials, network configurations, or driver compatibility, directly impacting the report's ability to communicate with the database. Verifying the connection ensures that the reporting service can still establish a valid link to the upgraded database, which is fundamental for data retrieval.

DCheck whether the data structures were modified.

Checking data structure modifications is a valid next step if the connection is confirmed, but it's secondary to ensuring the report can actually reach the database post-upgrade.

Concept tested: Database connection troubleshooting post-upgrade

Topics

#Troubleshooting#Database Connectivity#Report Errors#Data Sources

Community Discussion

No community discussion yet for this question.

Full DA0-002 Practice