Which of the following are the most likely causes?

Over the weekend, a company’s transaction database was moved to an upgraded server. All validations performed after the migration indicated that the database was functioning as expected. However, on Monday morning, multiple users reported that the corporate reporting application was not working.

Which of the following are the most likely causes? (Choose two.)
A . The access permissions for the service account used by the reporting application were not changed.
B . The new database server has its own reporting system, so the old one is not needed.
C . The reporting jobs that could not process during the database migration have locked the application.
D . The reporting application’s mapping to the database location was not updated.
E . The database server is not permitted to fulfill requests from a reporting application.
F . The reporting application cannot keep up with the new, faster response from the database.

View Answer

Answer: A, D

Explanation:

The most likely causes of the reporting application not working are that the access permissions for the service account used by the reporting application were not changed, and that the reporting application’s mapping to the database location was not updated. These two factors could prevent the reporting application from accessing the new database server. The other options are either irrelevant or unlikely to cause the problem.

Reference: CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.2 Given a scenario, troubleshoot common database issues.