Which of the following would have most likely prevented this issue?

A DBA left the company, and the DBA’s account was removed from the system. Soon after, scheduled jobs began failing.

Which of the following would have most likely prevented this issue?
A . Load balancing
B . Business continuity plan
C . Service accounts
D . Assigning a data steward

View Answer

Answer: C

Explanation:

The most likely way to prevent this issue is to use service accounts. Service accounts are special accounts that are used by applications or services to perform tasks or run jobs on behalf of users. Service accounts have limited permissions and access rights that are tailored to their specific functions. By using service accounts, the DBA can ensure that scheduled jobs can run independently of individual user accounts, and avoid failures due to account removal or changes. The other options are either not related or not effective for this issue. For example, load balancing is a technique that distributes the workload across multiple servers or resources to improve performance and availability; business continuity plan is a plan that outlines how an organization will continue its operations in the event of a disaster or disruption; assigning a data steward is a process that designates a person who is responsible for ensuring the quality and governance of data.

Reference: CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.3 Given a scenario, migrate data between databases.