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?

The correct answer is C. Service accounts. Service accounts are non-personal accounts created specifically to run automated tasks, scheduled jobs, and background services - they are not tied to any individual employee. If the scheduled jobs had been configured to run under a service account instead of the DBA's personal…

Data and Database Security

Question

Options

ALoad balancing
BBusiness continuity plan
CService accounts
DAssigning a data steward

How the community answered

(18 responses)

C
94% (17)
D
6% (1)

Explanation

Service accounts are non-personal accounts created specifically to run automated tasks, scheduled jobs, and background services - they are not tied to any individual employee. If the scheduled jobs had been configured to run under a service account instead of the DBA's personal account, removing the DBA's personal account would not have affected the jobs. Load balancing (A) distributes traffic across servers and has no bearing on job ownership. A business continuity plan (B) addresses disaster recovery at a higher level, not individual account dependencies. Assigning a data steward (D) is a data governance role and does not address the technical dependency on a personal user account.

Topics

#Service accounts#Scheduled tasks#Account management#Security best practices

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice